MySQL实用技巧两例

使用MySQL时碰到1045问题

使用MySQL时碰到1045问题的解决

..#1045 - Access denied for user: 'root@localhost'

刚使用mysql, 就老是碰到这个问题, 终于找到原因..

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

解决方法：

Step 1:

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p

//这就是在mysql那个dos命令下打开的

Enter password: ******

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

Your MySQL connection id is 28 to server version: 5.0.24a-community-nt

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

Step 2:

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql

mysql>status