Creating a MySQL database in Cpanel allows you to run dynamic websites such as WordPress, Joomla, or phpBB. Follow these steps to create and manage your database easily.

1. Log in to Cpanel

Go to https://yourdomain.com:2083 and log in. Then click on “MySQL® Databases”.

2. Create a New Database

Enter a name in the “Create New Database” field (e.g., sitedb) and click Create Database.

3. Create a Database User

In the “MySQL Users” section, create a username and password. This user will have access to the database.

4. Assign User to Database

Go to “Add User to Database”, select your new user and database, then click Add. In the permissions window, check “ALL PRIVILEGES”.

5. Access via PhpMyAdmin

Return to the main menu and open “phpMyAdmin”. You can now manage your database, create tables, run SQL queries, and export backups.

Note: When installing WordPress or similar systems, use your new database details (database name, username, password, host: localhost).