连接问题报'localhost'相关的错

xbiao

[root@xblinux root]# mysqladmin -u root -p password 123456
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
[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@localhost identified by "ncujcb";
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)


这种问题网上说和/etc/hosts相关，但没提到如何解决，大家帮我看看，请教了。

Trotter

对,mysql是和主机名有关系的.你可以建一个对应主机名的用户,也可以将你的主机名改为localhost都可以.还可以用

mysql -h[hostname] -u[username] -p[password]

来进入mysql控制台.

xbiao

没错，谢谢，现以解决