Description: This article mainly wrote, MySQL for the user some of the operation, there are: View users, create users, permissions to give, retract, the user's password modification and deletion.
- View Users:
- Create User: Know that there is a user table, so the user is created to insert data into the table. This is really a good way, but, careful you, you can look at the structure of the mysql.user, found that some fields are not the default value, so in the insertion time, you must also write the complete, this is not very good, so, suggest, use the following method.
- To test a new user
- Grant of permission
As to what permissions you have, you can look at the structure of the Mysql.user user table.
- Recovery of permissions
Revoke is similar to Grant's syntax, just to replace the keyword "to" with "from"
- User's password modification
- User's deletion
Note: If you have any user needs to operate, please leave a message.
mysql-User Actions
