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 for user: 'root@localhost' (Using password: YES)'

谢了

peter333

use "grant" to let that user can access mysql

tonyfox

可是如果更本进不去mysql，或者连不上mysql这个database的话，如何能够进入mysql呢，除了重装？谢谢！

peter333

Did you start mysql? check this with "ps -ef|grep mysql". Reinstall it if you can not enter mysql.

弹头

[quote]原帖由 "peter333"]use "grant" to let that user can access mysql[/quote 发表：



我在mysql下用
mysql>;grant all
         >;on *
         >;to root identified by 'xxxx'
         >;with grant option;
之后虽然提示ok了，但是我的mysql还是没有设上密码。

づ★sl战神

我认为是属于连接问题

xbiao

我现在是照弹头说的做出现如下情况
[root@xblinux root]# mysql -u root  
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 3.23.52

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>; use mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql>; grant all
    ->; on *
    ->; to root identified by 'langlang'
    ->; with grant option;
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)

我该如何处理呢？重装过MYSQL，望解答。