如何使用navicat登陆mysql

docker exec -it mysql /bin/bash

 

#cd /usr/bin

 

#mysql -u root -p

 use mysql
从数据库的user表中查询 mysql 用户原来使用的身份验证插件

select user,host,plugin,authentication_string from user;

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