The method of changing the default password by phpmyadmin

Editor to share with you the method of phpmyadmin to change the default password, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Set password=password ('hello'); / / change the root password to hello

The user information in mysql is stored in the user table of the system database mysql:

Create a user

Grammatical form:

Create user 'user name' @ 'address allowed to log in' identified by 'password'

Description:

1. The created user needs to specify at the same time at which address the user can log in.

Where "%" represents "any address".

2. After the user is created, a record is automatically added to the user table of mysql, but the user does not have permission.

Delete user

Drop user 'user name' @ 'address allowed to log in'

Modify a user's password

Change your password: set password = password ('new password')

Change someone else's password (you must have permission to change it):

Set password for 'username' @ 'allowed login address' = password ('new password')

The above is all the contents of this article entitled "how to change the default password by phpmyadmin". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!