mysql 
mysql10用Sequel Pro链接不上已关闭评论 mysql10用Sequel Pro链接不上
Mysql10:
通过navicat连接不上数据库：
https://blog.csdn.net/leo3070/article/details/117440146
mysql> use mysql;
Database changed
mysql> SELECT Host, User, plugin from user;
+———–+——————+———————–+
| Host | User | plugin |
+———–+——————+———————–+
| % | root | caching_sha2_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session | caching_sha2_password |
| localhost | mysql.sys | caching_sha2_password |
| localhost | root | caching_sha2_password |
+———–+——————+———————–+
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
ALTER USER ‘dev-admin’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘p3t3R@ft3r9!’;
FLUSH PRIVILEGES;
或者新建用户：
1；新建用户：
user mysql;
SELECT Host, User, plugin from user;
show grants for ‘#userName’@’#host’;
create user ‘cfg-dev-user’@’%’ identified by ‘afFd3jdkKld22sasf’;
grant all privileges on `cfg-dev`.* to ‘cfg-dev-use’@’%’ with grant option;