Here , in this section you will learn about User Account management in different ways.
UserNames and Passwords
MySQL stores accounts in the user table of the mysql database. An account is defined in terms of a username and the client host or hosts from which the user can connect to the server. The account may also have a password.
Adding and removing user accounts
A user can create MySQL accounts in two different ways:
By using statements intended for creating accounts, such as CREATE USER or GRANT. These statements cause the server to make appropriate modifications to the grant tables.
By manipulating the MySQL grant tables directly with statements such as INSERT, UPDATE, or DELETE.
If you want to remove an account, use the DROP USER statement.
Setting Account Resource Limits
In MySQL 5.6, a user can limit the use of the following server resources for individual accounts:
The number of queries that an account can issue per hour.
The number of updates that an account can issue per hour.
The number of times an account can connect to the server per hour.
The number of simultaneous connections to the server by an account.
Assigning Account Passwords