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
