PHP & MySQL®: Your visual blueprint™ for creating dynamic, database-driven Web sites

Chapter 8. Administering MySQL Databases

Understanding MySQL Accounts

MySQL provides a security system to protect access to the information in your database. No one can access your database without a MySQL account. The attributes of each MySQL account include its name, the computer(s) from which the account can access the MySQL server, a password, and a set of privileges that define what the account can and cannot do in the database. Account information is stored in a database named mysql, which is created by default when you install MySQL.

The Account Name and Host

A MySQL account name is defined in terms of its name and the host from which the account can connect to the MySQL server. A MySQL server recognizes a MySQL account as acctname@hostname ...