docker安装msyql数据库

1.安装mysql

docker run -itd --name mysql-test -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql

2.查看mysql是否安装成功

 docker ps

3.进入容器

docker exec -it mysql-test /bin/bash

4.登录mysql

mysql -u root -p

 5.查看mysql数据库

 show databases;

6.查看user表

select host,user,plugin from mysql.user;

7.修改权限

alter user 'root'@'%' identified with mysql_native_password by '123456';flush privileges;

8.navicat连接mysql