Creating MySQL Databases via cPanel

Search…

MySQL is a very handy tool available to webmasters who want to take advantage of dynamic web pages which run on languages such as PHP, as well as softwares like WordPress that may have been manually installed (not installed using Softaculous).
More information about MySQL can be found at Wikipedia and official website.
Creating a database
Before you take advantage of MySQL, you will need to create a database and a user to work with. To access the MySQL Databases section of cPanel, use the button available on the homepage.
Step 1: Creating the database
In the MySQL Databases section of cPanel, take a look at the Create new database section of the resulting page. Give your database a name and submit the form. In the resulting page, you should see your new database in the list of databases.
Step 2: Creating the user
Now scroll down to the Create new user section of the resulting page. Fill in a username and password (a strong password is always good) and submit the form. In the resulting page, you should see your new user in the list of users right at the bottom of the page.
Step 3: Assign the user to the database
In the Add user to database section of the resulting page, select your newly created user and your newly created database from the drop down, then submit the form. In the resulting page, give the user the appropriate privileges (the commands the user can run). If you are unsure, just click All privileges and submit the form. In the resulting page, in the list of databases, you should see your newly created user in Users column alongside your newly created database.
Accessing the database
Your database details
If you are connecting locally, then your HOST is localhost. Your database name is the name you specified, but prefixed with your cPanel username and then an underscore (e.g. CPANEL_DATABASE).
Managing the database with phpMyAdmin
By using the phpMyAdmin button on cPanel's homepage, you can control and manage your databases and issue commands. More information about phpMyAdmin is available at the official site.
Connecting to the database through PHP
Create a blank PHP file, enter:
1
<?php
2
$mysqli = new mysqli("HOST", "USERNAME", "PASSWORD", "DATABASE");
3
if (mysqli_connect_errno()) {
4
printf("Connect failed: %s\n", mysqli_connect_error()); //this will print out the error while connecting to MySQL, if any
5
exit();
6
}
7
?>
Copied!
To execute a query via PHP:
1
<?php
2
$mysqli = new mysqli("HOST", "USERNAME", "PASSWORD", "DATABASE");
3
$sql="SELECT * FROM `TABLE`";
4
$result = mysqli_query($mysqli,$sql);
5
?>
Copied!
Filling your HOST, USERNAME, PASSWORD, and DATABASE with the actual information.
Connecting Remotely
Step 1
Login to your cPanel.
Step 2
Click on Remote MySQL.
Step 3
Put a percent sign % for all IP or else enter the IP to give access to only that particular IP in the box and click Submit.
Step 4
Use the host for your server:
Tommy: tommy.heliohost.org
Ricky: ricky.heliohost.org
Johnny: johnny.heliohost.org

Changing Your Main Domain

Installing Let's Encrypt SSL Certificate via cPanel

Last modified 1yr ago

Copy link

Contents

Creating a database

Step 1: Creating the database

Step 2: Creating the user

Step 3: Assign the user to the database

Accessing the database

Your database details

Managing the database with phpMyAdmin

Connecting to the database through PHP

Connecting Remotely