MySQL Databases

Our service includes support for MySQL databases.

How do I create a MySQL database?

You can easily create MySQL databases in your account management control panel.

How do I change the password for a MySQL database?

You can change a database password in the account management control panel.

How do I delete a MySQL database?

You can easily delete your MySQL database in your account management control panel.

Why does PHP say that MySQL is not available?

Error messages saying that MySQL is not available for PHP are almost always caused by uploading an incorrect "php.ini" file.

How do I connect to a MySQL database?

Explains how to connect to MySQL databases from PHP and CGI scripts (and even from other computers, in some cases).

Can I use the "mysql" command line tool?

Advanced users can connect to a MySQL database using the "mysql" command-line tool.

Do I have to use SQL commands to work with a MySQL database? Can I use phpMyAdmin instead?

If you don't want to manage your MySQL database through the Unix shell, you can use the phpMyAdmin program we provide.

How do I import a SQL “dump” file to MySQL?

You can use phpMyAdmin to import a SQL dump file into your MySQL database.

How do I quickly add large amounts of data to MySQL?

You can avoid problems when adding more than a few thousand rows to a database table.

Do you create backups of MySQL databases?

We make daily backups of all MySQL databases.

Do you automatically optimize MySQL tables?

We automatically optimize small MySQL tables once a month.

What version of MySQL do you use?

We use MySQL version 5.5.53 with additional security "patches".

How do I connect to MySQL from my own computer?

If you wish, you can enable remote connections to your database so that you can connect directly to the database from your own computer.

How do I duplicate a MySQL database?

The phpMyAdmin tool can be used to export and then import a database, allowing you to create a duplicate database with a different name.

Can I create additional MySQL usernames with different permissions?

We're occasionally asked if it's possible to create additional MySQL usernames that have different permissions for the same database.

Can I use MySQL "triggers"?

MySQL triggers are supported.

Can I use MySQL “stored procedures”?

MySQL stored procedures are supported.

How large and busy can a MySQL database be?

This page explains our policies about MySQL database size and CPU load.

MySQL Password Hashing

Explains the technical details of how we “hash” MySQL passwords.