Problems with mysql_connect()

h3x3n

Well, I was trying to create a user authentication system, but I've run into a problem, namely that I cannot connect to the database.

Here's the code I think is necessary:

//Database Information
$db_host = 'localhost';
$db_name = 'dbname';
$db_user = 'username';
$db_pass = 'password';

//Some code I left out
mysql_connect($db_host, $db_user, $db_pass) or die ('Could not connect to server.<br />');

Here's the output:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\epostal\auth.php on line 29
Could not connect to server.

Some facts that may help:

My username definitely isn't ODBC, and I've definitely supplied a password.

My username and password are both correct.

I can login MySQL via the command prompt with that account.

The account has the correct privileges (SELECT, INSERT, UPDATE, DELETE) for that database.

If I enter the username, password and host directly into mysql_connect() The error message remains almost identical - the only thing that changes is that the correct username is reflected.

I have tried restarting both Apache and MySQL.

I have tried FLUSH PRIVILEGES.

MySQL version: 5.0?? (Can't remember or find exact version)
Apache version: 2.2.3

big_nerd

ODBC is a method of accessing Databases.

You can setup a MySQL ODBC Driver (and very useful for say, using the Data Transport Services for MS SQL, or MS Access).

It's a little strange that its trying to use "ODBC" as the username.

from my own connect script:

$sqlconnect = mysql_connect($server, $username, $password) or die ("blah blah");
$init_db = mysql_select_db("$dbname",$sqlconnect);

I get the info from a config file (which suits my needs just fine).

It pulls the IP, User, Password and passes them off just fine.

big.nerd

h3x3n

big.nerd wrote:
ODBC is a method of accessing Databases.

You can setup a MySQL ODBC Driver (and very useful for say, using the Data Transport Services for MS SQL, or MS Access).

It's a little strange that its trying to use "ODBC" as the username.

from my own connect script:
$sqlconnect = mysql_connect($server, $username, $password) or die ("blah blah");
$init_db = mysql_select_db("$dbname",$sqlconnect);
I get the info from a config file (which suits my needs just fine).

It pulls the IP, User, Password and passes them off just fine.

big.nerd

Hmm... I tried doing that too (actually my initial code pulled the variables from an external file, but to verify that it wasn't a problem with accessing the file, I put the variables in the same file as the one with the functions)