How to setup a database using the MySQL Database Wizard in cPanel

How to setup a database using the MySQL Database Wizard in cPanel?

  1. Login to your cPanel account.
  2. Then click on MySQL Database Wizard.
  3. Enter a new name for the database and click on Next Step. Enter a username and password.
  4. And then click enter.
  5. It will take you to a new page where you need to tick mark the All Privileges box.
  6. That’s it. Your MySQL database is created as well as the new used added for the database. Further username and password will be needed for the scripts that are required to connect the database.  
  7. Return to home and click on MySQL Database icon where you can see the new database that you set up newly. 
  • 74 Users Found This Useful
Was this answer helpful?

Related Articles

Can I connect to MySQL from my computer

Yes, you can. Just need to add your IP address in the hosts allowed to connect to MySQL. Adding...

Can’t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

If you receive this error message when connecting to MySQL trough command line on your VPS...

Export and import of MySQL databases from cPanel

For management on databases in your hosting account you can use the web application phpMyAdmin....

Export and import MySQL databases via SSH

If you want to import your MySQL database through SSH on your VPS or dedicated server, use the...

How to see the MySQL variables

Log into your MySQL database and type: show variables; You will see the following: mysql>...

Powered by WHMCompleteSolution