linux Access denied for user 'root''localhost
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 th...
by manfred_xu - MySQL - 2011-12-22 08:53:16 阅读（701） 回复（0）
今天Red Hat Enterprise linux 6.0上跑得mysql神不知鬼不觉地执行mysql -u root -p登录时，报出了错误：access denied for user 'root'@'localhost' (using password: YES)，但服务器每有做任何的改动，昨天还跑得好好的，也不晓得什么原因。在网上查找了下原因，找到一篇文章提供了如下的解决方法：
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
[ooo@localhost ~]$ mysqladmin -u root -p ******
Enter password:
mysqladmin: connect to server at 'loca...
我的系统是ubuntu6.06，最近新装好的mysql在进入mysql工具时，总是有错误提示: # mysql -uroot -p Enter password: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO) 使用网上介绍的方法修改root用户的密码： # mysqladmin -uroot -p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (using...
我的系统是ubuntu6.06，最近新装好的mysql在进入mysql工具时，总是有错误提示: # mysql -uroot -p Enter password: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO) 使用网上介绍的方法修改root用户的密码： # mysqladmin -uroot -p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (using...
我的系统是ubuntu6.06，最近新装好的mysql在进入mysql工具时，总是有错误提示: # mysql -uroot -p Enter password: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO) 使用网上介绍的方法修改root用户的密码： # mysqladmin -uroot -p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (using...
我的系统是linux，最近新装好的mysql在进入mysql工具时，总是有错误提示: # mysql -uroot -p Enter password: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO) 使用网上介绍的方法修改root用户的密码： # mysqladmin -uroot -p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (using pass...
我的系统是fedora8，用rpm包安装的mysql，在进入mysql时，总是有错误提示: # mysql -uroot -p Enter password: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO) 使用网上介绍的方法修改root用户的密码： # mysqladmin -uroot -p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (us...
#1045 - access denied for user 'root'@'localhost' (using password: NO) 解决办法： mysqladmin -h hostname flush-privileges use mysql; update user set password =password('yourpass') where user='root' 出现无法连接数据库的话，命令行用root用户登陆，敲下面命令： SET PASSWORD FOR [email=sns@-localhost-=OLD_PASSWORD%28-sns-]sns@'localhost'=OLD_PASSWORD('sns'[/email] ); 然后刷新mysql权限 FLUSH PRIVIL...
我的系统是ubuntu6.06，最近新装好的mysql在进入mysql工具时，总是有错误提示: # mysql -uroot -p Enter password: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO) 使用网上介绍的方法修改root用户的密码： # mysqladmin -uroot -p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost'...
我编译好mysql之后用mysqladmin 设置密码出现了如下的问题不知道什么原因： -bash-2.05b# ./mysqladmin -u mysql -p password Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'access denied for user: 'mysql@localhost' (Using password: YES)' -bash-2.05b# ./mysqladmin -u root -p password Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'access denied...
