SQL stands for Structured Query Language. SQL is a international standard in querying and 

retrieving information from databases. MySQL is essentially an SQL server   it responds to 

requests for information that are written in SQL. You can communicate with MySQL using a 

wide variety of programming languages (PHP being one of the most common). MySQL is Open 

Source software and generally free for use.  

Refer to the following links for more information about MySQL: 

MySQL FAQ

   a good place to start.  

MySQL and PHP tutorial

   a good introduction to using the two Open Source 

technologies together.  

To create a MySQL database: 

1.  Click on the Add/Remove MySQL Databases link in the  area. 

2.  Enter the name of the database in the MySQL Database field.  

3.  Click on the Create MySQL database button. Click on the MySQL databases link to 

return to the MySQL databases window to confirm that it has been created.  

Topics: 

Creating a MySQL user

Grant a user s permissions to a MySQL database

Removing a user s permissions

Removing a user

Removing a database

Creating a MySQL user  

You need to create a MySQL user before that user is able to use the database. This does not 

automatically allow the user to use a database   you need to grant that user permissions to the 

specific database first. Refer to 

Grant a user s permissions to a MySQL database

 for more 

information.  

To create a MySQL user: 

1.  Click on the Add/Remove MySQL Databases link in the  area. 

2.  Enter the user s name in the Username field and the user s password in the Password 

field.  

3.  Click on the Create user button. Click on the MySQL databases link to return to the 

MySQL databases window to confirm that it has been created.  

20