Creating a MySQL database

First, log into your DreamHost panel. Once logged in, navigate to the (Panel > 'Goodies' > 'MySQL Databases') page. On this page you'll see a full list of your MySQL hostnames and databases.

Creating a MySQL database

To create a database, scroll to the bottom of the MySQL Databases page and fill out the following fields.

Mysql-create-form.png
Field Number Field Name Action and Description
1callout.png Database Name Enter a unique name for the database. Database names must be unique across the entire DreamHost system, and can only contain numbers, the letters a-z, and underscores (_). Picking a name that is longer and descriptive is recommended. For clarity, DreamHost suggests putting your domain in the database name such as "blog_example_com" instead of a less clear example of "blog12345". NOTE: Once you have created the database, you cannot rename it.
2callout.png Use Hostname / New Hostname Here you can create a new hostname or select an existing one from a drop-down menu if any exist. Creating a hostname for each domain is generally recommended to prevent downtime should you remove a domain from your account in the future, and find out that other sites used a hostname on it and no longer functions.
3callout.png First User / New Username Here you can create a new MySQL user or select an existing one from a drop-down menu if any exist. For security reasons, having a MySQL user for each database is recommended so that any compromised site or credentials cannot be used to access your other databases.
4callout.png New Password If you are creating a new user, enter a password for that user here. If you select an existing user, this field is disabled.
5callout.png New Password Again If you are creating a new user, re-enter the same password as above here. If you select an existing user, this field is disabled.
6callout.png Database Comment Enter a description of your database here for organizational use. Optional
Mysql-create-button.fw.png

When all required fields have been entered, click Add new database now! to begin the database creation process.

  • Adding new databases or users, changing MySQL user passwords, and deleting databases or passwords generally takes affect within 5 minutes.
  • Newly added hostnames will function for websites within 5 minutes, due to all of your hostnames being written to your webserver(s) /etc/hosts file.
  • Using a new hostname for phpMyAdmin may take up to 4 hours to function due to DNS propagation time.

Database privileges

Not all database privileges are available in a shared MySQL environment. View the following article for a list of privileges and their availability:

What MySQL server is the database created on if I have a MySQL VPS?

It's recommended to only have a single database server that all of your databases use. When you purchase a MySQL VPS, it's possible some of your databases could be split between the old shared MySQL server and the new MySQL VPS. To fix this, you should merge the databases onto the new server. View the following article for instructions:

See also

Did this article answer your questions?

Article last updated .