mysql start

[Pascal Robert]

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.