Running MacPorts MySql on a different port

[Ryan Schmidt]

On May 21, 2008, at 18:20, William Siegrist wrote:

> On May 21, 2008, at 4:14 PM, Thomas Hagedorn wrote:
>
>> 1.  How do I configure the launchd or org.macports.mysql5.plist  
>> files so
>> that the port 3307 is chosen when mysql starts automatically at
>> startup?  The problem seems to be passing --port=3307 to the
>> mysql.server program doesn't work.
>>
>
> In your my.cnf file, you can specify port=3307 in the [mysqld]  
> section.
>
> http://dev.mysql.com/doc/refman/5.0/en/option-files.html

Specifically, use the file /opt/local/etc/mysql5/my.cnf, because the  
MacPorts mysql5 will look at that one, and your MySQL binary will not.