mysql 命令出错

有时候在DOS窗口中输入

C:\Documents and Settings\Administrator>mysql -uroot;

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 5.1.32-community MySQL Community Server (GPL)

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

mysql> use mysql;

会有出错提示

ERROR 1044 (42000): Access denied for user to database

，自己机子上的应该也不是权限问题,本身就是空密码

后来试一下居然是这个问题

把第一个mysql -uroot; 后面的分号';'去掉就可以了。

C:\Documents and Settings\Administrator>mysql -uroot

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22
Server version: 5.1.32-community MySQL Community Server (GPL)

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

mysql> use mysql;
Database changed