MySQL5 won't install/start

[Ryan Schmidt]

On Jul 5, 2007, at 15:34, Ryan Schmidt wrote:

> On Jul 5, 2007, at 13:50, Samuel V. Green III wrote:
>
>> On Jul 5, 2007, at 4:02 AM, Peter Farsinsen wrote:
>>
>>> I'm trying to install Apache2, MySQL5 & PHP5 on a clean OSX/ 
>>> MacPorts installation.
>>>
>>> Before reinstalling OSX and MacPorts I had this setup running  
>>> perfectly.
>>>
>>> The Apache2 installation went fine, but MySQL just wont work.
>>>
>>> "sudo install mysql5 +server"
>>>
>>> Works fine, but "sudo -u mysql mysql_install_db5" (at the end of  
>>> the installation) returns "sudo: mysql_install_db5: command not  
>>> found"
>>>
>>> "/opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper  
>>> start"
>>>
>>> Dosen't work either. It returns:
>>>
>>> "Starting MySQL/opt/local/share/mysql5/mysql/mysql.server: line  
>>> 159: kill: (395) - No such process
>>>  ERROR!"
>>>
>>> Is this a known problem? Is there a solution?
>>>
>>> If any further details about my setup or the MacPorts is needed  
>>> please let me know and I'll try to provide them.
>>
>> I believe I came across the solution by accident as I had the
>> same issues trying to start:
>>
>> After starting:
>>
>> Try:    sudo -u mysql5 mysql_install_db5
>>
>> All mysql commands must be in the form of "mysql5".
>> This seems to work for me.
>
> Surely not.
>
> "sudo -u mysql" means "do this command as the user 'mysql'" (rather  
> than as the user "root", which is what "sudo" would otherwise do).  
> The user is called "mysql", not "mysql5", so "sudo -u mysql5" is  
> surely wrong.
>
> Peter, mysql_install_db5 is located in /opt/local/bin so the  
> command should have been found if you have set up your PATH  
> environment variable correctly. Have you? The instructions are here:
>
> http://trac.macosforge.org/projects/macports/wiki/ 
> InstallingMacPorts#a3.Settheshellenvironment

On second thought: it looks like "someone" broke mysql5 on Tuesday. :)

http://trac.macosforge.org/projects/macports/changeset/26683

I'll test a fix and commit it in a moment; I'll let you know.