Hi David,
Let me add fink-users mailing list to Cc.

David wrote:
> I was trying to run MySQL and I received the following error (I set
> everything up with Fink and /sw/bin/ is owned by root/admin):

I don't think the ownership and the permission of /sw/bin has to do with
your problem, but you should check those of /sw/var/mysql, where mysql's
data and logs should be stored. By default, it is owned by user 'mysql'
and group 'mysql', with mode of 700.

> ~ $ mysqld_safe --user=root &
> [1] 1520

It looks like you are running mysqld_safe with your normal account.
Normally, you may want to do it with root or mysql user, e.g. using
"sudo" or "sudo -u mysql". If you don't want to be root nor mysql user,
consider creating your own data directory and configuration file, and
specifying --defaults-file=/path/to/your/my.cnf to your command line.

For example:
$ sudo mysqld_safe &
or:
$ /sw/bin/mysqld_safe --defaults-file=~/.my.cnf

For more information, see:
http://dev.mysql.com/doc/refman/5.1/en/starting-server.html

To be Fink-specific, you can also use 'daemonic' to enable automatic
startup of mysqld ( needs root access ).

To enable daemonic, just hit:
$ sudo daemonic enable mysql

For more about daemonic, visit http://daemonic.sourceforge.net/ .
( Well, I can't point more verbose guide, but daemonic is enough simple. )

> ~ $ Starting mysqld daemon with databases from
> /sw/var/mysql
> /sw/bin/mysqld_safe: line 382:
> /sw/var/mysql/pal-174-168.itap.purdue.edu.err: Permission denied
> rm: /sw/var/mysql/pal-174-168.itap.purdue.edu.pid: Permission denied
> /sw/bin/mysqld_safe: line 388:
> /sw/var/mysql/pal-174-168.itap.purdue.edu.err: Permission denied
> STOPPING server from pid file /sw/var/mysql/pal-174-168.itap.purdue.edu.pid
> tee: /sw/var/mysql/pal-174-168.itap.purdue.edu.err: Permission denied
> 070522 10:49:12  mysqld ended
> tee: /sw/var/mysql/pal-174-168.itap.purdue.edu.err: Permission denied
>
>
> [1]+  Exit 1                  mysqld_safe --user=root
>
> --
>
> Package manager version: 0.27.1
>
> Distribution version: 0.8.1.rsync i386
>
> Mac OS X version: 10.4.9
>
> Xcode version: 2.4.1
>
> gcc version: 4.0.1 (Apple Computer, Inc. build 5367)
>
> make version: 3.80
>
> Feedback Courtesy of FinkCommander
>
>
> Any idea what I can do?
> ==============
> Thank you,

Hope it helps,

-- 
ASARI Takashi @ Todai Fink Team
http://fink.sodan.ecc.u-tokyo.ac.jp/

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Fink-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fink-users

Reply via email to