< /p>
#code
desc user
select user,host,authentication_string from mysql.user;
#Modify password update user set authentication_string=password(‘new password’) where user=‘user name’ #After the update, remember to refresh the permissions flush privileges
#I want to test the code above and find that there is no testable user. Create a new user here
#
< /p>
It can be seen from the picture that the jingdong library cannot be queried because the root user has not created it
Try to update the password
#code
desc user
select user,host,authentication_string from mysql.user;
#Modify password update user set authentication_string=password(‘new password’) where user=‘user name’ #After the update, remember to refresh the permissions flush privileges
#I want to test the code above and find that there is no testable user. Create a new user here
#
< /p>
It can be seen from the picture that the jingdong library cannot be queried because the root user has not created it
Try to update the password