Re: MySQL Connect Problem

Jeff Wilhelm wrote: > > I am using a PHP script to connect to the database for user authentication > (using PHP4 Sessions BTW - woohoo!), except I'm having a bit of trouble > getting the connection to work. I receieve the following error message > (Access denied for user: '@localhost' to database 'C003703'), which leads > me > to believe that I'm having a problem with one of the following things: That sound's like a problem with your MySQL Access permissions. It is not really the right newsgroup for this but here it is : mysql uses the login name AND the host name to construct a userID. You can set permissions for each user depending on the machine he/she is logging from. Then, it looks like you did not set the right permissions for user@localhost. You can also set the permissions for a particular DB in the mysql.db table Have a look at the MySQL user guide for more info : http://www.mysql.com/ By the way : once you have made changes to the access tables, you need to restart mysql for changes to take effect like this : mysqladmin -u username -ppassword reload -- <<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>> _______ Olivier Clavel /_____ / TECFA-FPSE // 40, Bd du pont d'Arve // CH-1205 Genève // //_____ http://tecfa.unige.ch/~clavel/ /______/ Bureau : +41 22 705 93 72/73 Portable : +33 6 84 13 94 62