官方解释为:Only the root user (without password) has the rights to connect to the database. Either modify your scripts to use it, or add the user you need (phpMyAdmin/users and privileges: See phpMyAdmin's documentation for more information).When you are using a port on your localhost, which you redirect via port-forwarding to another host, MySQL is not resolving the localhost as expected. Erik Wasser explains: The solution is: if your host is "localhost" MySQL (the command line tool mysql as well) always tries to use the socket connection for speeding up things. And that doesn't work in this configuration with port forwarding. If you enter "127.0.0.1" as hostname, everything is right and MySQL uses the TCP connection. 我的主页是:http://127.0.0.1:8080/我难道不是root user?
这样输: d:\mysql-5.1.58-win32\bin>mysql -u root -p Enter password: *******
谢谢,但是问题不是密码不对,官网说出现这种情况说明我不是root user,并且我的主页是:http://127.0.0.1:8080/ 表明我不是root user 。 官网说:If you enter "127.0.0.1" as hostname, everything is right and MySQL uses the TCP connection.但是我是在我自己的电脑上登录,为啥不是root user?
Erik Wasser explains: The solution is: if your host is "localhost" MySQL (the command line tool mysql as well) always tries to use the socket connection for speeding up things. And that doesn't work in this configuration with port forwarding.
If you enter "127.0.0.1" as hostname, everything is right and MySQL uses the TCP connection.
我的主页是:http://127.0.0.1:8080/我难道不是root user?
d:\mysql-5.1.58-win32\bin>mysql -u root -p
Enter password: *******
http://topic.csdn.net/u/20090515/21/2b3c9a12-d8a5-4bb1-9895-6069cef5aef8.html
官网说:If you enter "127.0.0.1" as hostname, everything is right and MySQL uses the TCP connection.但是我是在我自己的电脑上登录,为啥不是root user?
终于弄好了,感谢您,不过,问题的真实原因应该是我不是root user造成。但是我用自己的笔记本,怎么不是root user?