无法从Mac Lion连接到远程MySQL [英] Cannot connect to remote mysql from Mac lion

问题描述

我是Mac的新手，正在尝试获取开发人员设置以在本地开发php网站.他开发的站点具有mysql后端，并且位于远程机器上.我们已经安装了xampp并可以正常工作，他可以​​从网站连接到本地mysql盒，但不能连接到远程盒.他使用的是与Windows系统完全相同的连接信息.我没有任何问题.还将mysql服务器设置为接受所有用户(我们当前使用root用户)，而不管主机名如何.

I'm a mac novice and trying to get a developer setup to develop php sites locally. The sites he develops have a mysql backend and that is on a remote box. We got xampp installed and working, he can connect from the website to the local mysql box but he cannot connect to the remote box. He is using the exact same connection info I am using from my windows system. I do not have any issues. Also the mysql server is setup to accept all users (we are currently using root) regardless of hostname.

我搜索了他的系统，但找不到mysql.sock文件.我不知道这是做什么的，但是在谷歌上搜索了一些提到的文章.

I searched his system and I could not find a mysql.sock file. I do not know what this does, but googled some articles that mentioned.

请帮助.

推荐答案

尝试从主机Telnet到服务器，看看是否收到响应.

Try Telnetting to the server from your host and see if you get a response.

telnet host 3306

如果这不起作用，则您的Mac上可能有一些本地防火墙阻止了连接.另外，您没有提到的一件事是您可以通过Windows计算机而不是Mac进行连接...它们是否在同一网络上?如果它们位于不同的网络或不同的位置，则可能表明存在本地网络问题.

If that doesn't work, you probably have some local firewall on your mac that is blocking the connection. Also, one thing you don't mention is that you can connect from a windows computer and not a mac... are they on the same network? If they're on different networks or in different places, that could indicate a local network issue.

这绝对不是MySQL的问题，而是Mac本身的问题.

This is definitely not an issue with mysql, but with something on the Mac itself.

这篇关于无法从Mac Lion连接到远程MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！