mysql root@localhost 没有权限

Question

我试图在 mysql 上创建一个表，但我一直在获取。

CONSOLE: [SEVERE] Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)

但我应该允许一切

mysql> SHOW GRANTS FOR 'root'@'localhost';
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost                                                                                                              |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*60BF85ECA0CB9AEA703C24F4B193EDE2A32A7879' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

我错过了什么？

Answer 1

好吧，看来这是你的问题(重点是我的):

CONSOLE: [SEVERE] Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)

显然您没有在连接详细信息中指定密码。