On a linux box FC4 & MySQL Ver 14.7 Distrib 4.1.14" , I am using this command line to connect to mysql:
then I am prompted to enter password, it is ok here no problem.
I need to use this command line
mysql -u root -p=passwd
Access denied for user 'root'@'localhost' (using password: YES)
, although the password is correct.
I want this command to be available to be able to connect to my DB remotely using a client like "SQLyog"
How can I enable this command and why it is not working?