error Access denied for user 'root'@'localhost
我的系统是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...
by niezhenqun - MySQL文档中心 - 2008-04-29 14:47:10 阅读（1455） 回复（0）
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...
今天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...
windowsxp系统 mysql-5.0.11-beta-win32 提示：1045 access denied for user [email='root'@'localhost']'root'@'localhost'[/email] using password yes 前几天都好好的，昨天没弄，结果今天晚上过来提示上面的这个错误，重启mysql还是不可以 网上的方法看了几个但是不知道怎么弄 方法一： # /etc/init.d/mysql stop # mysqld_safe --user=mysql --skip-grant-tables --skip-networking & # mysql -u root mysql mysql>...
我的系统是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...
我的系统是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'...
