List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 29 2002 7:22pm
Subject:Re: AW: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me
getting started
View as plain text  
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

Thread
Re: AW: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help megetting startedPaul DuBois29 Jan
Re: AW: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help megetting startedPaul DuBois30 Jan
  • Re: AW: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me getting startedHelmuth Lutz1 Feb