Change the root password process is as follows:
But the use of a modified password,
But with navicat view is as follows:
O great god answer
CodePudding user response:
Update the mysql user set authentication_string=password (' new password ');Be careful to take the password ()
Authentication_string deposit is the hash value, you directly to update it into 19820709, MySQL's understanding is that the new password hash value is 19820709, but the real password is not the number of strings,
CodePudding user response:
Done!Wrong password into not to go, to find to find on the Internet to find that a few methods, also for right, said wrong is incomplete,
After installed is my 5.7.24 Windows version, it will automatically create a Windows service, if you stopped service, operated mysqld is used in the command window, will die there have no reaction, to install directory to find my. Ini, also can not find, oneself build a also doesn't work, then find the corresponding commands to the service only to find the version installed in C disk under the programdata hidden folder under the corresponding directory. There are my ini, find the skip - grant - with online after tables method can go in, went in to change the password again, like the man upstairs like speak password must use function (), to solve the problem,