Chapter 6. User 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 database.


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.

MySQL Phrasebook. Essential Code and Commands
MySQL Phrasebook
ISBN: 0672328399
EAN: 2147483647
Year: 2003
Pages: 130

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: