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 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 Troubleshooting Joomla 3.1 Database Connection ErrorsHow to change Database Settings within Joomla 3.1How to reset a database password within cPanelPrestaShop 1.5 – Error – Link to database cannot be establishedWhat is my Joomla 2.5 database name?Which databases can be used with Joomla 2.5?How to Change Your Joomla 2.5 Database Username and PasswordUpdate configuration file with your new database settingsRestore a copy of your databaseCreate a blank database<<1...4567891011>>
