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.


_______________________________________________
macports-users mailing list
[email protected]
http://lists.macosforge.org/mailman/listinfo/macports-users

Reply via email to