How can I create a MySQL database?

MySQL databases play a crucial role in powering web applications, such as content management systems like WordPress and ecommerce platforms. Follow these steps to create and manage MySQL databases in cPanel:

Steps to Create a MySQL Database

1. Log in to cPanel.
2. Scroll down to the "Databases" section and click on "MySQL Databases".
3. Under "Create New Database", enter the desired database name.
4. Click "Create Database".

Steps to Create a MySQL User

1. From the MySQL Databases screen, scroll down to the "MySQL Users" section.
2. Enter a username and password for the new user.
3. Click "Create User".

Linking the User to the Database

1. On the MySQL Databases screen, scroll down to "Add User to Database".
2. Select the Database and User you created from the drop-down menus.
3. Click "Add".
4. Tick the box next to "All Privileges".
5. Click "Make Changes" to save the settings.

Updated on: 21/10/2024