拉取镜像
docker pull mysql:8.0
查看镜像
docker images
运行实例
docker run -p 3306 :3306 --name mysql --restart = always --privileged = true \
-v /data/mysql/log:/var/log/mysql \
-v /data/mysql/data:/var/lib/mysql \
-v /data/mysql/conf:/etc/mysql/conf.d \
-v /etc/localtime:/etc/localtime:ro \
-e MYSQL_ROOT_PASSWORD = root \
-d mysql:8.0
配置文件
[ 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_general_ci'
init_connect = 'SET NAMES utf8mb4'
character-set-server= utf8mb4
collation-server= utf8mb4_general_ci
skip-character-set-client-handshake
skip-name-resolve
重启MySQL
docker restart mysql
查看实例
docker ps
进入MySQL
docker exec -it mysql /bin/bash
访问MySQL
mysql -u root -p root
修改root权限
ALTER USER 'root' @'%' IDENTIFIED WITH mysql_native_password BY '8888' ;
GRANT ALL ON *.* TO 'root' @'%' ;
FLUSH PRIVILEGES;