Re: MySQL Connection FailedL

From: Date: Mon, 17 Sep 2001 14:51:34 +0000
Subject: Re: MySQL Connection FailedL
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-12497@lists.php.net to get a copy of this message
check on your code on line 83 and 84, it looks making a connection to the database without password. so the mysql return access denied. -- Hidulf http://www.hidulf.com "Andres Figari" <andres@photoplankton.com> wrote in message news:20010916185143.73998.qmail@pb1.pair.com... > Hi, > > I'm trying to get IRM to work with my MySQL server. IRM uses php3. It > worked for a bit (entry 30 form the MySQL log as shown below). Suddenly, > affter fidling with (i believe this is what it was) the file php.ini I know > get this: > > Warning: MySQL Connection Failed: Access denied for user: 'apache@localhost' > (Using password: NO) in ./irm.inc on line 83 > Warning: MySQL Connection Failed: Access denied for user: 'apache@localhost' > (Using password: NO) in ./irm.inc on line 84 > Warning: MySQL: A link to the server could not be established in ./irm.inc > on line 84 > > The MySQL log files say this: > 010916 7:06:03 30 Connect apache@localhost on > 30 Init DB irm > 30 Query SELECT * from users where (name = 'admin' > && password = 'admin') > 30 Query SELECT * FROM prefs WHERE (user = > 'Admin') > 30 Quit 010916 7:10:36 > 31 Connect Access denied for user: > 'apache@localhost' (Using password: YES) > > I tried using the database with the user and password and it worked. For > some reason I think that there is a miscommunication between the php page > and mysql in that php says "Using password: NO" and MySQL says "Using > password: YES". I cannot remember what I changed unfortunately :( Has > anyone encountered this before who can give me a freindly tip? > > Andres > > > >

« previous php.db (#12497) next »