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'@'18.104.22.168' 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 22.214.171.124
ERROR 1045 (2800): Access denied for user 'user'@'126.96.36.199' (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.