Please Login or Register

Knowledgebase

[How To] Set up MySQL Database(s)

When installing third party scripts that require MySQL database(s), you will be required to provide MySQL connection details.

First you must create the database. 

Login to your cPanel and click on the database manager.

MySQL database creation logos.
1. Create your database with an appropriate name. 
2. Now create your DB user and password which will be used to access the database.
3. Finally add the user you just created to the new empty database you also created. 

Now when asked to set the database connection options use use the following: 

Database Host:   localhost 
Database Name: cPanelUser_NewEmptyDbName 
Database User:   cPanelUser_NewDbUser 
Database Pass:   NewDbUserPass

Note: The cPanelUser prefix should be replaced with your cPanel username, this prefix is NOT needed for the password field.

You can not complete the installer script or save the configuration file, and use your database.

Note: DO NOT try to create databases using PHPMyAdmin (PMA).
If you try using PMA you will get permission errors. You are required to create databases, and database users via cPanel for security reasons.

Show cPanel MySQL tutorial Video Show/Hide cPanel MySQL Tutorial Video






Was this answer helpful?
Add to Favourites Add to Favourites   Print this Article Print this Article
Also Read

Powered by WHMCompleteSolution

Language:


Web Hosting
Client Login
Web Hosting

Email

Password

Remember Me


Web Hosting
Search
Web Hosting




Follow Us on Twitter