Not able to access mysql using script

Question

I am getting the following error when trying to access a MySQL table :

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

But, I can login with root when using mysql in the command line.

could you post your PHP connection script? - and you should probably be using a password on your database — Halfpint, Dec 05 '14 at 22:28

score 0 · Answer 1 · answered Dec 05 '14 at 22:31

That is the normal behaviour. You set a root password for your database so from now on you can't access it without password. That is why it reports:

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

Obviously when you give the password with the -p switch you succeed.

score -1 · Answer 2 · answered Dec 05 '14 at 22:37

-1

answered Dec 05 '14 at 22:37

Marco

2 Answers2