SQLyog 连接MySQL时出现的 2058错误解决方法

java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

解决方法：windows 下cmd 登录 mysql -u root -p 登录你的 mysql 数据库，然后执行这条SQL：

ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;（注意分号）

#password 是你自己设置的root密

如果出现 ERROR 1396 (HY000): Operation ALTER USER failed for ‘ftroot’@‘localhost’ 将sql 改成下面的sql

ALTER USER ‘ftroot’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;