1.假如服务器已经安装了docker,启动docker:systemctl start docker
2.拉取mysql:docker pull mysql
3.创建容器:docker run ‐di ‐‐name=liaochao_mysql ‐p 3306:3306 ‐e
MYSQL_ROOT_PASSWORD=123456 mysql
这样会生成容器,查看容器名:docker ps -a
02deac876792
4.启动:docker start 02deac876792
5.进入容器:docker exec -it 02deac876792 /bin/bash (02deac876792 是容器名字)
6.登陆mysql: mysql -uroot -p,再输入密码
7.在服务器里连接上mysql,显示数据库
mysql> show databases
-> ;
*********************************************************************************************************
二.在桌面navcat连接mysql,报错:
Navicat连接Docker中的mysql报错:client does not support authentication………………
解决办法:1.进入mysql容器中
docker exec -it mysqltest(mysql容器名称) bash
2.进入mysql数据库
mysql -uroot -p
3.输入mysql密码
4.远程连接授权
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%'WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
5.更改加密规则
mysql>ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
6.更新root用户密码
mysql>ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘密码’;
7.刷新权限
mysql>FLUSH PRIVILEGES;