- Login to the cpanel by running the below URL in the browser:
domain.com/cpanel OR domain.com:2083
- Enter Username and Password
- You will be able to see the cPanel homepage(Dashboard) after login
- Scroll to the Databases section and click on the MySQL databases Wizard icon.
- In the Create a Database field, type a name for the database and then click Next Step.
- In the next step, you will need to create a username and password for the database.
- Type the username in the Username field.
- Create a strong password and enter it into the Password and the Password (Again) fields. Use the Password Generator, if required.
- When finished, click Create User.
- In the next section, you will decide which privileges the user has.
- If you are the website administrator and are creating the database for yourself to manage, check the ALL PRIVILEGES box at the top of the page.
- When finished, click on Next Step.
- You have now completed the setup of the new MySQL database, created a username and password to manage it and assigned privileges to that user.
- The final page of the Database Wizard (see below) gives you the options to carry out a range of related tasks.