Management and Security
MySQL is a multi-user database with a
sophisticated access control system. The phrases in this chapter
will show you how to maintain the users on your database and to
give each user only the permissions he requires.
MySQL's privilege system ensures that each user
may only perform the operations that he is allowed. A user's
identity is determined by a given username and the remote address
from which the connection is made. A user is also usually required
to authenticate by providing a password when connecting to the
You need specific
administrator privileges to perform each of the commands in this
chapter. If you connect to MySQL as the root usertypical for
performing user maintenanceyou have the appropriate permissions to
execute every example phrase.