Change port # for mysql on mac

Looks like the new installers are adding the port as 3307

To change that follow below steps

sudo vi /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
change 3307 from this line <string>--port=3307</string> to 3306

On OSX you can create /etc/my.cnf if it does not exist. You can base it on samples found in /usr/local/mysql/support-files. Don't forget to restart MySQL for your my.cnf to take effect.


By default, the install doesn't create a my.cnf file on Snow Leopard. You can create one yourself under /etc or you can copy one from /usr/local/mysql/support-files/

Then run : sudo cp my-huge.cnf /etc/my.cnf

Check out the explanation here

Tags:

Mysql