Modify MySQL Password

1, if there is no password, then

Mysql-u Root

mysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');

2. If you already have a password, you can use:

mysqladmin-u root Password "Newpass"

If Root has already set a password, use the following method

mysqladmin-u root password Oldpass "Newpass"

3, in the visual interface, you can find the MySQL database user table, modify, but remember to add permissions:

Grant all on mysql.* to ' root ' @ ' localhost ' identified by ' password ';

The last password is the password of the root user you want to change.

If you do not add this sentence, you will not have permission to log on, in return for such errors:

Error code 1045

Access denied for user ' root ' @ ' localhost ' (using Password:yes)

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Modify MySQL password