How do I create a MySQL database in Cpanel?

 

Step 1. Login and select MySQL databases


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



Once you've logged in, select MySQL databases from the list. 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.



Step 2. Create your DB and User


Type in a name for your new database and click the "Add DB" button.



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



Step 3. Set Permissions and finish


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. If this hasn't been supplied to you by your web host, you can get it from this screen in this location: 



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.

 

  • 141 أعضاء وجدوا هذه المقالة مفيدة
هل كانت المقالة مفيدة ؟

مقالات مشابهة

Which are the modules that sources are not open?

There are very few in numbers.  For 2.10.x series, only licensing, administration and portfolios...

What type of Multi-language do you support?

We do support Multi language but English is defaulted. You can change the language for...

How long the license will be valid ?

We issue license for left long. You do not have to renew it at all.  Our support is available...

Can I remove the "Powered by Eicra Soft Ltd" brand text?

Yes, as long as you have the Branding Removal; which costs $99 in addition to the script. Note...

I don't know anything about programming, can I still run your application?

Definitely! Our vision is to create the most effective and easy user interface script that...