Connect to a MySQL Database
Posted by H9 Admin on 07 November 2014 11:34 AM
In order for your MySQL database to work as intended, it will need a script calling or querying the database for the information it stores. In order to do this, you must connect your script to the database with a configuration file.
Database driven scripts, such as Wordpress, WHMCS and Joomla, will generally have a default configuration file ready for you to edit with the appropriate information. Below you will find examples of what this access information will look like:
Host Name = localhost (literally input localhost)
// ** MySQL Settings ** //
While it is possible to connect to the database using your cPanel username and password, we NEVER recommend this. Every time you change or reset your cPanel password your databases will stop working until configuration files are updated.
Tips and Tricks for Moving Databases
MySQL User Has No Privileges
Since the 11.25 update, we've noticed an occasional bug where adding an IP to the MySQL remote access list results in the corresponding MySQL user having no privileges.
In order to get the correct privileges added: