Creating MySQL Databases via cPanel
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).
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.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.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.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.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).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.
Create a blank PHP file, enter:
<?php
$mysqli = new mysqli("HOST", "USERNAME", "PASSWORD", "DATABASE");
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error()); //this will print out the error while connecting to MySQL, if any
exit();
}
?>
To execute a query via PHP:
<?php
$mysqli = new mysqli("HOST", "USERNAME", "PASSWORD", "DATABASE");
$sql="SELECT * FROM `TABLE`";
$result = mysqli_query($mysqli,$sql);
?>
Filling your HOST, USERNAME, PASSWORD, and DATABASE with the actual information.
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