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

提示如下错误：

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

 

可能由于root的权限不够，可以进行如下操作

1)      以root进入mysql

2)      赋予root权限：

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'

->     IDENTIFIED BY 'password' WITH GRANT OPTION; 

//本地操作的权限

mysql> GRANT ALL PRIVILEGES ON *.* TO ' root '@'%'

->     IDENTIFIED BY 'password' WITH GRANT OPTION;

 //远程操作的权限

原帖地址：http://blog.csdn.net/honley_lee/article/details/5958454