problem with mysql 5 install and configuration

[Ryan Schmidt]

On Jan 8, 2012, at 13:54, Érico wrote:

> 6. the problem is my id ... if I try to start with it with this alias in my .profile : 
> alias mysqlstart='sudo /opt/local/bin/mysqld_safe5 &' 

You do not need any such alias. There should be no need to routinely manually start mysqld. Once everything is working, let launchd start it for you ("sudo port load mysql5-server"). Until everything is working, you can manually start mysqld_safe5.


> I run $mysqlstart:
> ericomtx$ mysqlstart 
> [1] 315
> ericomtx$ ps aux | grep mysql
> root       315 100.0  0.0  2436236   1668 s000  R     5:40PM   0:03.51 sudo /opt/local/bin/mysqld_safe5
> ericomtx   317   0.0  0.0  2435120    536 s000  R+    5:40PM   0:00.00 grep mysql

You're supposed to start it as the _mysql user, not as the root user.

sudo -u _mysql mysqld_safe5