在使用JDBC的时候出现:java.sql.Exception:Access denied for user ‘root’@‘10.220.1.84’ (using password: YES),以前也出现过这个问题,这是因为MySQL用户没有授权远程操作权限导致的,需要给MySQL的root用户赋予相对应的权限,具体操作为:
1.登陆mysql本地客户端:
mysql>mysql -u root -p;
2.赋予操作权限:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password123456' WITH GRANT OPTION;
#其中:password123456为远程登陆的密码
#GRANT ALL PRIVILEGES的语法为:
#GRANT ALL PRIVILEGES on 库名.表名 to '用户名'@'IP地址' IDENTIFIED BY '密码' WITH GRANT OPTION;
#如果是授予某个IP地址登陆,写法为:
#GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.201.60.124' IDENTIFIED BY 'password123456' WITH GRANT
3.刷新:
mysql>FLUSH PRIVILEGES;