MySQL Database Troubleshooting
Troubleshooting "Cannot connect to the database" errors... Here are a few initial things (common mistakes) to take a look at:
- Make sure that after you created your database and database user that you didn't forget to ADD the database user to the database (at the bottom of the "Databases" section in Control Panel > MySQL Manager you'll see two drop down menus "User:" and "DB:" followed by an "Add User to DB" button).
- Confirm that you entered localhost as the database host/server name and if applicable that you specified mysql for the database server type.
- Make sure that you specified the correct database and database user names. Besides noting the fact that these values are cAsE sEnSiTiVe be aware that your account userid (usually your cPanel 's username) is added with an underscore as a prefix to both your database and database user names (cpanelusername_databasename rather than just databasename and cpanelusername_databaseuser instead of just databaseuser).
- As far as the password make sure that you use the password that you assigned to your database user in MySQL Manager (NOT your account password)
- if your domain name is "domain.com"
- if your account userid is "testser"
- if you created a database named "smf"
- if you created a database user named "forum"
- if you assigned user forum the password "46778"
- if you added forum to the smfdatabase
...then you would enter the following logon/connection info:
database server type = mysql
server name = localhost
database name = testser_smf
database user name = testser_forum
database user password = 46778
Mysql databases can be backed up by doing the following: Go to 'Backup', in cPanel. Underneath...
In the cPanel you will find an Icon labeled MySQL Databases. (If you have not created the...
Open phpMyAdmin and select the database from where you want to export data and/or structure. Go...