前几天在搭建JIRA系统时,发现MySQl的root用户登录不上!在网上搜索了好久,找到了一个好用的办法
操作系统:XP
MySql Server 5.1
错误提示:access denied for user 'root'@'localhost' using password yes/no
具体步骤如下:
1.管理员登陆XP系统,停止MySql服务或结束MySql进程;
2.启动windows命令行窗口:程序->运行(cmd),然后切换到my.ini文件所在的目录;
(我的my.ini文件MySql安装路径下的MySQL Server文件下面,我看网上说有的还可能在bin目录下面)
3.运行下面的命令:
D:/tool/MySQL Server>mysqld --defaults-file="D:/tool/MySQL Server/my.ini" --console --skip-grant-tables
出现如下信息
=====================================================
100608 9:04:12 InnoDB: Started; log sequence number 0 46409
100608 9:04:12 [Note] mysqld: ready for connections.
Version: '5.1.0-falcon-alpha-community' socket: '' port: 3306 MySQL Community
Server (GPL)
100608 9:06:57 [Warning] Found invalid password for user: 'root@localhost'; Ign
oring user
=====================================================
只要出现上面的信息,说明MySql已经起来了;
4.不要关闭命令行窗口,重新打开一个命令行窗口并且切换到my.ini文件所在的目录
D:/tool/MySQL Server>mysql -u root mysql
......
......
mysql> UPDATE user SET Password=PASSWORD('root') where USER='root';
(这是将root账户的密码改为root)
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
5.到此步就可以关闭第一个命令行窗口了;现在可以将MySql的服务启动了;(控制面板->管理工具->服务)
6.在第二个命令行窗口里运行命令
D:/tool/MySQL Server>mysql -u root -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 1
Server version: 5.2.0-falcon-alpha-community-nt MySQL Community Server (GPL)
Type 'help;' or '/h' for help. Type '/c' to clear the buffer.
mysql> quit
Bye
到此root密码就修改成功了!