How to create MySQL Databases in cPanel
Creating a MySQL Database:
- Log into cPanel:
Access your cPanel account using your credentials. - Access MySQL Databases:
In the Databases section, click on Database Wizard. - Create a New Database:
In the Create New Database section, enter your desired database name.
Click Create Database.
Note: cPanel may prefix your database name with your cPanel username followed by an underscore (e.g., username_database_name). - Create a New MySQL User:
In the Add New User section, enter a username and a strong password.
It's recommended to use the Password Generator to create a secure password.
Click Create User - Set User Privileges:
On the next screen, you'll be prompted to set privileges for the user.
To grant all privileges, check the All Privileges box.
Click Next Step - Your MySQL database and user are now set up and ready for use.