我就是把文件保存一份,而已!侵权立即删
自定义配置文件custom.cnf
不知道有什么用,照着抄的。
放在D:/workspace/workspacedocker/mysql5.7/conf/custom.cnf
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
init_connect="SET collation_connection = utf8mb4_unicode_ci"
init_connect="SET NAMES utf8mb4"
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
skip-character-set-client-handshake
skip-name-resolve
docker创建数据库
#拉取镜像
docker pull mysql:5.7
#启动
docker run --name mysql -v D:/workspace/workspacedocker/mysql5.7/log:/var/log/mysql -v D:/workspace/workspacedocker/mysql5.7/data:/var/lib/mysql -v D:/workspace/workspacedocker/mysql5.7/conf:/etc/mysql/conf.d -p 33060:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
#设置容器自启动
docker update --restart=always mysql
进入mysql改权限
#进入数据库
docker exec -it 这里是id /bin/bash
#root登录
mysql -u root -p123456
#用mysql库
use mysql;
select user,host from user;
#删除mysql数据库user表中 user=“root”,host="%"的那条记录,并刷新权限
delete user from mysql.user where user='root' and host='%';
#刷新账号权限
flush privileges;
#创建用户和密码
CREATE USER 'user123'@'%' IDENTIFIED BY '123456';
#授予账户特定权限
GRANT ALL ON *.* TO 'user123'@'%' WITH GRANT OPTION;
#刷新账号权限
flush privileges;