mysql

[thezone1]

Hi im getting a mysql error on the index page of my site

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'thezone1_form'@'localhost' (using password: YES) in /home/thezone1/public_html/inc/db.php on line 27

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/thezone1/public_html/inc/db.php on line 29
Couldn't open database!

i have tried the user 'form' and 'thezone1_form' and the database 'thezone1_users' and 'users'

so i figure im naming them correctly since i have tried both i have added priviledges for the uesr

anyone got any ideas??

 

[Synkc]

Your database username should be thezone1_form; when I visit your site is shows that you're currently using form as the user.

If you've given significant privileges to your user for your database, have you checked whether the password your using is correct, and that those privileges, and the database, still exists, and are not corrupt?

 

[thezone1]

Ok so i recreated the database and the user and im still getting this


Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'thezone1_member'@'localhost' (using password: YES) in /home/thezone1/public_html/inc/db.php on line 27

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/thezone1/public_html/inc/db.php on line 29
Couldn't open database!

this is how im reffering to the data base

define("MYSQLUSER", "thezone1_member"); // mysql username
define("MYSQLPASS", "Edited"); // mysql password
define("MYSQLDB", "thezone1_users"); // mysql database name

 

[Corey]

I edited out the MySQL password you posted for security reasons. The password you posted above contained a space at the end of it which could cause your problem. Double check the file and make sure there is no space after the password and before the "

-Corey