Warning: mysql_query() [function.mysql-query]: Access denied for user ''@'localhost' (using password: NO)

Question

Good morning, I am running crazy trying one of the my first php codes with mysql. I have tested this on two servers, one hosted somewhere else and also using a local wamp server, the results are the same so I must have something bad in the code creating the connection or later when I run the query.

For wamp I have already verified the php.ini and also the MySQL privileges, in the code I am using the credentials stated there. I would appreciate some guidance.

 <?php

 // Function: connect to a database. Returns the database connection.




  function connect_db($host, $id, $pwd)
  {

  $connection = @mysql_connect('localhost', 'username', 'password')
        or die('connection problem:' . mysql_error());
    mysql_select_db('database_db');
    return $connection;
    if (!$connection)
  {
    print ("internal error " . mysql_errno() );
  }
  }

 //get names from form

$ID = $_POST['ID'];
$Event= $_POST['Event'];
$Date = $_POST['Date'];
$Time = $_POST['Time'];
$Venue= $_POST['Venue'];
$TypeID= $_POST['TypeID'];
$Score= $_POST['Score'];
$Member = $_POST['Member'];

//insert values
$myquery = "INSERT INTO Results(ID, Event, Date, Time, Venue, TypeID, Score, Member )VALUES('$ID', '$Event', '$Date', '$Time', '$Venue', '$TypeID', '$Score', '$Member')";
$answer = mysql_query($myquery);

if (!$answer) {
    $message  = 'Invalid query: ' . mysql_error() . "\n";
    $message .= 'Whole query: ' . $myquery;
    die($message);
}

while ($row = mysql_fetch_assoc($answer)) {
    echo "Your results were entered successfully";
    echo "<br>";
    echo $row['Id'];
    echo $row['Event'];
    echo $row['Date'];
    echo $row['Time'];
    echo $row['Venue'];
    echo $row['TypeID'];
    echo $row['Score'];
    echo $row['Member'];
}

?>

Danger: You are using an obsolete database API and should use a modern replacement. You are also vulnerable to SQL injection attacks that a modern API would make it easier to defend yourself from. — Quentin
– Quentin, Commented Jan 15, 2014 at 9:38
@Quentin, can you elaborate? As said before this is my first experience with programming. At this stage I need the fix the connection to the database. The API thing can be sorted later, I have no plans to publish this work. — Joy
– Joy, Commented Jan 15, 2014 at 9:40
@Joy as Quentin picked up in my answer, your error message states the connection hasn't provided a username and password, yet in your code you have a username and password - have you provided the correct code and the correct error message? — Ryan
– Ryan, Commented Jan 15, 2014 at 9:41
@Ryan I have used the same username and password as stated on localhost/phpmyadmin. I have checked and the user has ALL PRIVILEGES to the database too... — Joy
– Joy, Commented Jan 15, 2014 at 9:45

Ryan · Accepted Answer · 2014-01-15 09:39:20Z

1

You need to change 'username' and 'password' to your actual credentials in your mysql_connect call.

Unless of course, those are your desired credentials - then you need to ensure that the user actually exists and has permission to access the database.

As a side note, use of mysql_* functions is deprecated and it's recommended to use mysqli_* or prepared statements.

answered Jan 15, 2014 at 9:39

Ryan

3,5801 gold badge24 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Quentin Over a year ago

But the error message says that there is no password being used, not that the password is wrong.

Joy Over a year ago

I have done that in the actual code, but I wouldn't paste them in a public forum ;)

Ryan Over a year ago

Then you need to check your credentials.

Joy Over a year ago

I find it odd in the message that the username is empty while it is in the code and that I get a similar problem on the public server as on the local server...(of course I am using different credentials for each!)

Ryan Over a year ago

Are you sure you're not getting the error from an alternative script?

|

Asromi rOmi · Accepted Answer · 2014-10-29 02:04:51Z

0

try to given access table to user :

grant all On [tabelName] to [userName];

example

grant all On mysql.* to root;

answered Oct 29, 2014 at 2:04

Asromi rOmi

1992 silver badges7 bronze badges

Collectives™ on Stack Overflow

Warning: mysql_query() [function.mysql-query]: Access denied for user ''@'localhost' (using password: NO)

2 Answers 2

9 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related