How to Create a MySQL Database in cPanel
When you create a database, many users are unaware that there are several other items that you need to do as well. The new database creation process actually involves:
- Creating a database
- Creating a database user
- Giving your database user access to work with your database
Luckily for us, cPanel includes a MySQL Database Wizard that walks you through each of these steps.
Creating a database in cPanel using the MySQL Database Wizard
- Log into your cPanel.
- Click the MySQL Database Wizard under the Databases heading.
- Next to New Database enter a name for your database and click Next Step.
- Next to Username enter a username.Enter a password next to Password, enter it again for Password (Again) and then click Create User.
- On the next page, you'll assign privileges for the user to the database. Check the box next to All Privileges and then click Next Step.
Congratulations, now you know how to successfully create a database!
Support Center LoginOur Login page has moved, Click the button below to be taken to the login page.
Social Media Login
2017-11-18 6:56 pm
After following the provided steps above it creates a data base.
BUT AFTER THAT WHEN I GO TO PhpMyAdmin i can NOT find my data base.
using phpMyAdmin console and typing "show databases;"
it show the created database!!
I have to type its name in the url to use it and it never show in the left panel of phpmyadmin
SO do you have nay solutions it is annoying and can not handle it any more
I need URGENT solution so i can import my local database using phpMyadmin
2017-11-20 11:22 am
Sorry to hear about the frustrations with the creation of the database and then seeing it in the phpMyAdmin. In order for us to troubleshoot it we would need more information about the account. Primarily, we would need the account name or primary domain. If you want to handle this issue privately, then please contact our live technical support team via phone/email/chat.