Articles on: cPanel

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.

At Elitehost, we use MariaDB, which is a drop-in replacement for MySQL. MariaDB offers the same functionality and compatibility as MySQL, meaning it works seamlessly with applications like WordPress, ensuring smooth data management and performance.

Updated on: 21/10/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!