[SOLVED] Getting error Warning: mysql_query() [function.mysql-query]: Access denied

[$username]

Hello PHP guys,

    Here is a new one I dont understand why the is not working.

Here are the errors

 

 

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in    line 51

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in    line 51

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in    line 57

 

Here are those lines.

 

$query=("SELECT * FROM userlogin ORDER BY `ID` DESC LIMIT 0,80");
mysql_query($query);

 

Thank you,

Brett

[pocobueno1388]

Your connection to the database isn't working...double check you information.

[$username]

well its to weird that it works for all my other stuff. I use a single connection file called DBOPEN.php. This works for everything else. I will try some other stuff.

 

Brett

[$username]

After looking in to it. It looks to me an issue with PHP5 and MYSQL5. I was able to get it to work fine with version 4 of both.

 

If some one knows how to fix please advise.

 

Thank you,

Brett

[sKunKbad]

I think a lot of times hosts have little tips regarding database hook-up, and you might check with your host. Post your connection script and let us take a look at it... minus the real password and username of course.

[$username]

After a reinstall of the 3 goods AMP I have this working now.

 

When people say your best just installing them all on their own. They are right. It works better then programs that have them packaged. (WAMP, PHPeasy)

 

Thanks,

Brett