MySQL User management

The operation of the database user is done in the MySQL library, so you need to go to the MySQL library to see the users and addresses in the database.

Here are two ways to create a user's password at the same time, the difference is the second we can directly to the user rights

Change the name to the user

Delete User

Change Password for user

In order to solve the problem of forgetting the user password here we can resolve, here we use the mysql5.7 version and other versions may be different methods

Shut down the database service after exiting the database

Enter configuration file

Add this statement and restart the database

Log in to the database directly using MySQL

Modify User Login Password

Then exit to delete the previous statement that was added in the configuration file, restart the database and log in with the new password.

Set permissions for a user

To remove permissions from a user

MySQL User management