MySQL5 won't install/start

[Ryan Schmidt]

On Jul 5, 2007, at 16:18, Ryan Schmidt wrote:

> 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.

Ok, it should be fixed:

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

Please "sudo port sync" and try again. It may take up to 12 hours for  
the change to become available.