JarCasting
JarCasting JarCasting

embedded-mysql-spring-boot-starter

Embedded MySQL Server

License

License
Categories

Categories

Spring Boot Container Microservices MySQL Data Databases
GroupId

GroupId

io.github.liuyuyu
ArtifactId

ArtifactId

embedded-mysql-spring-boot-parent
Last Version

Last Version

0.0.2
Release Date

Release Date
Type

Type

pom
Description

Description

embedded-mysql-spring-boot-starter
Embedded MySQL Server
Project URL

Project URL

https://github.com/liuyuyu/embedded-mysql-spring-boot
Source Code Management

Source Code Management

https://github.com/liuyuyu/embedded-mysql-spring-boot

Download embedded-mysql-spring-boot-parent

Filename Size
embedded-mysql-spring-boot-parent-0.0.2.pom 5 KB
Browse

How to add to project

<!-- https://jarcasting.com/artifacts/io.github.liuyuyu/embedded-mysql-spring-boot-parent/ -->
<dependency>
    <groupId>io.github.liuyuyu</groupId>
    <artifactId>embedded-mysql-spring-boot-parent</artifactId>
    <version>0.0.2</version>
    <type>pom</type>
</dependency>
// https://jarcasting.com/artifacts/io.github.liuyuyu/embedded-mysql-spring-boot-parent/
implementation 'io.github.liuyuyu:embedded-mysql-spring-boot-parent:0.0.2'
// https://jarcasting.com/artifacts/io.github.liuyuyu/embedded-mysql-spring-boot-parent/
implementation ("io.github.liuyuyu:embedded-mysql-spring-boot-parent:0.0.2")
'io.github.liuyuyu:embedded-mysql-spring-boot-parent:pom:0.0.2'
<dependency org="io.github.liuyuyu" name="embedded-mysql-spring-boot-parent" rev="0.0.2">
  <artifact name="embedded-mysql-spring-boot-parent" type="pom" />
</dependency>
@Grapes(
@Grab(group='io.github.liuyuyu', module='embedded-mysql-spring-boot-parent', version='0.0.2')
)
libraryDependencies += "io.github.liuyuyu" % "embedded-mysql-spring-boot-parent" % "0.0.2"
[io.github.liuyuyu/embedded-mysql-spring-boot-parent "0.0.2"]

Dependencies

There are no dependencies for this project. It is a standalone project that does not depend on any other jars.

Project Modules

  • embedded-mysql-spring-boot-starter

Embedded MySQL Spring Boot Starter

What It Is

It is an embedded MySQL for instead H2/Sqlite etc.

Before use,Please OPEN https://github.com/liuyuyu/embedded-mysql-spring-boot/blob/master/embedded-mysql-demo/README.md

Usage

add dependency in pom.xml

<dependency>
  <groupId>io.github.liuyuyu</groupId>
  <artifactId>embedded-mysql-spring-boot-starter</artifactId>
  <version>0.0.1</version>
</dependency>

application.properties

# Enable MySQL
spring.datasource.embedded.mysql.enable=true

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3333/test?useUnicode=true&characterEncoding=UTF-8&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2b8&nullNamePatternMatchesAll=true
# username. Always correct!
spring.datasource.username=test_user
# password. Always correct!
spring.datasource.password=

# MySQL port
spring.datasource.embedded.mysql.port=3333
# DML v1_1_function.sql,v1_2_init_data.sql
spring.datasource.embedded.mysql.script-locations=classpath:/sql/*.sql
# MySQL Version
spring.datasource.embedded.mysql.version=v5_6_21

Run XXXSpringApplication.java Console will output log like this first time

2019-04-19 19:54:11.110  INFO 14499 --- [           main] com.wix.mysql.EmbeddedMysql              : Preparing EmbeddedMysql version 'Version 5.6.21'...
Download Version 5.6.21:OS_X:B64 START
Download Version 5.6.21:OS_X:B64 DownloadSize: 173770339
Download Version 5.6.21:OS_X:B64 0%
Download Version 5.6.21:OS_X:B64 5%
...........
Download Version 5.6.21:OS_X:B64 100%
Download Version 5.6.21:OS_X:B64 downloaded with 747kb/s
Download Version 5.6.21:OS_X:B64 DONE
Extract /Users/liuyuyu/.embedmysql/MySQL-5.6/mysql-5.6.21-osx10.9-x86_64.tar.gz START
...........
Extract /Users/liuyuyu/.embedmysql/MySQL-5.6/mysql-5.6.21-osx10.9-x86_64.tar.gz DONE
2019-04-19 19:58:05.062  INFO 14499 --- [           main] com.wix.mysql.MysqldExecutable           : Preparing mysqld for startup
2019-04-19 19:58:08.772  INFO 14499 --- [           main] com.wix.mysql.MysqldExecutable           : Starting MysqldProcess
2019-04-19 19:58:09.369  INFO 14499 --- [           main] d.f.embed.process.runtime.Executable     : start com.wix.mysql.config.MysqldConfig@122635ef

enjoy it Luck Dog!

MySQL Version

spring.datasource.embedded.mysql.version

v5_5_40
v5_5_50
v5_5_51
v5_5_52
v5_5_latest
v5_6_21
v5_6_22
v5_6_23
v5_6_24
v5_6_31
v5_6_32
v5_6_33
v5_6_34
v5_6_35
v5_6_36
v5_6_latest
v5_7_10
v5_7_13
v5_7_14
v5_7_15
v5_7_16
v5_7_17
v5_7_18
v5_7_19
v5_7_latest

MySQL Installer Folder

If the download address is https://cdn.mysql.com//archives/mysql-5.6/mysql-5.6.21-winx64.zip, the installation directory is ~/.embedmysql/MySQL-5.6/mysql-5.6.21-winx64.zip, you can download the zip file yourself and extract it to the corresponding directory.

Versions

Version
0.0.2