laradock mysql8.0 navcat连接
这时候使用navicat连接mysql还是不行的,因为mysql8修改了加密方式,依次执行如下命令
docker-compose exec mysql bash
root@e8d56a0bad78:/ mysql -uroot -p
mysql> grant all PRIVILEGES on *.* to root@’%’ WITH GRANT OPTION;
mysql> ALTER user ‘root’@’%’ IDENTIFIED BY ‘123456’ PASSWORD EXPIRE NEVER;
mysql> ALTER user ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘root’;
mysql> FLUSH PRIVILEGES;
mysql> exit;
navicat连接成功