MySQL-DB Connection with MAC!

Question

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 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!

Please add more info. Where is the server running, what host name are you using... — Pekka
– Pekka, Commented Feb 28, 2011 at 11:08
add more info.. How are you trying to connect? What commands are you using? — rdp
– rdp, Commented Feb 28, 2011 at 11:12

Steffen · Accepted Answer · 2011-02-28 11:22:12Z

1

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.

answered Feb 28, 2011 at 11:22

Steffen

111 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

Cem Güler · Accepted Answer · 2011-02-28 16:59:54Z

1

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.

answered Feb 28, 2011 at 16:59

Cem Güler

63513 silver badges24 bronze badges

6 Comments

Sunnygurke Over a year ago

I tried it, but now i get the error message "Lost connection to MySQL server at ‘reading initial communication packet’, system error: 61" :(

Cem Güler Over a year ago

There is a line in my.cnf : bind-address IP_ADDRESS what is the value in your config? If it reads 127.0.0.1, then comment the line out and restart mysql. Also please note that you need to add appropriate firewall rules to permit mysql traffic.

Sunnygurke Over a year ago

restart the mysql server? EDIT: in the my.cnf (in the xampp folder [xampp is also installed on the mac], in the /etc/ folder was't a my.cnf) was no bind-address line.

Cem Güler Over a year ago

if you change config, yes you should restart the mysql server instance to apply changes.

Cem Güler Over a year ago

Can you access mysql on 2008? Try with telnet 2008_ip 3306

|

Collectives™ on Stack Overflow

MySQL-DB Connection with MAC!

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related