用SQLyog毗连mysql提示2058错误

1)在cmd下(必须是这个,不能是gitbash)

1. // step1:修改下数据库
2. C:\Users\elex>mysql -uroot -p
3. Enter password: ****
4. Welcome to the MySQL monitor.  Commands end with ; or \g.
5. Your MySQL connection id is 97
6. Server version: 8.1.0 MySQL Community Server - GPL
8. Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
10. Oracle is a registered trademark of Oracle Corporation and/or its
11. affiliates. Other names may be trademarks of their respective
12. owners.
14. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
17. // step2: 修改下密码
18. mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
19. Query OK, 0 rows affected (0.07 sec)

复制代码

2)可以毗连上了

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。