ToB企服应用市场:ToB评测及商务社交产业平台

标题: 用SQLyog毗连mysql提示2058错误 [打印本页]

作者: 宝塔山    时间: 2024-10-17 16:15
标题: 用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
  7. Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
  8. Oracle is a registered trademark of Oracle Corporation and/or its
  9. affiliates. Other names may be trademarks of their respective
  10. owners.
  11. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  12. // step2: 修改下密码
  13. mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
  14. Query OK, 0 rows affected (0.07 sec)
复制代码
2)可以毗连上了


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




欢迎光临 ToB企服应用市场:ToB评测及商务社交产业平台 (https://dis.qidao123.com/) Powered by Discuz! X3.4