At 20:14 +0100 1/29/02, Lutz, Helmuth wrote: >Paul, >I do not know why, but it did not work. Please see yourself: >This lines I could not copy and paste because the results are on a not >connected Mac and this is a windows machine. So I had to write it by hand >(- but looked 2 times at the text) > >Your example: >>% ps ax | grep mysql >> 251 ?? S 0:00.08 sh /usr/local/mysql/bin/safe_mysqld >> 287 ?? S 0:01.65 /usr/local/mysql/libexec/mysqld >> >>Figure out where mysqld is installed (for me, that's >>/usr/local/mysql/libexec/mysqld) and invoke it like this (either as >>root or as the login account used to run the server): >> >>% /usr/local/mysql/libexec/mysqld -Sg > >---> mysqld is listed in /usr/local/mysql/bin. > >My results: >----------- >[localhost:/usr/local/mysql] hlutz% ps ax | grep mysql > 255 ?? S 0:00.17 sh ./bin/safe_mysqld > 298 ?? S 0:01.09 /usr/local/mysql/bin/mysqld > 358 ?? S+ 0:00.01 grep mysql >---> I ran it a second time to explore: >[localhost:/usr/local/mysql] hlutz% ps ax | grep mysql > 255 ?? S 0:00.17 sh ./bin/safe_mysqld > 298 ?? S 0:01.09 /usr/local/mysql/bin/mysqld > 358 ?? R+ 0:00.00 grep mysql
Looks okay. >[localhost:/usr/local/mysql] hlutz% su root >Password: >[localhost:/usr/local/mysql] root# kill -9 255 298 >[localhost:/usr/local/mysql] root# cd >----> I do not know why I changed the directory >----> but I think it should not be the problem Right, it shouldn't. >[localhost:~] root# /usr/local/mysql/bin/mysqld -Sg >Fatal error: Please read "security" section of the manual to find out how >to run mysqld as root! >020129 18:45:15 Aborting Okay, then try adding the --user=mysql option to the command. > >020129 18:45:15 /usr/local/mysql/bin/mysqld: Shutdown Complete > >----> I changed the user and ran it a second time to explore: >[localhost:~] root# su hlutz >[localhost:~] hlutz% cd /usr/local/mysql >[localhost:/usr/local/mysql] hlutz% /usr/local/mysql/bin/mysqld -Sg >/usr/local/mysql/bin/mysqld: Can't change dir to >'/usr/local/mysql-3.23.46/data/' (Errcode: 13) >----> I think it was wrong when I spoke of 3.23.47 in the mail-reference >line!!! >020129 18:47:31 Aborting > >020129 18:47:31 /usr/local/mysql/bin/mysqld: Shutdown Complete > >[localhost:/usr/local/mysql] hlutz% >----> stopped here because it seems not to work properly. >----------- > >Can there be anything with the user "mysql" and the group "mysql" which I >created with the NetInfo Manager? I can not login within the terminal as >user mysql (% su mysql). A password is wanted, but I did not set one on OSX >level. Actually, you could do that. First su to root, then as root su to mysql. When you're root you can su to anyone. > >Can there be anything with accessrights because all files in >/usr/local/mysql belong to the group mysql and user mysql and not partly to >root (and wheel before - whatever user wheel is). That just indicates that you want to run the server as the mysql user by adding --user=mysql to the mysqld -Sg command. > >Thanks, Helmuth --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
