MySQL Change password

1. MySQL is the first use of no password, the need to enter the password when the direct return can be, but you set the password to enter the password to login. Here's how to change the password if you know the old password.

Enter MySQL system: set password for [email protected] = password (' newpassword '); set the root password to NewPassword

2. Another situation is to forget the original password

First of all, to stop the MySQL services: service mysqld stop;

Skip authorization start: Mysql_safe--skip-grant-tables &

Log in as root: Mysql-u root

Update MySQL Library user table: Use mysql;→update user set Password=password (' NewPassword ') where user = ' root ' and host = ' localhost ' ; →flush Privileges;→quit

Then restart the MySQL services: service mysqld restart

MySQL Change password