Category: Databases
How to Enable Remote MySQL Connection in WHM?
By default, remote MySQL connections are disabled for all cPanel servers. To enable remote MySQL connection in WHM, please follow the steps. Steps to enable Remote MySQL Connection Step 1: Login to your WHM account. Step 2: Navigate to the option Additional MySQL Access Hosts under SQL Services section. Step 3: Enter IP or host…
How to Configure Remote MySQL Database Connection in cPanel
Before you can connect to your databases remotely, the IP working via remote connection has to be allowed on your account’s side. You can configure Remote MySQL Database Connection from cPanel control panel. Steps to Configure Remote MySQL Connection: Step 1: Login to your cPanel account. Step 2: Navigate to the Database section and click…
How to create a MySQL database in cPanel
We assume you’ve already logged in to cPanel, and are starting on the home screen. Now let’s learn how to create a MySQL database. Click the MySQL Database Wizard icon. Enter a name for the new database, then click Next Step. Now we have to create a user for this database. Enter a username and create a password,…
How to export a database using phpMyAdmin
In this article, we will show you how to export a database using phpMyAdmin. This is assumed that you already have a database in your cPanel account and you wish to export your existing database file. Step 1: Log in to cPanel account. Step 2: Go to phpMyAdmin. Step 3: Select the database which you…
How to import a database using phpMyAdmin
In this article, we will show you how to import a database using phpMyAdmin. This is assumed that you have already created a blank database in your cPanel account and you wish to import your existing database file to your blank database. Step 1: Log in to cPanel account. Step 2: Go to phpMyAdmin. Step…
How to optimize database via phpMyAdmin in cPanel?
1. Log into your cPanel account. 2. In the “Databases” section, click on “phpMyAdmin” Icon. 3. In left side-bar, Click on the expand button to expand database like “example”.4. Under your cPanel username, you can see list of all databases. Select appropriate database which you want to optimize. 5. Scroll down and mark “Check All”…
How to Repair database via phpMyAdmin in cPanel?
Log into your cPanel account. In the “Databases” section, click on “phpMyAdmin” Icon. In left side-bar, Click on the “+” button to expand database like “example”. Under your cPanel username, you can see list of all databases. Select appropriate database which you want to repair. Scroll down and mark “Check All” then click on the…
How to create a MySQL Database in cPanel
Database is one of the most important core feature of a dynamic website. Data storage, data transfer and hundreds of tasks are done with database. Although there are several types of databases, MySQL is one of the most renown among them. Today we will learn how to create a MySQL database in cPanel. So let’s…
Create a MySQL Database and a User from cPanel
Creating MySQL Database & User from cPanel is very easy. One can perform these tasks within a few mouse clicks. Here is a step by step guide on ‘How to Create a MySQL Database and a User from cPanel’ Create Database: Step 1: Log into your cPanel by providing your username and password. Step…