Hi guys... I've got a little problem I'm sort of perplexed about. I have PHP compiled
on my system with MySQL support. PHPINFO shows the MySQL support
(http://www.expert-html.com/phpinfo.php). but it sure doesn't appear to be there.
MySQL works fine, as I can connect through DBI on the Perl side with no problems
whatsoever. Whenever I try to connect via PHP, it gives me this error:
Warning: Access denied for user: 'root@localhost' (Using password: NO) in mysql.php
on line 13
Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using
password: NO)
in mysql.php on line 13
of course this is running under root (I'm running thr script from the command line),
but the script will be ran by Apache when I am finished. It doesn't matter what
username and password I use, it always says the password isn't there, even though it
is and I know the password is correct. Here's the actual connect line here:
$db = mysql_connect("localhost","username","password");
I can use any authorized username and password in there, and it still tells me I'm not
using a password. This is also the case when I try to use prewritten software that
interfaces with MySQL (though PHP and PostgreSQL work perfectly).
Of course I don't have a mysql.so file since PHP is using the MySQL header and library
files... If I try to compile it without specifying a directory it sort of "locks up"
PHP (displaying the phpinfo page simply causes it to keep loading for several minutes,
until it finally times out with the server, and doesn't give me any info whatsoever).
I'm running PHP v4.0.6, and MySQL 3.23.41.
Any info would be greatly appreciated...
Take care,
Randall
