Knowledgebase
Portal Home > Knowledgebase > MySQL > [How To] Set up MySQL Database(s)
[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.
 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/Hide cPanel MySQL Tutorial Video
|
Also Read
Powered by WHMCompleteSolution