MySQL databases store your website's dynamic content β WordPress posts, WooCommerce orders, user accounts, and more. This guide covers creating databases, users, and assigning permissions in cPanel.
Creating a Database
Go to Databases > MySQL Databases. Under Create New Database, enter a name and click Create Database. Note: cPanel automatically prefixes the name with your account username (e.g., user_mydb).
Creating a Database User
Scroll to MySQL Users and click Add New User. Enter a username and a strong password. Click Create User. The user won't have access to any database yet β you need to assign it.
Assigning a User to a Database
Scroll to Add User To Database. Select your user and database, click Add. On the next page, choose All Privileges for full access (required for WordPress and most CMSs), then click Make Changes.
Using Your Database Credentials
When configuring an application (like WordPress during install), you'll need:
- Database Name: the full prefixed name (e.g.,
user_mydb) - Username: the full prefixed username
- Password: the user password
- Host:
localhost