• 
• 
• 

Data Control Language

Grant

Finally in this section we are going to look at some security and how to change the privileges on a table or set of tables. Though we can manage the MySQL grant tables directly. It is generally recommended this is done through the use of the GRANT keyword. The syntax of this is:

GRANT privileges ON tbl_name TO user [IDENTIFIED BY ‘password’];

Privileges that might be invoked include INSERT, SELECT, UPDATE and DELETE and can be applied individually or as a comma separated list to give several permissions in one statement.