mysql 迁移 mariadb_MySQL迁移mariaDB

1.初始化

进入bin目录下执行

mysql_install_db

2.修改配置文件

进入data目录下,修改my.ini

[mysqld]

basedir=D:\Application\mariadb-10.4.12-winx64

datadir=D:\Application\mariadb-10.4.12-winx64\data

port=3307

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

default_storage_engine=innodb

max_connections=100

query_cache_size=0

innodb_strict_mode = 0

innodb_file_per_table=1

innodb_buffer_pool_size=2047M

innodb_log_file_size=50M

max_allowed_packet = 500M

character-set-server=utf8

log-bin=D:\Application\mariadb-10.4.12-winx64\log\mysql-bin

log_bin_index=D:\Application\mariadb-10.4.12-winx64\log\mysql-bin.index

log_bin_trust_function_creators=1

binlog_format=mixed

expire_logs_days=7

max_binlog_size=100m

binlog_cache_size=4m

max_binlog_cache_size=512m

[client]

port=3307

plugin-dir=D:/Application/mariadb-10.4.12-winx64/lib/plugin

3.注册服务

mysqld --install mariaDB

4.启动服务

net start mariaDB

5.修改密码

mysql -uroot -p

use mysql

ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("123456");

grant all privileges on * to root@'%' identified VIA mysql_native_password USING PASSWORD("123456");

flush privileges;

7.yml文件配置替换

添加dependency依赖

org.mariadb.jdbc

mariadb-java-client

1.1.7

mysql配置

driverClassName: com.mysql.jdbc.Driver

url: jdbc:mysql://${datasource.url}/gepadmin?useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT

mariadb配置

driverClassName: org.mariadb.jdbc.Driver

url: jdbc:mariadb://${datasource.url}/gepadmin?useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT