database.
Column level—These rights allow access to a single column within a
database’s table.
NOTE
Listing all the available privileges is beyond the scope of this chapter. See
the MySQL documentation for more information.To add a user account, you connect to the database by typing mysql -u
root -p and pressing Enter. You are then connected as the root user and
prompted for a password. (You did set a password for the root user, as
instructed in the last section, right?) After you enter the root password, you
are placed at the MySQL command prompt.
To grant privileges to a user, you use the GRANT statement, which has the
following syntax:
Click here to view code image
grant what_to_grant ON where_to_grant TO user_name IDENTIFIED BY
'password';
The first option, what_to_grant, is the privileges you are granting to the user.
You specify these privileges with keywords. For example, the ALL keyword
is used to grant global-, database-, table-, and column-level rights for a
specified user.
The second option, where_to_grant, specifies the resources on which the
privileges should be granted. The third option, user_name, is the username to
which you want to grant the privileges. Finally, the fourth option, password, is
a password that should be assigned to this user. If this is an existing user who
already has a password and you are modifying permissions, you can omit the
IDENTIFIED BY portion of the statement.
For example, to grant all privileges on a database named sampledata to a
user named foobar, you could use the following command:
Click here to view code image
GRANT ALL ON animals.* TO foobar IDENTIFIED BY 'secretword';
The user foobar can now connect to the database sampledata by using
the password secretword, and foobar has all privileges on the database,
including the ability to create and destroy tables. For example, the user
foobar can now log in to the server (by using the current hostname
—shuttle2, in this example) and access the database like this:
Click here to view code image