Many scripts, or web apps, use MySQL to hold data used for the website.

This short guide will walk through creating a MySQL database, MySQL Username and password.

After logging into your cPanel account, click "MySQL Databases" to get to the relevant section of the control panel.

This section displays your current databases and the users assigned to each one. Below this are the options which control everything to do with your MySQL databases:

Creating a New Database

Simply enter the name of the database you wish to create and click the Add DB button. The DB name will be prefixed with your account username and an underscore so the full DB name will be username_dbname

Creating a User

Simply enter a username and password and click the Add User button. The username will be prefixed with your account username and an underscore so the full DB username will be username_dbusername

You can create one user which you can add to all your databases or create a different user for each database which is recommended for security purposes.

Add a User to a Database

You must create a user and add them to a database before that database can be used by, for example, a PHP script.

Select the user from the first drop-down box and select the database from the second drop-down menu and click the Add User to Db button.

phpMyAdmin

The link and icon to phpMyAdmin can be found on the cPanel's homepage.

You can use phpMyAdmin to administrate the contents of your MySQL databases in a web based environment.

Add to Favourites

Print this Article