Requirement: Change the MySQL root Password from null to 123456. Use mysqladminmysqladmin-uroot-ppasswordmypasswd to enter this command and then enter roo
Requirement: Change the MySQL root Password from null to 123456. Use mysqladmin-u root-p password mypasswd to enter this command and then enter roo
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