基本的修改密码的方式:
mysqladmin -u root -p password
Enter password:
1.mysql>use mysql;
2.mysql>UPDATE user SET Password=PASSWORD('******') where USER='root';
Query OK, 3 rows affected (0.02 sec)Rows matched: 3 Changed: 3 Warnings: 0
3.mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
4.mysql> quit
5.restart