Re: MySQL Connection FailedL
| From: | Hidulf | 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
>
>
>
>