Can't solve a long time online, texture,
Just come in without friends, invited some system recommended by friends, really sorry,

CodePudding user response:

The ALTER USER 'root' @ 'localhost' IDENTIFIED BY '! Password1 ';
Try with this statement

CodePudding user response:

The wrong grammar, set the password for user name @ localhost=password (' new password ')

CodePudding user response:

Mysql from 5.7 after change the password to authentication_string
Update the user set authentication_string=password (" testpasswd ") where the user="root";

CodePudding user response:

Thank you for the first floor, torture almost half an hour finally changed;

CodePudding user response:

Version 5.6 before you can use the PASSWORD ()
After 5.7 version can use authentication_string ()

CodePudding user response:

Statements should be how to write? Change my password, and submitted to the new error: error1193: Unknown system variable 'authentication - string; Beg god told!

CodePudding user response:

You are using a MySQL 8, modify the PASSWORD to use the SET PASSWORD='auth_string';

CodePudding user response:

Mysql8 with 8 floor SET PASSWORD='123';

CodePudding user response:

Mysql8.0 I met your problem also seems to is not the same as previous version of the command
Modify the PASSWORD you can SET the PASSWORD='a123456';
So the new password is a23456