记得早上因为没有网络,把root密码改错了写成了: update user set password="122" where user="root"; 之后mysql就开始不工作了。 #mysql -u root -p #123 就会出现:ERROR 1045 (28000): access denied for user ''@'localhost' (using password: NO) 只能这样: #mysql -u root mysql> use mysql 又出现了ERROR 1045 (28000): access denied for user ''@'localhost' (using password: NO) 找了好久资料: 解决方法: 1.关闭mys...
by yexin218 - MySQL文档中心 - 2007-08-22 17:37:12 阅读(1235) 回复(0)
我在Suse Linux 10.2下用自带光盘用Yast2安装Mysql 5.0, 装好后在终端输入mysql, mysql 成功启动,退出,再输入 mysqladmin -u root password XXXXX, 出现错误: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (using password: NO)' 如先输入mysql,成功启动后输入use mysql,出现如下错误:access denied for user ''@'localhost' to database 'mysql' 还有,输m...
我的系统是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...
我的系统是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'...
账号密码都对,就是不能连接 我用网页phpmyadmin从别的机器都可以连接。在本地用程序就无法连接 一个多月都没事,今天重起一次就这样了。。。555,怎么搞的?~ access denied for user: 'ro@localhost' (Using password: YES)
数据库安装好了,用mysqlcc连接可以连接上 如果到c:\mysql\bin用mysql总是提示: access denied for user 'ODBC'@'localhost' (using password: N0) 不知道是怎么回事情,请帮助! :D
我编译好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...