一、mysql5.7中SELECT command denied to user问题
原因:
没赋予权限
解决办法:
连接mysql后，赋予权限
grant select,insert,update,delete on *.* to ajreport@"localhost" Identified by "ajreport";
第一个ajreport是用户名，第二个ajreport是密码
相关文章
- 09-19spring在beans.xml中配置druid数据源报错Access denied for user 'somebody'@'localhost' (usin
- 09-19CentOS 7安装 MySQL5.7之后，登录提示ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using passw
- 09-19c#-Linq中的“ SELECT SYSTEM_USER”等效
- 09-19TRIGGER command denied to user 'root'@'LAPTOP-M7KUFN86' for table 'growtest' | Table 'MyDatabase.tmpIdentity_Invites' doesn't exist
- 09-19MySQL数据库中1045错误[1045 Access denied for user 'root'@'localhost' (using password:Y
- 09-19转载--MYSQL5.7：Access denied for user 'root'@'localhost' (using password:YES)解决方法
- 09-19MyQL8.0数据库中1045错误的方法ERROR 1045 (28000): Access denied for user ‘ODBC‘@‘localhost‘以及更新密码
- 09-19mac系统中搭建apache+mysql+php的开发环境，安装mysql后，登录报错：mac ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- 09-19wamp中的phpmyadmin打开出现:#1045 - Access denied for user 'root'@'localhost' (using password: NO)
- 09-19mysql报错 1142 - SELECT command denied to user 'root_ssm'@'localhost' for table 'user'（用户没有授权）