anyone running MySQL Server?

[david]

I am only able to run the server deamon as:  safe_mysqld -u root
which according to their doc's is not desirable:

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database
_Administration.html#Option_files

I would really like to connect as below: i have add mysql as a user in /etc/passwd.

[davidwri@localhost davidwri]$ safe_mysqld --user=mysql &
[1] 2281
[davidwri@localhost davidwri]$ Starting mysqld daemon with databases from 
/var/lib/mysql
/usr/bin/safe_mysqld: /var/log/mysqld.log: Permission denied
/usr/bin/safe_mysqld: /var/log/mysqld.log: Permission denied
tee: /var/log/mysqld.log: Permission denied
020807 02:16:30  mysqld ended
tee: /var/log/mysqld.log: Permission denied

[1]+  Exit 1                  safe_mysqld --user=mysql


Below is my /var/log/mysqld.log file, I have tried 4 configurations and none 
of them seem to do the trick: 
chgrp mysql /var/log/mysqld.log
chown mysql /var/log/mysqld.log
chgrp root /var/log/mysqld.log
chown root /var/log/mysqld.log


what do some people's /var/log/mysqld.log permissions look like?
[davidwri@localhost davidwri]$ ls -l /var/log/mysqld.log
-rw-rw-r--    1 mysql    mysql        2598 Aug  7 02:10 /var/log/mysqld.log
[davidwri@localhost davidwri]$


I would seem that if permission is denied for:
/usr/bin/safe_mysqld: /var/log/mysqld.log: Permission denied
tee: /var/log/mysqld.log: Permission denied

that /var/log/mysqld.log should look like:
[davidwri@localhost davidwri]$ ls -l /var/log/mysqld.log
-rw-rw-r--    1 root    mysql        2598 Aug  7 02:10 /var/log/mysqld.log

Any other ideas? thanks in advance.




-- 
pod2text /usr/lib/perl5/5.6.0/CGI.pm | perl -pe '($_)=/"(mag\w*\s\w*)"/'

david@davidwrightmusic.com
http://www.davidwrightmusic.com
http://www.mp3.com/dw&d
http://www.tonos.com/davidwright 
http://www.guitar.com/artists/davidwright
http://artists2.iuma.com/IUMA/Bands/DavidWright/
http://www.mp3.com/cachet