MySQL multiple ways to change the root password

Method 1: Use the Set password command

- u root MySQL > SET  for ' Root '@'localhost'= PASSWORD ('newpass' );

Method 2: Use Mysqladmin

- u root Password "Newpass" -- If Root has already set a password, use the following method -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 ( Span style= "color: #ff0000;" > '  ) where  user  =   '  

Method 4: When the root password is lost, this can be

-- skip-grant-tables& - u root mysql mysql > UPDATE User SET Password=WHEREuser='root'　　; MySQL>privileges;

MySQL multiple ways to change the root password