MySQL multiple ways to change the password----5.6 Pit

Create user and authorize and Change Password: Grant all privileges on * * to [email protected] '% ' identified by ' 123456 ' with GRANT option; *9fb2126f7514b6af42b20e9e4b8e839b72e31 method One: #msyqladmin-uroot password nwepassword#mysqladmin-uroot password OldPassword NewPassword Method Two: Create user [email protected] ' localhost '; set password for [email protected] '% ' =password (" 123456 "); set Password=password (" 123456 "); Method Three: Update Mysql.user set Password=password ("123456") where user= ' root ' and host= '% '; Updata mysql.user set password= "*  9fb2126f7514b6af42b20e9e4b8e839b72e31 "where user= ' root ' and host= '% '; Refresh permissions: Flush privileges;

mysql5.6 Authorization
Passwords cannot be duplicated with other users, or they cannot be logged in.

MySQL multiple ways to change the password----5.6 Pit