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 database. Tip 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. |