Table of Contents [+/-] The primary function of the MySQL
privilege system is to authenticate a user who connects from a
given host and to associate that user with privileges on a
database such as DELETE. Additional functionality includes the
ability to have anonymous users and to grant privileges for
MySQL-specific functions such as INFILE and administrative
operations. There are some things that you cannot do with the
MySQL privilege system: You cannot explicitly specify that a
given user should be denied access. That is, you cannot
explicitly match a user and then refuse the connection. You
cannot specify that a user has privileges to create or drop
tables in a database but not to create or drop the database
itself. A password applies globally to an account. You cannot
associate a password with a specific object such as a database,
table, or routine. Internally, the server stores privilege
information in the grant tables of the mysql database (that is,
in the mysql). The MySQL server reads the contents of