Could MAMP be blocking the MySQL port?

I have a Mac Mini with 10.6.3 which runs MAMP.

If I do a port scan on the Mini, port 3306 is responding.
If I do a port scan from any other computer on my LAN, port 3306 appears Closed.

I have a SonicWall 2040.  I have set up the Mini to be a server with port 3306 open.  But the SonicWall isn't supposed to be blocking any local traffic.

The Mac OS X Firewall is definitely off.

I was wondering if there's a setting in MAMP to shut it off, or whether the SonicWall has a configuration problem.


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
In MAMP, what port did you set MySQL to run on?  The MAMP default is 8889, not 3306.
computerlarryAuthor Commented:
I have it set to 3306.  Just checked again.

If I use the network utility and do a portscan, 3306 shows up when I scan localhost.
If I do a portscan on the local IP address, 3306 doesn't show up.

If I scan the public address, there is no loop-back, and no ports show up.

I checked the SonicWall, and removed every setting for the machine.
3306 doesn't show up in the portscan.

I changed the MySQL port in MAMP, but it still doesn't show up.

I'll look at the logs, maybe there's something there.  I'll search for 3306

I'm going to check all the startup settings.  I'm still wondering about MySQL

Dave BaldwinFixer of ProblemsCommented:
I'm wondering if MySQL doesn't listen on the public IP address if it doesn't have a user that is allowed access from and external host or IP address.  I just crashed phpmyadmin on a WAMP installation by giving 'root' a password.  I'll fix that later, it's probably in the config file.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
computerlarryAuthor Commented:
There appears to be a problem with the MAMP product.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Apache Web Server

From novice to tech pro — start learning today.