Skip to main content

How to create MySQL database and User

  • 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.

Leave a Reply