mysql_connect() problems

Malice2025

I'm having problems w/ mysql_connect(). For some reason, it won't take the username and password arguments. Whenever I use it, it insists that (no matter what I imput for the user and password fields) that the user is SYSTEM@localhost. I don't think its my code that's wrong, because installing post-nuke, it has the same problem.

I'm not sure if I have something set wrong in php.ini or maybe I didn't do something in my sql.

For Post-nuke, I used "grant" to create a user name "PostNuke@localhost". However, this error appears again as if mysql_connect() isn't doing anything w/ the other 2 input variables:

Error (1044) : Access denied for user: 'SYSTEM@localhost' to database 'Post_DB'

I'm using Apache 4.0.46 and PHP 4.2.3 on a windows 2000 Prof. platform.

This problem has been bugging me for a long time - as I've been forced to grant privileges to SYSTEM@localhost to all my databases (which I don't want).

😕 😕

Any help would be greatly appreciated
Thanks,
Lawrence

BeastRider

Besides creating a user, the user has to be associated with the particular database you are going to use. If you have cpanel with mysql updates, this is easy. If you are doing this in command line mode, I think you have to set up the user, then GRANT database access privileges to that user.

Malice2025

Well, I think the user created successfully since I can connect using the command-line interface, just not w/ PHP (though I don't know why)

BeastRider

You've done this (or something similar?):

GRANT ALL PRIVILEGES ON . TO monty@localhost
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

If you haven't got a copy of mysql control center off the mysql website, you might want to do so... makes user and db admin easier

Malice2025

yes

I used:

Grant all privileges on Post_DB to PostNuke@localhost identified by 'somepassword' with grant option

The problem is the code is something like:

(assume the $url is correct)

$username = "bob";
$password = "joe";

mysql_connect ($url, $username, $password);

In this case, the error says access denied and the user is ACTUALLY, SYSTEM@localhost instead of bob@localhost

Spames

Did you ever figure out this problem?

I'm having the same one.. It turns out that it's ignoring the values passed, and using the owner of the script's userid as the login. I just don't know how to fix it.

Malice2025

Well,

My problem turned out that it was using the wrong PHP module for apache. I was using apache2, but using the older PHP module.