vim /usr/local/mysql/my.cnf
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
default-time_zone = '+8:00'
authentication_policy=mysql_native_password
secure_file_priv=
init_connect='SET collation_connection = utf8mb4_0900_ai_ci'
init_connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
collation-server=utf8mb4_0900_ai_ci
skip-character-set-client-handshake
skip-name-resolve
docker pull mysql:latest
docker run -p 33063:3306 --privileged=true \
-v /mysql/data:/var/lib/mysql \
-v /mysql/log:/var/log/mysql \
-v /mysql/conf:/etc/mysql/conf.d \
-e MYSQL_ROOT_PASSWORD=123456 --name=mysql2 -d mysql:latest
远程连接mysql -uroot -p1234 -P 33063
docker常用命令
docker ps -a
docker exec -it mysql-server /bin/bash
docker logs -f mysql
docker stop mysql2
docker rm 00e44768094b f75ae0ba2e96
sql
mysql> grant select,update,insert,delete on *.* to root@^Cdentified by "root";
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0.01 sec)
FLUSH PRIVILEGES;