cPanel Tutorial - MySQL Database

How to use MySQL Databases

The MySQL Account Maintenance Menu allows you to create MySQL databases and users and to modify databases and access to them. 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.

Please check our PHP / MySQL tutorial for more details about using MySQL:

• Find a short introduction what is PHP and what it is used for;
• What is MySQL and what are its benefits;
• Learn how to create a MySQL database and user - this is an important section when you try to install a ready-made PHP/MySQL script on your website;
• Learn how to remove a MySQL database and user;
• Learn how to manage MySQL databases with phpMyAdmin or through Remote Connection;
• Learn how to connect PHP scripts with MySQL data;
• PHP code to connect to the Database;
• Learn how to execute commands on the server;
• Learn how to display table data in HTML;
• Learn how to select individual records;
• Learn how to add MySQL access hosts;