I want to connect to MySQL Server hosted on a Linux Machine from my Windows Machine using Command Prompt with the following command:
prompt>mysql -u root -p -h remote_hostname
Connections, ports, user accounts and credentials are all fine. But it is throwing the below error:
ERROR 1130 (HY000): Host 'my_hostname' is not allowed to connect to this MySQL server
I am wondering is it possible to communicate with Linux Shell from Windows Command Prompt? or is it not at all in the very design of prompt to connect to Linux Shell for any remote operations? Or is it special in case of MySQL.
I observed that I can connect from Linux to Windows but the reverse is not possible when I am trying just like I explained above.
Anybody know the theoretical explanation to this?