修改密码
$ cd /usr/local/mysql/bin
$ sudo su
sh-3.2# ./mysqld_safe --skip-grant-tables &
开一个新终端
mysql -u -root
UPDATE mysql.user SET authentication_string = PASSWORD('新密码') WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;
密码过期
/usr/local/mysql/bin/mysqladmin -u root -p password
Enter password:
New password:
Confirm new password: