problem with mysql 5 install and configuration

[Bradley Giesbrecht]

On Jan 8, 2012, at 11:54 AM, Érico wrote:

> ==================
> 
> when using "sudo bash" and starting it , I see these processes up : 
> 
> bash-3.2# ps aux | grep mysql
> root       403   0.3  0.0  2425524    172 s000  R+    5:52PM   0:00.00 grep mysql
> _mysql     378   0.0  0.4  2511112  17844 s000  S     5:42PM   0:00.24 /opt/local/libexec/mysqld --basedir=/opt/local --datadir=/opt/local/var/db/mysql5 --user=_mysql --log-error=/opt/local/var/db/mysql5/Ericos-MacBook-Pro.local.err --pid-file=/opt/local/var/db/mysql5/Ericos-MacBook-Pro.local.pid
> root       334   0.0  0.0  2435544    864 s000  S     5:42PM   0:00.03 /bin/sh /opt/local/bin/mysqld_safe5
> bash-3.2# 
> 
> I have fully removed the primary symb links, sockets file and content ... and I have removed the files from start up also : 
> bash-3.2# ls -la /Library/LaunchDaemons
> total 0
> drwxr-xr-x   2 root  wheel    68 Jan  8 17:19 .
> drwxrwxr-t+ 60 root  admin  2040 Dec  3 20:17 ..

Why are you removing files that are provided by ports you want installed?
The mysql5 and mysql5-server ports do not require any additional symlinks/files  nor the removal of any files installed the ports install.

> So , is it mandatory to start it after "sudo bash" ... is there anything I can do with my id so it can start mysql ?

$ sudo port deactivate mysql5-server mysql5
$ sudo port activate mysql5 mysql5-server
$ sudo port load mysql5-server
$ mysql5 -uroot -p



Regards,
Bradley Giesbrecht (pixilla)