Sample Header Ad - 728x90

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