Working with Databases

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

• Creating, Importing, and Exporting MySQL Databases
• How to create and attach a database user in cPanel
• Import a database through shell
• Import a MySQL Database using phpMyAdmin
• Export a Database using phpMyAdmin

This section includes popular articles regarding making a database connection.

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

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

• MySQL - 1044 Access Denied Error Message
• Why do I get a max_user_connections error?
• Explaining the Max_User_Connections Error
• MySQL Error 1064: You have an error in your SQL syntax
• Error 1052 Column in where clause is ambiguous

This section includes walk-through guides for the phpMyAdmin tool, which is available in the cPanel, and lets you administer your MySQL Databases.

• 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

General database articles are included within this section.

• 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