Start a conversation

How to Create a MySQL Database from cPanel ?

First, log in to your CPanel account. If you don't have your username and password, you'll need to contact your web hosting provider. 


by entering the following URL in your web browser:

http://yourdomainname.com/cpanel
http://yourdomain.com:2082 


Once you've logged in, select "MySQL databases Wizard" from "Databases" portion. Keep in mind that your Cpanel account may be using a skin or different theme, so it will not always look exactly like the screenshot below.

Type in a name for your new database and click the "Next Step" button.

Then, type in a Username and a Password into the relative fields and click the "Create User" button.

Once your Database and User have been created, you need to give that user permission to use that database. We do this by selecting the username we created from the drop down and the database we created from the drop down, making sure the "All" checkbox is selected and clicking the "Add User to DB" option.

The last thing you will need is the MySQL server hostname.

Note that the Username and Database will be prepended with your Cpanel login name. For example, if you created a database called DB and your cpanel login was mysite then your new database will be mysite_db.

That's it. You're now ready to use the MySQL database that you just created.

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Eicra.com

  2. Posted
  3. Updated

Comments

  1. Abu Mozaffor Ali Ashfaque (BiploB)

    It is a nice and useful area regarding having knowledge to a beginner like me. Thanks