Hi guyz,
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:
mysql> GRANT ALL ON mydb.* TO 'user'@'123.123.123.123' IDENTIFIED BY 'password';
Query was ok.
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:
c:\mysql\bin\mysql -u user -p -h 123.123.123.123
I got this error:
ERROR 1045 (2800): Access denied for user ‘user’@‘123.123.123.123’ (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.
