New answers tagged mac-os-x
I'm having the exact same problem when running MySQL as a service. I also noticed that if I start the server manually in the terminal with sudo mysqld_safe & MySQL runs in port 3306 as expected. So if it's crucial to get it running in that port, I'd recommend starting the server like that. I still haven't found any reason for the service to have that ...
Try ::1 and localhost instead of 127.0.0.1.
I had this same problem too, and changing the port in /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist fixed the issue, with no side effects so far. Changing the port in my.cnf didn't work. It makes the Preference Pane say that MySQL is not running, and makes it impossible to start from the Preference Pane.
Top 50 recent answers are included