Working with Databases

Creating, Importing, and Exporting Databases

Learn how to create, import, and export databases in this section.

• Create and attach a database user in cPanel
• Create a MySQL Database
• Export a MySQL Database with phpMyAdmin
• Import a MySQL Database with phpMyAdmin
• Export a database through shell
• Import a database through shell

Connecting

This section includes popular articles regarding making a database connection.

• Connecting to a DB with MySQL Workbench 5.2
• Connecting Remotely to your DB with Heidi SQL
• Connecting to your DB with Navicat for MySQL 10
• Connecting to a DB using PHP
• Setting up a Remote MySQL connection in cPanel
• How to access MySQL via command line

Troubleshooting Errors

This section covers some of the common errors you may experience regarding databases.

• Check and Repair Databases
• MySQL – 1044 Access Denied Error Message 
• Why do I get a max_user_connections error?
• MySQL Error 1064: You have an error in your SQL syntax
• Error 1052 Column in where clause is ambiguous

Working with phpMyAdmin

Effortlessly Manage Your MySQL Databases with phpMyAdmin in cPanel: Step-by-Step Walkthrough Guides for PHP Hosting.

• How to Use phpMyAdmin To Optimize a Database
• Installing PHPMyAdmin on your Account
• How to delete or drop a table in phpMyAdmin
• How to determine the data type of a data column in phpMyAdmin

Working with MariaDB

This section includes walk-through guides for the use of MariaDB.

• What is MariaDB?
• How to Create a MariaDB database
• How to Delete a Database with MariaDB

Working with MySQL

These articles cover the use of MySQL within cPanel.

• Setting up a Database to Handle Form Data
• Managing a MySQL Database in cPanel with PHPMyAdmin
• I need a different version of PHP/MySQL
• The Basics of Tuning MySQL on Dedicated Servers
• Monitoring MySQL Performance
• Download a Copy of your Database

Working with Percona DB

This section provides information on working with Percona DB.

• What is Percona DB?
• How to install Percona DB

Working with Postgre

This section provides information on working with PostgreSQL.

• Creating a PostgreSQL User & Adding them to a database
• Creating a PostgreSQL Database
• How to get PostgreSQL on a VPS / Dedicated Server

General

General database articles are included within this section.

• How to Find Which Users are Attached to Databases
• How to reset your database password within cPanel
• How to Check and Repair a Database
• How to Convert a Database to UTF-8
• How to convert MySQL time
• How to change MySQL server time zone
• MySQL Storage Engines – InnoDB and MyISAM
• Learning the different data types in MySQL
• How to determine your MySQL version number