It always be access denied 'root'@'localhost'

[xander_tan]

My PHP script always return me access denied 'root'@'localhost'.

No matter how I put in the php script.

 

I can use mysql from the shell but not from PHP.

It just does not make any sense...

 

I tried:

- mysql_connect('localhost','root','rootpass');

- mysql_connect('localhost','admin','adminpass'); (after I add in this account)

- I change my /etc/my.cnf under mysqld to OLD_PASSWORD, change all the password

<and whatsoever>

 

it still gives me access denied 'root'@'localhost' (password: NO), no matter what the user and password I put in.

 

Anyone knows how to fix this?

[eddedwards]

try mysql_connect('localhost','root', PASSWORD('rootpass')); i think it encondes it. i could be wrong though.

[mattclements]

if not, your mysql user "root" may only be accessable from "localhost" rather than a PHP Script etc.. I can take a look if you need it...

 

If not check the root user can be used by "ANY HOST"

 

Let me know,

Matt

[rajivgonsalves]

default password of mysql is null if unless you specified other so your code should be

 

mysql_connect('localhost','root','');