MySQL5 won't install/start

[Ryan Schmidt]

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