Using PHP to connect to MYSQL server

[amrithk]

Hi,

I am new to PHP and MYSQL. I recently installed both PHP and MYSQL (the community edition) on my computer and I have been trying to use PHP to connect to and access MYSQL (instead of using the MYSQL command line).

 

I used the mysql_connect() function on a test script but I am getting the following error message when I test the script.

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user ' '@'localhost' (using password: YES) in filename on line 10.

 

I understand that I am being denied access because I have not submitted the right credentials. However, I am testing this code on my local computer where I have full privileges. What might be the reasons I am getting this message? What are the possible solutions? Do I need to configure mysql such that it recognizes that I am using it on a local computer?

 

Thanks,

[chigley]

Paste your code please?

[amrithk]

This was my code.

 

<?php

mysql_connect("localhost"," ","stargate") or die("Could not connect");

?>

[per1os]

Your username is blank.

 

// original
mysql_connect("localhost"," ","stargate") or die("Could not connect"); 

//mysql_connect($HOST, $USERNAME, $PASSWORD) that is how it should be setup

// corrected
mysql_connect("localhost","stargate", " ") or die("Could not connect"); 

Try that.

[amrithk]

I tried different combinations for the function. I entered my username and password, just my username, just my password and did not enter anything but none of these combinations seemed to work.

 

I don;t think its a problem with my username and password because when I type http://localhost on my web browser, I supply the same user name and password to access all the files.

 

What might be the problem?

[per1os]

I do not know, it has to be something with the username and password.

 

www.php.net/mysql_connect

 

If it wasn't it wouldn't return the error message it did.

[SkyRanger]

OK, you may think this is a stupid question, but you would be surprised.

 

Are you using cPanel?

 

Did you connect the username to that database?

 

You would be surprised to see how many people have done that,  I have done that.