MYSQL+Unable to connect from PHP

Question

I am using nginx, PHP and MYSQL. I setup a database and a user and I can select it via the MySQL CLI client:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 52
Server version: 5.1.61-0+squeeze1 (Debian)
mysql> use cinema
Database changed

However, it seems not to work when I try to connect to it from my php script:

<?php
$link = mysql_connect('localhost', 'root', '************');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

The output is:

Could not connect: Access denied for user 'root'@'localhost' `(using password: NO)`

(**** is of course my real password...).

Does anyone have an idea why it says (using password: NO) although I clearly use one in my code?

Sidenote: mysql is not recommended anymore. Use MySQLi, or PDO_MySQL instead. — KingCrunch
– KingCrunch, Commented Apr 28, 2012 at 21:50
See my post: Server version: 5.1.61-0+squeeze1 (Debian) - let me know if u need to know more details! — r0skar
– r0skar, Commented Apr 28, 2012 at 21:51
you can access phpmyadmin by this user and password? you run mysql_secure_install? — Vahid CH
– Vahid CH, Commented Apr 28, 2012 at 21:52

ilanco · Accepted Answer · 2012-04-28 21:50:59Z

4

It could be that mysql safe mode is on, and then the password field is ignored.

answered Apr 28, 2012 at 21:50

ilanco

10.1k4 gold badges34 silver badges37 bronze badges

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

1 Comment

r0skar Over a year ago

Simply great! I wonder why it was On in the first place, but nevermind!

Collectives™ on Stack Overflow

MYSQL+Unable to connect from PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related