当前位置：Gxlcms >
数据库问题 >
错误代码： 1045 Access denied for user 'skyusers'@'%' (using password: YES)
错误代码： 1045 Access denied for user 'skyusers'@'%' (using password: YES)
时间：2021-07-01 10:21:17
帮助过：23人阅读
ALL PRIVILEGES ON *.*
TO root@
"%" IDENTIFIED
BY ".";
1 queries executed, 0 success, 1 errors, 0 warnings
查询：
grant all privileges on *.* to root@"%" identified by "."
错误代码： 1045
Access denied for user ‘skyusers‘@‘%‘ (using password: YES)
运行耗时 : 0 sec
传送时间 : 0 sec
总耗时 : 0.003 sec
2. 错误原因
连接数据库的账户是skyusers，而不是root
3. 解决的方法
改动以下的MySQL命令
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY ".";
改动成
GRANT ALL PRIVILEGES ON *.* TO skyusers@"%" IDENTIFIED BY ".";
错误代码： 1045 Access denied for user 'skyusers'@'%' (using password: YES)
标签：warning content this password lines length end number function
