docker安装mysql8.0

1，下载docker镜像

docker pull mysql:8.0

2，建立主机目录

mkdir -p /opt/mysql/conf /opt/mysql/data /opt/mysql/logs

3，创建mysql8.0配置文件

vim /opt/mysql/conf/my.cnf

[mysqld]
#datadir=/usr/local/mysql/data
default_authentication_plugin=mysql_native_password  #使用mysql8以前的密码插件，以便navicat等工具能够正常连接
default-storage-engine=INNODB
character_set_server = utf8
secure_file_priv=/var/lib/mysql
[mysqld_safe]
character_set_server = utf8
[mysql]
default-character-set = utf8
[mysql.server]
default-character-set = utf8
[client]
default-character-set = utf8

4，创建容器脚本

vim /opt/mysql/docker.sh

docker run -p 3306:3306 --name mysql \
-v /opt/mysql/logs:/var/log/mysql \
-v /opt/mysql/data:/var/lib/mysql \
-v /opt/mysql/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=root \
-d mysql:8.0

./docker.sh

5，配置mysql对外开放连接权限（如果外界navicat联不通，一般docker版的mysql是可以从外界直接连通的）

docker exec -it mysql mysql -uroot -proot

use mysql

select host,user from user;

update user set host = '%' where user = 'root';

flush privileges;

select host,user from user;