ERROR 1044 42000Access denied for user @'localhost' to database
这些天在安装mysql+qmail+httpd+vpopmail+igenus; 安装vpopmail时,加mysql用户:vpopmail时,出错,望高手们看看什么原因,在线等! [root@mail root]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 22 to server version: 5.0.1-alpha-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>; grant all on vpopmail.* to vpopma...
by win111 - MySQL - 2008-01-31 15:16:46 阅读（13174） 回复（4）
有一数据库sort，试用root登录操作一切正常。新加一个用户www，授权给他所有权限 允许从任何地方登录，但是： [root@localhost ~]# /usr/local/mysql5.22/bin/mysql -u www -p**** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.22-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use sort error 1044 (42000): access denied...
我在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...
我的系统是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...
记得早上因为没有网络，把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...
我的系统是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...
账号密码都对，就是不能连接 我用网页phpmyadmin从别的机器都可以连接。在本地用程序就无法连接 一个多月都没事，今天重起一次就这样了。。。555，怎么搞的？~ access denied for user: 'ro@localhost' (Using password: YES)
我编译好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...
我的系统是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...
