免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1071 | 回复: 0

Access denied for user \'root\'@\'localhost\' [复制链接]

论坛徽章:
0
发表于 2011-12-22 08:53 |显示全部楼层
First, you will need to make sure whether the default user is 'admin' or 'root' or whatever. You will then need to reset the password. 

Start the mysql server instance or daemon with the --skip-grant-tables option. (security setting) You can do it by adding the "skip-grant-tables" in the server section of /etc/my.cnf then restart mysql service by #service mysql restart 

Then Execute these statements. 
# mysql -u root mysql 
mysql> SELECT Host, User FROM mysql.user; 
+-------------------------------------------+------------------+ 
| Host | User | 
+-------------------------------------------+------------------+ 
| localhost | admin | 
|-------------------------------------------+------------------+ 
1 row in set (0.00 sec) 
mysql> UPDATE user SET Password=PASSWORD('your_new_password') where USER='The_user_@_localhost'; 
mysql> FLUSH PRIVILEGES; 
mysql> quit 
bye 

After that, restart the instance/daemon without the --skip-grant-tables option. (ie. modify the /etc/my.cnf AND # service mysql restart IF you follow the above) 

You should be able to connect with your new password. 

# mysql -u root -p OR # mysql -u admin -p 
Enter password: your_new_password 
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP