连接mysql提示Access denied for user 'root'@'localhost'
MySQL版本:MySQL 5.5.8
连接MySQl:mysql -uroot -proot
提示信息: Access denied for user 'root'@'localhost'
1. 停止 MySQL 服务
2. D:/Program/MySQL/MySQL Server 5.5/bin>mysqld --defaults-file="D:/Program/MySQL/MySQL Server 5.5/my.ini" --console --skip-grant-tables
101219 21:39:10 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 101219 21:39:10 InnoDB: Initializing buffer pool, size = 47.0M 101219 21:39:10 InnoDB: Completed initialization of buffer pool 101219 21:39:10 InnoDB: highest supported file format is Barracuda. 101219 21:39:10 InnoDB: 1.1.4 started; log sequence number 1595675 101219 21:39:10 [Note] mysqld: ready for connections. Version: '5.5.8' socket: '' port: 3306 MySQL Community Server (GPL) |
3. 启动 MySQL 服务
4. 再开一个DOS窗口,同样切到mysql bin目录下,
D:/Program/MySQL/MySQL Server 5.5/bin>mysql -uroot mysql
Welcome to the MySQL monitor. Commands end with ; or /g. Your MySQL connection id is 2 Server version: 5.5.8-community-log MySQL Community Server (GPL)
Type 'help;' or '/h' for help. Type '/c' to clear the buffer. |
mysql> FLUSH PRIVILEGES;
mysql> quit
5. D:/Program/MySQL/MySQL Server 5.5/bin>mysqladmin shutdown
6. 正常重启 MySQL 服务就行了。
7. D:/Program/MySQL/MySQL Server 5.5/bin>mysql -uroot -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or /g. Your MySQL connection id is 2 Server version: 5.5.8 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.
mysql> |