nacos 服务替换内置数据库

以下nacos是在单机模式下操作的（非集群）

1 下载安装docker

2 docker 安装 mysql 5.7

        docker pull mysql:5.7

        创建数据目录

        /usr/local/soft/mysql/conf

       /usr/local/soft/mysql/logs

      /usr/local/soft/mysql/mysql

 conf 创建文件 my.conf

编辑文件

[client]

default-character-set = utf8mb4

[mysql]

default-character-set = utf8mb4

[mysqld]

character-set-client-handshake = FALSE

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

init_connect='SET NAMES utf8mb4'

default-time_zone = '+8:00' #默认时区配置

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

#设置数据库支持分组

lower_case_table_names=1 #表名不区分大小写

运行镜像 把数据从内部挂载出来

docker run --restart always -p 3306:3306 --name mysql -v /usr/local/soft/mysql/conf/my.conf:/etc/mysql/my.cnf -v /usr/local/soft/mysql/logs:/logs -v /usr/local/soft/mysql/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7

进入镜像

docker exec -it mysql bash

进入mysql

mysql -uroot -p

设置远程登录

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Admin123!' WITH GRANT OPTION;
flush privileges;

参考链接：https://www.jianshu.com/p/cb4ad4e824ff

修改 nacos/conf/application.properties 文件

spring.datasource.platform=mysql

db.num=1

db.url.0=jdbc:mysql://127.0.0.1:3306/nacos?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true

db.user=用户名

db.password=密码

重启 nacos