Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2000071

Re: [PHP] MySQL Connect Problem From: Olivier Clavel (Olivier.Clavel <email protected>)
Date: 07/12/00

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: ' <email protected>' 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 <email protected>

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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>