MySQL account management

　< /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
# 

#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