Sqlyog configures a new connection and reports an error: the error number is 2058. It is analyzed that the MySQL password encryption method has changed
solution:
alter user ‘root’ @ ‘localhost’ identified with MySQL_ native_ password BY ‘password’; (note the semicolon)
#password is the root password you set yourself
after reconfiguring the connection of sqlyog, the connection is successful and it is OK.
Read More:
- How to Solve Logstash error: failed to execute action
- How to Solve “Error db.num is null” when starting Nacos
- How to Solve canal & MYSQL or “Kafka cannot consume data” Error
- How to Solve elasticsearch root user start Error
- How to Solve elasticsearch-7.15.1 operation errors
- How to Solve HiveServer2 & Beeline Error
- How to Solve Starrocks Various Error
- How to Solve Chrome Error: net::ERR_FAILED
- How to Solve Doris dynamic partition table routineload Error
- How to Solve Error: avoided redundant navigation to current location: “index/user”
- How to Solve jmeter Install Error (Three Common Errors)
- Duplicate entry ‘1’ for key’PRIMARY’ (How to Solve)
- IDEA: How to Solve spark source code Modified Error
- How to Solve DB2 uses Limit Error
- Android 10: How to Solve Systemui Error
- How to Solve Node GYP Rebuild Error
- How to Solve AD20 Channel-Offset Error
- MAC: How to Solve VirtualBox cannot open Issues
- How to Solve Ogg start error message ogg-00014
- How to Solve ClickHouse Connect Error: Connection refuse