项目场景:
SSM整合,测试时出现Bug:Caused by: java.sql.SQLException: Access denied for user ‘i’@‘localhost’ (using password: YES)
拒绝访问用户“{电脑用户名}”@“localhost”
问题描述:
遇到的问题:
Caused by: java.sql.SQLException: Access denied for user ‘i’@‘localhost’ (using password: YES)
原因分析:
拒绝访问用户“{电脑用户名}”@“localhost”
没有权限
解决方案:
修改数据库权限:
1.打开cmd,输入mysql -u root -p 再输入密码
2.输入更改权限的代码,youname和youpasswd是你自己的账户和密码
grant all privileges on *.* to 'youname'@'%' identified by 'youpasswd';
3.刷新权限 flush privileges;
4.退出 exit
运行结果: