开发者

MySQL-DB Connection with MAC!

开发者 https://www.devze.com 2023-02-13 17:03 出处:网络
When i try to connect to my MYSQL-DB from a Windows-PC everything works, but when i try it from a Mac (I tried it with 2 macs) i get the errormessage \"Can\'t get hostname\". I\'m using开发者_C百科 My

When i try to connect to my MYSQL-DB from a Windows-PC everything works, but when i try it from a Mac (I tried it with 2 macs) i get the errormessage "Can't get hostname". I'm using开发者_C百科 MySQL-Workbench 5.2.31. The DB is running on Windows Server 2008 R2.

EDIT: More Info:

  • The MYSQL Server is running on a Windows Server 2008 R2 machine.
  • The Server works, because i can connect from a Windows-PC. (The Windows-PC is not the Server)
  • The Port for the MYSQL Server (3306) is definitely open!
  • The Hostname is the DNS-address of the server!

Thanks in advance!


You need to add the ip-adress and a hostname in the hosts-file of the server. The server tries to get a hostname for the ip of the mac, but can't find any. You may turn off this check in the config of your mySQL Server.


Check your dns settings. On mac, open a terminal check if nslookup win2008_dns_address resolves to your ip address. If not, fix your dns settings. Otherwise, again on mac, sudo vi /etc/hosts and append your Win2008 server ip and win2008 hostname there. Correct format would be

IP_ADDRESS    HOSTNAME

save and try.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号