bash 4.1 mysql_MySQL 4.1客户端协议验证方式的变化

-p

输入user的密码登入。

然后执行:

SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('password');

把user, host(通常都是localhost), password替换成你的，以后再使用PHPMyAdmin也就能正常使用了。

bash-2.05b$ mysql -u root -p -hwww.eygle.com

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 9 to server version: 4.1.3-beta-standard

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

mysql> connect eygle

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Connection id: 10

Current database: eygle

mysql> connect mysql

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Connection id: 11

Current database: mysql

mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('eygle');

Query OK, 0 rows affected (0.00 sec)

By eygle on 2005-03-31 21:54 |

Comments (2) |

Web | 235 |