Experience: the specific steps for modifying the default MySQL password bitsCN.com
After MySQL is installed on windows, the system generates a license table and an account by default, you do not need to execute the mysql_install_db script on the Unix platform to generate an account and the corresponding permission table. However, if you do not use the MSI format to install MySQL, you need to manually add a new password to the root account after installation, because the root account does not enable password protection by default, if you do not re-authorize the root account password, many non-local connections will fail. Follow these steps to update the password:
C:> mysql-u root
Mysql> set password );
Mysql> set password for); // The preceding settings are optional. the root password is changed to newpasswd, and the root password is set.
BitsCN.com