MACOS mysql 5.7 Navicat 可以连接， Java 报错

This topic created in 2262 days ago, the information mentioned may be changed or developed.

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

找了半天了试过以下方法： GRANT ALL PRIVILEGES ON . TO root @'%' IDENTIFIED BY "123456"; FLUSH PRIVILEGES; GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; flush privileges; alter user 'root'@'localhost' identified with mysql_native_password by '123456';

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

都不行还是这样，有遇到过类似的问题的老哥吗我去抽根烟，收拾下掉地上的头发，一会儿回来继续

3 replies