- In your hosting, open the Databases tab.
- Click New database and enter the Name (without the prefix; 1 to 16 lowercase letters or numbers).
- Leave Create a new user selected (it's named like the database; you can change it), click Generate for the password and save it. All privileges come checked, which is what WordPress and almost every app needs.
- Click Create database. From the list you can later give other users access, change their Privileges (for example, a read-only user), export the database or delete it.
To connect your site, use the details in the Connection details for your site box (for example, in WordPress's wp-config.php file):
- Server (host)
- The one your dashboard shows (usually localhost)
- Port
3306- Database and user
- prefix_name (as shown in the list)
- Password
- The one you chose when creating it
Databases only accept connections from your own hosting. To browse or edit tables, click Open phpMyAdmin on this same tab (how to use it).
Deleting a database removes all its data (and the user with the same name, if it can't access any other database), and can't be undone: export it first if you'll need it. If you change the user's password, remember to update it in your site's configuration.
Ask the assistant
Still have a question about this? Ask the assistant.
Was this article helpful?
Related articles
- Install WordPress in one clickWe install WordPress ready to use, with its database, on your domain or in a folder.
- Advanced tools: shortcuts to the server panelWebmail, redirects, forwarders, statistics and more from the server panel, one click away and with no password.
- Restore a backupBring your files, your databases or both back to how they were in a backup.