The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a...How can I change my MySQL database collation?
Usually you will be interested in changing your MySQL collation in order to solve problems with...How can I empty a MySQL database?
The easiest way to empty a MySQL database is through phpMyAdmin. Once in phpMyAdmin, select the...How to change the MySQL timezone
When you develop your website, you may have to compare a certain date/time with the current...How to change the database engine of a MySQL database table?
In this article we will show you how to change the database engine of a MySQL table. Let's...How to change the password of a Mysql user in cPanel?
If you have already created a MySQL user through the cPanel -> Mysql Databases tool you may...How to export a large database using phpMyAdmin?
If you have a large database, it may be difficult to export all of its tables at once through...How to export/import a MySQL database via SSH
In this article we will show you how to export and import a MySQL database via SSH. Managing your...How to optimize a MySQL database
One of the most important prerequisites for achieving optimal MySQL database performance is...How to optimize a MySQL database using phpMyAdmin?
It is always a good idea to keep your databases' tables optimized. Fortunately, making this...How to repair a MySQL database?
In this article we will show you two ways to repair a MySQL database. 1) Through cPanel:...How to reset the password for a MySQL database?
You may need to change the password of your database in order to improve the security of your...I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database
In order to solve this issue follow these steps: Open the MySQL dump with a text editor on...I have problems accessing my MySQL database remotely
If you have problems accessing your database at your web hosting account remotely please make...I'm getting a 'MySQL server has gone away' error in my application
There are two main reasons for this error message to show: 1) The MySQL query you are trying...Is SQLite supported?
SQLite is a software library which implements an SQL database engine. SQLite and PDO_SQLite are...What is the information_schema database?
In MySQL version 5.02 and above there is an additional database called information_schema. This...What type of databases do you support? PGSQL and MySQL?
All our servers support MySQL and PostgreSQL databases. Also with any of our hosting packages...