Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
因为没授权
mysql> select user,host from mysql.user;
+------+--------------------+
| user | host |
+------+--------------------+
| root | % |
| root | ::1 |
| root | localhost |
| root | vps.studiothem.com |
+------+--------------------+
4 rows in set (0.00 sec)
mysql> grant all on *.* to root@'%';
Query OK, 0 rows affected (0.05 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)