Can't remote access MySQL server running on Mac OS X
13
votes
4
answers
52490
views
I have a MySQL server running on my work computer, which runs Mac OS X Maverick. I want to access it from home computer, which also has Mac OS Maverick.
From terminal, if in 1 tab, I ssh into my work computer and just let the ssh session sit there without being idle, then on another tab, I can access MySQL server.
However, without the ssh session running, I will get following error
> **ERROR 2003 (HY000):** Can't connect to MySQL server on 'SERVER_IP_ADDRESS' (60)
I've tried to modify
my.cnf
file on the server by commenting out bind-address or assigning it to 0.0.0.0
but it doesn't work.
Why is it like that? How can I configure the server so that it allows remote access without having to run ssh on the client? Can someone please help?
Asked by chepukha
(231 rep)
Jan 2, 2014, 05:10 AM
Last activity: Aug 10, 2022, 04:24 PM
Last activity: Aug 10, 2022, 04:24 PM