Database

How to Reset a MySQL Database User’s Password in cPanel Forgotten or changed a database password? Learn how to reset a MySQL user's password in cPanel and update your site's config so it connects again.
How to Rename a MySQL Database in cPanel Need to rename a MySQL database? Learn the safe way to rename a database in cPanel and update your site so it keeps connecting without errors.
How to Fix the “MySQL Server Has Gone Away” Error The “MySQL server has gone away” error usually means a timeout or oversized query. Learn the common causes and how to fix them on your hosting.
How to Empty or Drop a Database Table in phpMyAdmin Need to clear or delete a table? Learn the difference between emptying (TRUNCATE) and dropping a table, and how to do each safely in phpMyAdmin.
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…
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…
How to create a MySQL database in cPanel https://www.youtube.com/watch?v=NFbo19Sx244 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…
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…
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…
How to manage PostgreSQL databases and users in cPanel PostgreSQL is a popular open-source relational database management system used to manage data for web applications. cPanel is a web hosting control panel that allows you to manage your website and…
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…
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…
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…
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…