mysql_connect() always denies access

Question

I have phpMyAdmin running with MAMP, and I am finding it impossible to use mysql_connect().

$_db_connect = mysql_connect("root", "localhost");

Produces an error in php_error.log: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'root'@'localhost' (using password: NO) in /....../common.lib.php on line 19

I've checked out the privileges:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' WITH GRANT OPTION

GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION

and I am simply stumped. I've created new users with passwords just to get the same result. Strangely it always says (using password: NO), even when I attempt to connect as a user witha password:

$_db_connect = mysql_connect(MYSQL_HOST, MYSQL_USERNAME, MYSQL_PASSWORD);

Any advice is welcomed. Thanks!

http://php.net/manual/en/function.mysql-connect.php third param should be password — YamahaSY, Apr 11 '12 at 13:19
your root has password. `mysql_connect('localhost', 'mysql_user', 'mysql_password');` — Vytautas, Apr 11 '12 at 13:20

score 4 · Answer 1 · edited Sep 08 '16 at 13:38

That error message for dummies:

Access denied for user 'root'@'localhost' (using password: NO)

It has three parts, each of it contains important information. Let's see:

Access denied - In plain words, this means: Get lost! Don't try to connect to me.
for user 'root'@'localhost' - That says who is denied access, that user. The name: root and at (@) the following server: localhost.
using password: NO - Just some nice additional information that when trying to access and giving the user-name, no password was used.

So now on with the privileges you have:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'
 IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B'
 WITH GRANT OPTION
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION

It basically says, that the user 'root'@'localhost' needs to use a password to get access. As the error message tells you, you are not using a password. So that is likely to be the cause of the error, the password is missing.

Add the password and try again.

score 3 · Answer 2 · answered Apr 11 '12 at 13:24

You forgot to enter the passwort. If I guess right then is the hash 81F5E21E35407D884A6CD4A731AEBFB6AF209E1B the password "root" (to confirm enter this SQL statment: SELECT PASSWORD('root').

Try to login with the correct password:

$_db_connect = mysql_connect("localhost", "root", "root");

score 1 · Accepted Answer · answered Apr 11 '12 at 13:20

1

You are missing the password in the function. Also, the function call is wrong. Do it like this:

$_db_connect = mysql_connect("localhost", "root", "password");

where, password is the password for your root account. It might be different.

answered Apr 11 '12 at 13:20

hjpotter92

78,589
36
144
183

I have tried this, as I say in my original post. Also, my root account has no password. – kingkong Apr 11 '12 at 13:21
But the error statement states: `'*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B'` as your root password(obviously encrypted). – hjpotter92 Apr 11 '12 at 13:22

score 1 · Answer 4 · answered Apr 11 '12 at 13:21

1

pass the password, as the third parameter

$_db_connect = mysql_connect("localhost", "root", "password");

answered Apr 11 '12 at 13:21

Nicola Peluchetti

76,206
31
145
192

score 1 · Answer 5 · answered Apr 11 '12 at 13:22

1

first param in mysql_connect function is db host and you need to use 3 params - to use password.

so use this syntax:

$db = mysql_connect('localhost', 'mysql_user', 'mysql_password');

answered Apr 11 '12 at 13:22

xholicka

173
6

mysql_connect() always denies access

5 Answers5