2013年4月13日

MySQL error solution collection

摘要: ERROR 1396 (HY000): Operation CREATE USER failed for 'jack'@'localhost' drop user jack@'localhost'; flush privileges; create user admin@localhost identified by 'admins_password' select host, user from mysql.user;ERROR 2003 (HY000): Can't connect to MySQL server on 阅读全文

posted @ 2013-04-13 22:11 JohnChain 阅读(479) 评论(0) 推荐(0)

mysql 新建的%用户无法本地(localhost)登录

摘要: MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)问题背景: 数据库中已创建了smartwin@'%'的用户,当以smartwin登录时,总是出错(前提密码输入正确):而通过指定host地址登录则可以成功,SELECTUSER(),CURRENT_USER(); USER() reports how you attempted to authenticate in MySQL CURRENT_USER() reports 阅读全文

posted @ 2013-04-13 21:56 JohnChain 阅读(2480) 评论(0) 推荐(0)

导航