Accessing MySQL@Mac from Windows

E

eklundchristopher

Bit poster
Hey fellas!

I'm having a slight issue accessing the MySQL service running on my Mac OS X using MAMP PRO on my Windows 7 virtual host. I can access the website without any problems whatsoever using my local IP. However, I am unable to access the MySQL (not on the website itself, but through an external program. I have searched for the past three days and I finally had to give it a rest and simply ask due to lack of results.

I even tried removing the ip bind/network lock from my MAMP PRO settings. With no luck.

I found a topic here at Parallels forum from '07 about the same issue that I have. He or she did not receive any answers though. Unfortunately. So I am hoping you guys might be able to help me out.

Appreciate any effort/attempt to help me, successful or not!
Thank you,
Chris.
 
Last edited:
Would it be wrong of me to refuse to think that no one has actually had a similar problem since '07? Apparently, the odds are against me seeing as there are 800+ views already! :P
 
If your virtual machine can ping the Mac then it should be able to access MySQL. Have you tried both Bridged and Shared Networking? I think the Mac will have the same IP address from the virtual machine in either case.
 
Late but here is the solution

In order to connect mysql from your WINDOWS VM :

1°) Uncheck the checkbox 'Allow local access only" in the mysql tab if you are using MAMP PRO or comment the following line in my.cnf : skip-networking
2°) edit the my.cnf template (file/edit template) and replace bind-address = 127.0.0.1 with bind-address = 0.0.0.0 (or your current IP) cf : http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_bind-address
3°) check if the use you want to connect with is allowed from anywhere (not only localhost)

If like me you want to use an ODBC driver to import database to sqlServer or access, you have to use 32 bits driver with 32 bits application, or it won't work.

I know it one year late but if someone need this (like me few hours ago) ....
 
Hallo,

die Lösung abe ich gesucht. muss hier mit MAMP PRO gearbeitet werden oder reicht MAMP aus. ich hatte hier XAMPP installiert
 
exactly the same issue!

As the title says, I'm really having exactly the same issue.

I am not running MAMP, since i only need a mysql-database.

does the solution from 9H27PM still apply?

i am running a mysql database on mac os and need to connect from excel, running on windows in the VM.
 
You need to change apache httpd file a little bit ..

ServerName localhost

cnenge to your webserver IP address like..

ServerName 192.168.0.xx

probability you will get the result.

__________
Parallel Universe
text-smiley.png
 
You must log in or register to reply here.
Back
Top