[PLUG] Re: Help needed with MySql database

["Michael F. Robbins" <mike@gamerack.com>]

As was said before, MySQLd typically runs as user and group "mysql".  Make
sure that they exist:
groupadd mysql
useradd -g mysql mysql

Also, according to the MySQL manual(
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html ),
it is still necessary to execute the mysql_install_db script after RPM
installation.  This should be found in some kind of scripts directory.

Here's another key to the equation:  Make sure that the MySQL data files are
owned by that user and group.  From the manual, again:
chown -R root  /usr/local/mysql
chown -R mysql /usr/local/mysql/var
chgrp -R mysql /usr/local/mysql

I'm not sure what directory it puts the stuff in on the RPM, but probably
the key files are the var files (in /var/lib/mysql).  For possibly more
descriptive error messages, look in /var/lib/mysql for any log files.

Michael F. Robbins
mike@gamerack.com




______________________________________________________________________
Philadelphia Linux Users Group       -      http://www.phillylinux.org
Announcements-http://lists.phillylinux.org/mail/listinfo/plug-announce
General Discussion  -  http://lists.phillylinux.org/mail/listinfo/plug