MySQL® Databases
Create a MySQL database and its user for an application such as WordPress, change the user's password, or delete a database.
MySQL® Databases lists the databases on your hosting account and lets you create and delete them. Applications
such as WordPress keep their content in a database. Each database comes with exactly one user, which has all
privileges on that database and nothing on any other. Both names start with your hosting account's username and an
underscore, for example acme_wp, and the panel adds that part for you.
If you would rather be guided one step at a time, use the Database Wizard.
Create a database
- In the panel, open Databases → MySQL® Databases.
- Under Create New Database, type the name in New Database, after
the prefix. Use lower-case letters, numbers and underscores, for example
wordpress. - Type the user's name in Database User, for example
wp. The same rules apply. - Enter a Password, or click Generate for a strong one. It needs at least 10 characters with upper- and lower-case letters and numbers.
- Copy the password somewhere safe: your application needs it, and the panel does not show it again.
- Click Create Database.
The panel confirms that the database "and its user were created". Give your application these settings: the
database name and user name with the prefix, the password, and localhost as the database host.


Read the table
Current Databases shows each database with its Size and its Privileged User. A Suspended badge means the database is switched off. Use Search to find a database or user, and click a column heading to sort.
To see or change the tables inside a database, click phpMyAdmin at the top of the page. See phpMyAdmin.
Change the user's password
- Click Change Password on the database.
- Enter a New Password, or click Generate.
- Click Change Password.
Delete a database
- Click Delete on the database.
- Read the message, then click Delete database.
Common errors
| Message | Why | What to do |
|---|---|---|
| Use lower-case letters, numbers and underscores. | The name contains a hyphen, a dot, a space or another character. | Use only a–z, 0–9 and _. Capitals are turned into lower case for you. |
| With the account prefix, MySQL user names can be at most 32 characters. | The prefix and the user name together are too long. | Choose a shorter user name. |
| The database name field must not be greater than … characters. | The prefix and the database name together are too long. | Choose a shorter name. |
| The password field must be at least 10 characters. | The password is too short. | Use a longer one, or click Generate. |
| The password field must contain at least one uppercase and one lowercase letter. | The password has letters of one case only. | Add both, or click Generate. |
| The password field must contain at least one number. | The password has no digit. | Add a number, or click Generate. |
| That item already exists. | A database or user with that name already exists. | Choose another name. |
| You have reached the limit of your plan. Remove something first, or move to a bigger plan in Billing. | Your plan's database limit is reached. | Delete a database you no longer use, or change your plan. |
Related
- Database WizardCreate a MySQL database and the user your website connects with, one step at a time, and get the connection settings at the end.
- phpMyAdminOpen phpMyAdmin from the panel and sign in with a database user to browse tables, run queries, and import or export a database.
- Install WordPressInstall WordPress on your domain with WordPress Manager, then sign in to your new site.
- BackupSee the backups of your hosting account, create a new one, and restore websites, email, databases or files from one.
Was this page helpful?
Sent without cookies; we do not store your IP address.
Still stuck? Contact the team; tell us the page and what you see.