root@test-2:/usr/local# mysql -u root -H 192.168.x.xxx -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

closed as off-topic by Ward, Matthew Ife, Jenny D, HBruijn, Cristian Ciupitu Jul 6 '14 at 14:27

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions must demonstrate a minimal understanding of the problem being solved. Try including attempted solutions, why they didn't work, and the expected results. See How can I ask better questions on Server Fault? for further guidance." – Jenny D, HBruijn
If this question can be reworded to fit the rules in the help center, please edit the question.


-H is an alias for --html, which will

Produce HTML output.

You're looking for -h or --host=.

  • yes .. it's silly mistake Thanks a lot ..Yørn – sivashanmugam May 28 '14 at 13:48
  • 1
    Team ,please consider the question before making into negative [-] marks – sivashanmugam May 28 '14 at 13:49

consider using following:

[alexus@wcmisdlin02 ~]$ cat ~/.my.cnf 
[alexus@wcmisdlin02 ~]$ 

you can include host=fqdn as well.

Not the answer you're looking for? Browse other questions tagged or ask your own question.