Four small ways to modify the default password for Mysql _mysql

For Windows platforms, when the MySQL database is installed, the system defaults to generating the license tables and accounts, and you do not need to execute mysql_install_db scripts to generate accounts and appropriate permission tables as you would on UNIX platforms. However, if you do not install MySQL in MSI format, you will need to manually add a new password to the root account after installation, because Root does not have password protection by default, and if you do not reassign the root account password, many non-native connections will not succeed.

Method 1: With the Set password command, the specific update password steps are as follows:

C:>mysql-u root

mysql>set password for ' root ' @ ' localhost ' =password (' newpasswd ');

Mysql>set password for ' root ' @ '% ' =password (' newpasswd '); This article can be selected

With the above settings, the root password will become newpasswd so that the root user root password is set to work.

Method 2: With Mysqladmin

mysqladmin-u root Password "Newpass"

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

mysqladmin-u root password Oldpass "Newpass"

Method 3: Edit the user table directly with update

Mysql-u root

mysql> use MySQL;

mysql> UPDATE user SET Password = Password (' newpass ') WHERE user = ' root ';

mysql> FLUSH privileges;

When you lose the root password, you can do this.

Mysqld_safe--skip-grant-tables&

mysql-u root mysql

mysql> UPDATE user SET Password=password ("New Pass　　Word ") WHERE user= ' root ';

mysql> FLUSH privileges;

It is so simple to complete the MySQL database default password changes, the default password modified after you can do more operations, I hope that the content involved in the above can help.