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.

How do I connect to a MySQL database from my scripts?

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 text file into MySQL?

You can use phpMyAdmin to import a text 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.0.51a 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 connect to a MySQL database from my PC using ODBC?

You can install an ODBC driver which will allow you to remotely connect to your database from your Windows 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 use the MySQL Load Image command to store images in my database?

Since our servers are shared, MySQL users cannot use the Load Image command. However, you can use a simple script to achieve the same effect.

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.

How large and busy can a MySQL database be?

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

How can I tell when MySQL maintenance is happening?

When our MySQL servers are unavailable due to maintenance (which is rare), we provide a way for your scripts to detect this.

Can I use MySQL "triggers"?

The version of MySQL we currently use doesn't allow triggers.