Linux论坛's Archiver

《开源》旗舰电子杂志2009年第1期火热下载!

tracydundun 发表于 2008-8-22 14:10

MYSQL设置的密码不能用?

mysql> grant select,insert,update,delete,index,alter on book.* to bookorama identified by '123456';Query OK, 0 rows affected (0.20 sec)

mysql> quit
Bye
[root@www ~]# mysql -u bookorama -p
Enter password:
ERROR 1045 (28000): Access denied for user 'bookorama'@'localhost' (using password: YES)
[root@www ~]# mysql -u bookorama
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 5.0.37 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
怎么设置好的密码不能进入阿?不用密码反而能进入!

fire9 发表于 2008-8-28 15:25

授权用户的时候要指定服务器名

页: [1]

Powered by Discuz! Archiver 7.0.0  © 2001-2009 Comsenz Inc.