Creating a MySQL Database and User

Most CMS (WordPress, Joomla, Drupal, OpenCart) run on MySQL. A database is created in cPanel in 1 minute.

Steps:

1. cPanel → “Databases” section → MySQL Databases.
2. Create New Database — enter a name (e.g. example_wp) → Create Database.
3. Scroll down to MySQL Users → Add New User:
   • Username — e.g. example_user.
   • Password — strong or Password Generator.
   • Save the login and password — needed for CMS install.
4. Add User to Database → pick user and database → click Add.
5. On the next step pick ALL PRIVILEGES and click Make Changes.

Connection details for CMS:

• Database Host: localhost
• Database Name: example_wp (with prefix — usually your cPanel-name_dbname)
• Username: example_user
• Password: the one you set

To manage the database — phpMyAdmin (see separate article).