PHP can't access MYSQL database

asked Mar 21, 2012 in Website Builder by GeekNew (720 points)
Hello everyone

My PHP program tells me it can't access the MYSQL database because of incorrect username/password. I've checked the configuration settings in my script and everything in there looks normal. can anyone tell me what to do?

1 Answer

0 like 0 dislike
answered Mar 21, 2012 by mike231 (2,480 points)
Hi there,

When you create your MySQL database, first you create a database by giving it a 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. Then you must be sure to add the user to the 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 "joedoe1", your database name is "testdb", your database username is "dbuser", and your database password is "passwd", here is how you need to put them in your script:
database server should usually be localhost
database name should be written as joedoe1_testdb
database username should be written as joedoe1_dbuser
database password should be written simply as passwd

hope this helps