--- title: "Working with Databases" description: "Most websites these days are driven by a database, which stores and organizes information in a different coding language – e.g. MySQL, MariaDB, PostreSQL. If you are working with databases then..." url: https://www.inmotionhosting.com/support/server/databases/ date: 2021-04-26 modified: 2023-06-07 author: "InMotion Hosting Contributor" type: page lang: en --- # Working with Databases ![Working with Databases pillar page header image](https://www.inmotionhosting.com/support/wp-content/uploads/2021/04/working-with-databases-header-img-1024x538.png) Most websites these days are driven by a database, which stores and organizes information in a different coding language – *e.g. MySQL, MariaDB, PostreSQL*. If you are working with databases then our guides on creating, importing, exporting, connecting, and troubleshooting can help provide knowledge for your management needs. ## Creating, Importing, and Exporting Databases Learn how to create, import, and export databases in this section. - [Create and attach a database user in cPanel](https://www.inmotionhosting.com/support/edu/cpanel/create-database-user/) - [Create a MySQL Database](https://www.inmotionhosting.com/support/edu/cpanel/create-mysql-database/) - [Export a MySQL Database with phpMyAdmin](https://www.inmotionhosting.com/support/server/databases/export-database-using-phpmyadmin/) - [Import a MySQL Database with phpMyAdmin](https://www.inmotionhosting.com/support/server/databases/import-database-using-phpmyadmin/) - [Export a database through shell](https://www.inmotionhosting.com/support/website/backup-and-restore/backup-database-ssh/) - [Import a database through shell](https://www.inmotionhosting.com/support/website/import-database-through-shell/) ## Connecting This section includes popular articles regarding making a database connection. - [Connecting to a DB with MySQL Workbench 5.2](https://www.inmotionhosting.com/support/website/connect-database-remotely-mysql-workbench/) - [Connecting Remotely to your DB with Heidi SQL](https://www.inmotionhosting.com/support/server/databases/connecting-heidi-sql-database/) - [Connecting to your DB with Navicat for MySQL 10](https://www.inmotionhosting.com/support/server/databases/connect-database-navicat/) - [Connecting to a DB using PHP](https://www.inmotionhosting.com/support/website/connecting-to-a-database-using-php/) - [Setting up a Remote MySQL connection in cPanel](https://www.inmotionhosting.com/support/website/setting-up-a-remote-mysql-connection-in-cpanel/) - [How to access MySQL via command line](https://www.inmotionhosting.com/support/server/databases/mysql-command-line/) ## Troubleshooting Errors This section covers some of the common errors you may experience regarding databases. - [Check and Repair Databases](https://www.inmotionhosting.com/support/website/check-and-repair-databases-in-cpanel/) - [MySQL – 1044 Access Denied Error Message](https://www.inmotionhosting.com/support/server/databases/mysql-1044-access-denied-error-message/)  - [Why do I get a max_user_connections error?](https://www.inmotionhosting.com/support/website/error-numbers/why-do-i-get-a-maxuserconnections-error/) - [MySQL Error 1064: You have an error in your SQL syntax](https://www.inmotionhosting.com/support/server/databases/error-1064/) - [Error 1052 Column in where clause is ambiguous](https://www.inmotionhosting.com/support/website/error-numbers/error-1052/) ## Working with phpMyAdmin Effortlessly Manage Your MySQL Databases with phpMyAdmin in cPanel: Step-by-Step Walkthrough Guides for [PHP Hosting](https://www.inmotionhosting.com/php-hosting). - [How to Use phpMyAdmin To Optimize a Database](https://www.inmotionhosting.com/support/website/how-to-use-phpmyadmin-to-optimize-a-database/) - [Installing PHPMyAdmin on your Account](https://www.inmotionhosting.com/support/website/how-to-use-phpmyadmin-to-optimize-a-database/) - [How to delete or drop a table in phpMyAdmin](https://www.inmotionhosting.com/support/website/how-to-use-phpmyadmin-to-optimize-a-database/) - [How to determine the data type of a data column in phpMyAdmin](https://www.inmotionhosting.com/support/website/how-to-use-phpmyadmin-to-optimize-a-database/) ## Working with MariaDB This section includes walk-through guides for the use of MariaDB. - [What is MariaDB?](https://www.inmotionhosting.com/support/server/ssh/what-is-mariadb/) - [How to Create a MariaDB database](https://www.inmotionhosting.com/support/server/ssh/what-is-mariadb/) - [How to Delete a Database with MariaDB](https://www.inmotionhosting.com/support/server/ssh/what-is-mariadb/) ## Working with MySQL These articles cover the use of MySQL within cPanel. - [Setting up a Database to Handle Form Data](https://www.inmotionhosting.com/support/website/database-setup/) - [Managing a MySQL Database in cPanel with PHPMyAdmin](https://www.inmotionhosting.com/support/edu/cpanel/manage-mysql-database-in-phpmyadmin/) - [I need a different version of PHP/MySQL](https://www.inmotionhosting.com/support/website/different-version-of-php-mysql/) - [The Basics of Tuning MySQL on Dedicated Servers](https://www.inmotionhosting.com/support/server/databases/mysql-tuner-dedicated-server/) - [Monitoring MySQL Performance](https://www.inmotionhosting.com/support/server/databases/mysql-tuner-dedicated-server/) - [Download a Copy of your Database](https://www.inmotionhosting.com/support/server/databases/mysql-tuner-dedicated-server/) ## Working with Percona DB This section provides information on working with Percona DB. - [What is Percona DB?](https://www.inmotionhosting.com/support/server/databases/percona-db/) - [How to install P](https://www.inmotionhosting.com/support/server/databases/percona-db/)[ercona DB](https://www.inmotionhosting.com/support/server/ssh/install-percona-db-server/) ## Working with Postgre This section provides information on working with PostgreSQL. - [Creating a PostgreSQL User & Adding them to a database](https://www.inmotionhosting.com/support/website/creating-users-adding-them-to-database/) - [Creating a PostgreSQL Database](https://www.inmotionhosting.com/support/website/creating-users-adding-them-to-database/) - [How to get PostgreSQL on a VPS / Dedicated Server](https://www.inmotionhosting.com/support/server/databases/install-setup/) ## General General database articles are included within this section. - [How to Find Which Users are Attached to Databases](https://www.inmotionhosting.com/support/website/find-database-users/) - [How to reset your database password within cPanel](https://www.inmotionhosting.com/support/edu/cpanel/reset-database-password/) - [How to Check and Repair a Database](https://www.inmotionhosting.com/support/website/check-and-repair-databases-in-cpanel/) - [How to Convert a Database to UTF-8](https://www.inmotionhosting.com/support/website/how-to-convert-a-database-to-utf-8/) - [How to convert MySQL time](https://www.inmotionhosting.com/support/server/databases/how-to-convert-mysql-time/) - [How to change MySQL server time zone](https://www.inmotionhosting.com/support/server/databases/how-to-change-mysql-server-time-zone/) - [MySQL Storage Engines – InnoDB and MyISAM](https://www.inmotionhosting.com/support/server/databases/storage-engines-innodb-and-myisam/) - [Learning the different data types in MySQL](https://www.inmotionhosting.com/support/server/databases/mysql-datatypes/) - [How to determine your MySQL version number](https://www.inmotionhosting.com/support/server/databases/find-mysql-version/) --- - [How To Manage Databases in cPanel with phpMyAdmin](https://www.inmotionhosting.com/support/server/databases/manage-databases-cpanel-phpmyadmin/) - [Database Optimization: Tips Using MySQL Tuner](https://www.inmotionhosting.com/support/server/databases/mysql-tuner-dedicated-server/) - [How to determine your MySQL or MariaDB version number](https://www.inmotionhosting.com/support/server/databases/find-mysql-version/) - [How to change MySQL server time zone](https://www.inmotionhosting.com/support/server/databases/how-to-change-mysql-server-time-zone/) - [How to Create an ER Diagram in DBeaver](https://www.inmotionhosting.com/support/server/databases/create-an-er-diagram-in-dbeaver/) - [Database Corruption – Causes & Troubleshooting](https://www.inmotionhosting.com/support/server/databases/database-corruption/) - [How to Edit the MySQL my.cnf File](https://www.inmotionhosting.com/support/server/databases/edit-mysql-my-cnf/) - [MariaDB: Adding and Removing Indexes](https://www.inmotionhosting.com/support/server/databases/mariadb-adding-removing-indexes/) - [How to Install MongoDB](https://www.inmotionhosting.com/support/server/databases/how-to-install-mongodb/) - [How To Deactivate Plugins From The WordPress Database](https://www.inmotionhosting.com/support/edu/wordpress/how-to-deactivate-plugins-from-the-wordpress-database/) - 1 - [2](https://www.inmotionhosting.com/support/server/databases.md?lcp_page0=2#lcp_instance_0) - [3](https://www.inmotionhosting.com/support/server/databases.md?lcp_page0=3#lcp_instance_0) - [4](https://www.inmotionhosting.com/support/server/databases.md?lcp_page0=4#lcp_instance_0) - [5](https://www.inmotionhosting.com/support/server/databases.md?lcp_page0=5#lcp_instance_0) - [6](https://www.inmotionhosting.com/support/server/databases.md?lcp_page0=6#lcp_instance_0) - [11](https://www.inmotionhosting.com/support/server/databases.md?lcp_page0=11#lcp_instance_0) - [>>](https://www.inmotionhosting.com/support/server/databases.md?lcp_page0=2#lcp_instance_0)