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
- Log in to cPanel.
- Scroll down to the "Databases" section and click on "MySQL Databases".
- Under "Create New Database", enter the desired database name.
- Click "Create Database".
Steps to Create a MySQL User
- From the MySQL Databases screen, scroll down to the "MySQL Users" section.
- Enter a username and password for the new user.
- Click "Create User".
Linking the User to the Database
- On the MySQL Databases screen, scroll down to "Add User to Database".
- Select the Database and User you created from the drop-down menus.
- Click "Add".
- Tick the box next to "All Privileges".
- Click "Make Changes" to save the settings.
Updated on: 21/10/2024
Thank you!