> Also, if I (mysql -u root -p root) from localhost, then it prompts me
> for a password. I enter password 'root' and then I get this error:
That's what's supposed to happen:
You use
~> mysql -u username -p database_name
Then you are prompted for the password for root and it will start in
data
I can connect from SQLYog,MySqlCC,jdbc from remote with no problem.
However, when I try to connect(mysql -u root) from localhost, then I
get access denied. Checked the user table and root can connect from
anywhere(%).
Also, if I (mysql -u root -p root) from localhost, then it prompts me
for a pas