mysql start

[Mark Duling]

Pascal Robert <probert at os.ca> on Wednesday, February 14, 2007 at 6:57 AM
-0800 wrote:
>Le 07-01-07 à 13:55, Ryan Schmidt a écrit :
>
>> On Jan 7, 2007, at 09:14, eoghan wrote:
>>
>>> Im trying to start mysql (version 5.0.27) using:
>>> $sudo /opt/local/libexec/mysqld --user=mysql
>>> Im getting the follwing error:
>>> 070107 15:11:45 [Warning] Can't create test file /opt/local/var/db/ 
>>> mysql5/eoghan-js-Computer.lower-test
>>> 070107 15:11:45 [Warning] Can't create test file /opt/local/var/db/ 
>>> mysql5/eoghan-js-Computer.lower-test
>>> /opt/local/libexec/mysqld: Can't change dir to '/opt/local/var/db/ 
>>> mysql5/' (Errcode: 2)
>>> 070107 15:11:45 [ERROR] Aborting
>>>
>>> 070107 15:11:45 [Note] /opt/local/libexec/mysqld: Shutdown complete
>>>
>>> Could someone help me on this please?
>>
>> It sounds like the directory /opt/local/var/db/mysql5 does not  
>> exist. Did you set up the initial databases? It sounds like you  
>> didn't.
>
>BTW, I just installed Cacti, who install MySQL 5, from the ports and  
>"mysql_install_db" have some permissions problems since the mysql  
>user can't write to /opt/local/var/db/.  I have to change the  
>permissions to get it to work.

Hmmn.  'sudo -u mysql mysql_install_db5' to setup mysql5 has always worked
for me and I just installed mysql5 on a new box and it worked.  What is
the permissions and owner on your ${prefix}/var directory? Or perhaps
/opt/local/var/db been installed with mysql_install_db before with
permissions other than mysql:mysql?

Mark