Docker安装mysql8.0

拉mysql镜像

sudo docker pull mysql:8.0

sudo docker images

创建挂载目录

sudo mkdir -p /data/mysql/log
sudo mkdir -p /data/mysql/data
sudo mkdir -p /data/mysql/conf

创建配置文件

sudo vim /data/mysql/conf/my.conf

[client]
port = 3306
default-character-set = utf8mb4

[mysql]
port = 3306
default-character-set = utf8mb4

[mysqld]
port = 3306

# 字符集
character_set_server=utf8mb4
collation-server=utf8mb4_unicode_ci

# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB

# 最大连接数
max_connections = 10000

启用容器

sudo docker run  --restart=always  --name mysql8.0  -v /data/mysql/conf:/etc/mysql  -v /data/mysql/data:/var/lib/mysql  -v /data/mysql/log:/var/log  -v /data/mysql/mysql-files:/var/lib/mysql-files -v /etc/localtime:/etc/localtime:ro -p 3306:3306  -e MYSQL_ROOT_PASSWORD=mysql123   -d mysql:8.0

sudo docker ps -a

远程连接mysql

sudo docker exec -it mysql8.0 /bin/bash

# 首次连接mysql密码为空
mysql -uroot -p

# 直接回车
use mysql;
SELECT Host, User, plugin from user;

# 解决user表内没有host为%的数据

insert into user (`HOST`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `Event_priv`, `Trigger_priv`, `Create_tablespace_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`, `plugin`, `authentication_string`, `password_expired`, `password_last_changed`, `password_lifetime`, `account_locked`) SELECT '%',`User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `Event_priv`, `Trigger_priv`, `Create_tablespace_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`, `plugin`, `authentication_string`, `password_expired`, `password_last_changed`, `password_lifetime`, `account_locked` FROM user WHERE `User` = 'root';

# 修改密码加密规则
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY ‘mysql123’;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY ‘mysql123’;

# 刷新权限，使修改的密码生效
FLUSH PRIVILEGES;