cPanel Hosting Guide

Logging on
Server information
Mail
Change Password
Parked Domains
Addon Domains
FTP Manager
File Manager
Disk Usage
Backup
Password protection
Error pages
Subdomains
MySQL
PostgreSQL
Redirects
Frontpage Extensions
Web/FTP Stats
Raw Access Logs
Raw Log Manager
Subdomain Stats
Search Engine Submit
Chatroom
PhpMyChat
Bulletin Board
CGI Center
Scripts Library
Cron jobs
Network Tools
MIME Types
Apache handlers
OpenPGP keys
HotLink Prevention
Index Manager
IP Deny Manager

MySQL

SQL stands for Structured Query Language. SQL is an 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 free for use.

Refer to the following link for more information about MySQL :

• MySQL - The MySQL homepage.
• 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 button on the home page.
2. Enter the name of the database in the Db field.
3. Click on the Add Db 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 Creating a MySQL user and Grant a user's permissions to a MySQL database for more information.

Topics:

Removing a database
Creating a MySQL user
Grant a user's permissions to a MySQL database
Managing MySQL databases
Adding host access