My PHP program tells me it can't access the database and gives an error message ?

MySQL - When you create a new database you have to specify a database name. Then you create a user by entering a username and password.

For best results keep your database name, database username, and database password at no fewer than 6 and no more than 7 letters or numbers.

You must add this new user to your new database.

In your script, your database name and your database username must be prefaced by your hosting account username_.  Your password, however, stands alone.

For example: If your hosting account username is "mrcertified", your database name is "testdb", your database username is "dbuser", and your database password is "passwd1977", here is how you need to put them in your script:

database server should be :   localhost
database name should be written as mrcertified_testdb

database username should be written as mrcertified_dbuser
database password should be written simply as passwd1977

Was this answer helpful?

 Print this Article

Also Read

Optimizing Wordpress on Shared Hosting

Wordpress blogs can be extremely resource intensive if you happen to experience a surge in...

After I install osCommerce I get sessions directory error ?

Set this in both your admin/includes/configure.php and catalog/includes/configure.php: From:...

Can you disable or turn off php Safe Mode?

No, we cannot disable php safe mode. All our servers have php safe mode enabled due to security...

What is suPHP ?

What is suPHP? (su = switch user, allowing one user to "switch" to another if authorised) The...

HTTP Error 500 - Internal server error

If you installed a new script and are getting the 500 error trying to load the page please see...