# 下面兩個命令效果一致
docker pull mysql
docker pull mysql:latest

# 查看可用版本
docker search mysql

docker images

docker run -p 3306:3306 --name mysql --restart=always --privileged=true \
-v /usr/local/mysql/log:/var/log/mysql \
-v /usr/local/mysql/data:/var/lib/mysql \
-v /usr/local/mysql/conf:/etc/mysql \
-v /etc/localtime:/etc/localtime:ro \
-e MYSQL_ROOT_PASSWORD=123456 -d mysql:latest

# 查看正在運行的容器
docker ps

# 查看所有容器
docker ps -a

docker logs -f mysql

Failed to access directory for --secure-file-priv. Please make sure that dir

Error response from daemon: Container xxx is restarting, wait until the cont...

docker exec -it mysql /bin/bash

cd /usr/local/mysql
ll
cd conf
vi my.cnf

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld]
# 設(shè)置東八區(qū)時區(qū)
default-time_zone = '+8:00'

# 設(shè)置密碼驗證規(guī)則（authentication_policy 替代已廢棄的 default_authentication_plugin）
authentication_policy=mysql_native_password

# 限制導(dǎo)入和導(dǎo)出的數(shù)據(jù)目錄
# 為空：不限制目錄；指定目錄：必須從該目錄導(dǎo)入導(dǎo)出；為 NULL：禁止導(dǎo)入導(dǎo)出功能
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 restart mysql

docker update mysql --restart=always

docker restart mysql

docker exec -it mysql /bin/bash

mysql -u root -p
# 直接回車進入（使用空密碼）

show databases;
use mysql;

select host, user from user;

ALTER USER root@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
update user set host = '%' where host = 'localhost' and user = 'root';

-- 刷新權(quán)限
flush privileges;

-- 退出 MySQL
exit

exit