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.
Quite the interest for my issue, yet no replies Hehe that's okay, hopefully, someone will eventually tag along with the right answers!
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!
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.
ok, i think i made it. some help for those others: http://kb.parallels.com/en/1134 http://trak-community.org/index.php/wiki/Connect_Windows_Virtual_Machine_to_Host_Mac_MySQL_Server after that, you'll probably need the mysql connector.
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
