Looking link to learn about using mysql Terminal commands. I have MAMP (LAMP for macintosh) installed in my computer. I'm trying to connect to a remote mysql database using Terminal application on my computer but I get an error message.
What I do is:
- Open Terminal app
- Go to mysql installation folder with this line:
- Then I try to connect to remote database with this line:
mysql -h 22.214.171.124 -u user_name -p database_name
But I get this error message:
'ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
-h 126.96.36.199 -u user_name -p database_name' at line 1
Message says I have a error in my SQL syntax but I see no errors in it. What am I missing here?