首页 > 代码库 > 错误代码: 1045 Access denied for user 'skyusers'@'%' (using password: YES)
错误代码: 1045 Access denied for user 'skyusers'@'%' (using password: YES)
1. 错误描写叙述
GRANT 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)
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。