3.6. ADVANCED MENU

CHAPTER 3. HOW DO I USE CPANEL?

3.6

Advanced Menu

The Advanced Menu area deals with a number of options that you normally would not need to use very often,

including cron jobs, mime types, Apache handlers, and a number of other useful tools. Generally you only need to

use these tools to perform unusual tasks. mySQL database control is also situated in this area, and is becoming

a very popular tool in web site design.

Figure 3.53: Advanced Menu

3.6.1

mySQL

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 informa 

tion 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 MySQL Databases link in the Advanced Menu area.

2. Enter the name of the database in the Db field.

3. Click on the

button. The database will be added to the /var/lib/mysql folder.

You need to create at least one database user and grant that user permission to use the new database. Refer

to page 53 and page 53 for more information.

Figure 3.54: Creating a mySQL database

52