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 environemnt. View the following article for a list of privileges and their availability:

See also

Did this article answer your questions?

Article last updated .