I'm having trouble connecting to a local server hosted on a MacBook/MAMP. My .NET application (running on a Windows computer) smoothly connects to another Windows machine (MySQL server) with the same connection string "server=[computer's name]; user id=xxxx; password=xxxx; database=xxxx" but when I use this MacBook's name, I get the following error:
"Unable to connect to any of the specified MySQL hosts"
Note: File Sharing is turned on
Please help.
For those who might experience the same issue, the problem was that my MacBook wasn't visible to Windows machines. Go to System Preferences > Sharing > File Sharing > Options and check your Account and Share files and folders using SMB.