Change the MySQL root Password from null to 123456

Change the MySQL root Password from null to 123456

Requirement: Change the MySQL root Password from null to 123456.

Use mysqladmin

Mysqladmin-u root-p password mypasswd

After entering this command, enter the original root password (empty), and change the root password to mypasswd.

[Work @ master bin] $ mysqladmin-u root password 123456

[Work @ master bin] $

After the above command is executed, the second action is blank, which indicates that your password has been updated successfully.

The root password is set to 123456.

MySQL changes user password and resets root Password

MySQL changes the password and forgets the ROOT password

How to reset the root password after installing MySQL in CentOS 6.4

This article permanently updates the link address: