经测试后,修改mysql密码的方法为:
一、mysql 无初始密码
/usr/bin/mysqladmin -u root password newpassword;
二、mysql有初始密码
终端输入命令mysql - u root -p 进入mysql
1. mysql> show databases;
2. mysql> use mysql;
3. mysql> show tables;
4. mysql> UPDATE user SET password=PASSWORD('new password') WHERE user='root';
执行后输出如下:
Query OK, 3 rows affected (0.04 sec)
Rows matched: 3 Changed: 3 Warnings: 0
5. mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
6. mysql> exit
7.mysql> mysql -u root -p 核查密码是否正确