I've been googling on this for 2 days already, but still can't figure it out. I want to connect to my remote database server hosted for my website using my local mysql command line client. I want to query records on my tables. Now, i did this:
Query was ok.
mysql> GRANT ALL ON mydb.* TO 'user'@'220.127.116.11' IDENTIFIED BY 'password';
Now, i don't really know if that's the first step. The next thing i did was to connect mysql to my host, i did this:
I got this error:
c:\mysql\bin\mysql -u user -p -h 18.104.22.168
ERROR 1045 (2800): Access denied for user 'user'@'22.214.171.124' (using password: Yes)
Do i have to contact my hosting company with regards to this issue?
Please help me on this. THank you. Sorry for my english.
P.S. : The real thing about this is i'll be going to create a standalone application on my local computer doing queries from my remote database.