mysql 以某用户登录错误 ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)

2013-03-29 11:04 12人阅读 评论(0) 收藏 编辑 删除

来源  http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw

摘要

You probably have an anonymous user ''@'localhost' or ''@'127.0.0.1’




Hence, such an anonymous user would "mask" any other user like '[any_username]'@'%'.'billy'@'localhost' does match 'billy'@'%', but would match (e.g.) ''@'localhost'beforehands.




by lucoz