宝塔山 发表于 2024-10-17 16:15:06

用SQLyog毗连mysql提示2058错误

1)在cmd下(必须是这个,不能是gitbash)
// step1:修改下数据库
C:\Users\elex>mysql -uroot -p
Enter password: ****
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 97
Server version: 8.1.0 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


// step2: 修改下密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
Query OK, 0 rows affected (0.07 sec) 2)可以毗连上了
https://i-blog.csdnimg.cn/direct/254276c8f752481cb9c6ae1e9924ec54.png

免责声明:如果侵犯了您的权益,请联系站长,我们会及时删除侵权内容,谢谢合作!更多信息从访问主页:qidao123.com:ToB企服之家,中国第一个企服评测及商务社交产业平台。
页: [1]
查看完整版本: 用SQLyog毗连mysql提示2058错误