How to modify the MySQL password

Mysql

How to modify the MySQL password

Use MySQL
Update user set Password=password (' NewPassword ') where user= ' root ';
Flush privileges;

1. By modifying the MySQL database in the MySQL Library user table
You can use the normal update, insert statement

2. Use the following command at the command line
Mysqladmin-u root-p PASSWORD mypasswd

3. You can modify the My.ini file in the MySQL folder

4. Using the Set Password statement,
Mysql> SET PASSWORD for myuser@localhost = PASSWORD (' mypasswd ');

5. Use Grant ... Identified by statement
Mysql> GRANT USAGE on *.* to Myuser@localhost identified by ' MyPassword ';