Warning: Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
密码忘记,使用skip-grant-tables模式启动mysql,修改密码
# /etc/init.d/mysql stop
Shutting down MySQL (Percona Server)..
[root@bssnusb03 ~]# mysqld_safe --skip-grant-tables &
[1] 758
[root@bssnusb03 ~]# 140807 10:33:37 mysqld_safe Logging to '/BSS/data/error.log'.
140807 10:33:37 mysqld_safe Starting mysqld daemon with databases from /BSS/data
[root@bssnusb03 ~]# ps -ef|grep mysql
root 758 630 0 10:33 pts/4 00:00:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables
mysql 1041 758 36 10:33 pts/4 00:00:03 /usr/sbin/mysqld --basedir=/usr --datadir=/BSS/data --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-grant-tables --log-error=/BSS/data/error.log --pid-file=/BSS/data/percona.pid --socket=/BSS/data/percona.sock --port=3306
root 1071 630 0 10:33 pts/4 00:00:00 grep mysql
root 11572 1 0 Aug05 ? 00:00:00 mysql -uroot -px xx
[root@bssnusb03 ~]# mysql
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> UPDATE user SET Password = password('root8989') WHERE User = 'root' ;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> flush privileges ;
Query OK, 0 rows affected (0.00 sec)
mysql> \q
# mysql -uroot -proot8989