On Apr 25, 2007, at 18:47, Thoraval Yvon wrote:
if i launch mysql5 that way :
$ sudo /opt/local/lib/mysql5/bin/mysqld_safe &
You don't say what OS you're using, but if you're using Mac OS X 10.4 or later, the recommended way to start mysqld now, and at every system startup from now on, is: sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist The recommended way to stop mysqld now, and prevent it from starting up automatically, is: sudo launchctl unload -w /Library/LaunchDaemons/ org.macports.mysql5.plist If you're using Mac OS X 10.3 or earlier, then a startup item is provided for you. All of the above assumes you have installed the mysql5 port with the +server variant. If you did not do that, you should uninstall mysql5 and reinstall it with that variant.
i get :
[1] 26609 ~%> Starting mysqld daemon with databases from /opt/local/var/db/ mysql5 STOPPING server from pid file /opt/local/var/db/mysql5/www.une- bevue.fr.pid 070425 22:57:29 mysqld ended -----------------************
[1] + done sudo /opt/local/lib/mysql5/bin/mysqld_safe
then the daemon is launched and ends afterwards.
Have you checked the logfile to see what the problem is? The MySQL logs are usually pretty helpful. I believe they are stored by default in the same directory as the PID file, /opt/local/var/db/mysql5.
the file perms are :
~/Sites%> ls -al /opt/local/lib/mysql5/bin <snip /> -rwxr-xr-x 2 root admin 1226368 Apr 23 20:33 my_print_defaults
is root:admin correct
or does i have to create a group:owner mysql:mysql and change it accordingly ???
These are just the binaries. root:admin is perfectly normal and fine for these files. The directory /opt/local/var/db/mysql5 and its contents, however, should be owned by mysql:mysql. You do not need to create this user/ group; Mac OS X already ships with these users. As far as I remember, the directory is also already set to that user/group, but you could double-check it if you like.