CODEWITHSUNDEEP
phpmysqlmysql-error-1045
slandau
slandau

Reputation: 95

PHP cant connect to MySQL

$link = mysql_connect('localhost', $username, $password);
if (!$link) 
{
     die('Could not connect: ' . mysql_error());
}

I get this error:

Could not connect: Access denied for user 'www-data'@'localhost' (using password: NO)

Why?

Edit:

$username="root";
$password="root";
$database="test";

    function Save($name)
    {
        $link = mysql_connect('localhost', $username, $password);
        if (!$link) {
            die('Could not connect: ' . mysql_error());
        }
        @mysql_select_db($database) or die( "Unable to select database");
        $query = "INSERT INTO test (name)" .
                 "VALUES ('" . $name . "')";
        mysql_query($query);
        mysql_close();
    }

Upvotes: 1

Views: 1739

Answers (5)

Gajendra Bang
Gajendra Bang

Reputation: 3583

$username="root";
$password="root";
$database="test";

    function Save($name)
    {
        global $username;
        global $password;
        global $database;

        $link = mysql_connect('localhost', $username, $password);
        if (!$link) {
            die('Could not connect: ' . mysql_error());
        }
        @mysql_select_db($database) or die( "Unable to select database");
        $query = "INSERT INTO test (name)" .
                 "VALUES ('" . $name . "')";
        mysql_query($query);
        mysql_close();
    }

Upvotes: 0

texpert
texpert

Reputation: 162

I think the problem is that, you are trying to connect to the database twice. Somewhere in your code, you are already trying to connect to the database with username as "www-data"...... and again you are connecting to the database with username "root".

Also the password you are providing with the username "www-data" is wrong, thats y you getting the error message.

Upvotes: 0

Phil
Phil

Reputation: 164764

From your edit, the issue appears to be a scoping one.

You're attempting to make a connection inside a function where the $username, $password and $database variables are defined outside that function.

I suggest you read the Variable Scope section of the manual and turn up your error reporting as @netcoder suggests in the question comments.

Upvotes: 1

Svisstack
Svisstack

Reputation: 16616

Your $password variable is empty ((using password: NO)) then you trying log into www-data user without password, and server result is access denied. Propably this user have setted password.

Upvotes: 2

thejh
thejh

Reputation: 45568

Did you give $username and $password values? Something like this?

$username="root";
$password="";

Upvotes: 5

Related Questions