Overview
Many websites and applications need a MySQL database. WordPress, for example, uses a database to store posts, settings, users, and much more.
Basic Steps
- Log in to cPanel
- Open the MySQL Databases tool
- Create a new database
- Create a database user with a strong password
- Add the user to the database
- Assign the required privileges
Why the User and Privileges Matter
Creating the database alone is not enough. Your application also needs a database user that has permission to access and modify that database.
Common Mistakes
- Forgetting to add the user to the database
- Using the wrong database name in the website configuration
- Entering the wrong database username or password during installation
If you are setting up WordPress, also read our WordPress related guides or order hosting through our client area if you have not launched yet.