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';
都不行还是这样,有遇到过类似的问题的老哥吗 我去抽根烟,收拾下掉地上的头发,一会儿回来继续