Thanks Rory, I did go through (as per the manual)and set the permissions
shell> groupadd mysql shell> useradd -g mysql mysql shell> cd /usr/local shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell> ln -s full-path-to-mysql-VERSION-OS mysql shell> cd mysql shell> scripts/mysql_install_db --user=mysql shell> chown -R root . shell> chown -R mysql data shell> chgrp -R mysql . shell> bin/mysqld_safe --user=mysql & As well, afterward I checked the permissions on the directories and the data directory seems to have the right permissions. i.e. 'mysql' owns the data directory. Checking the 'bin' directory, all the files are group 'mysql' and all have 'rx' for group. This seems to make sense to me. Cheers Cam -----Original Message----- From: Rory McKinley [mailto:[EMAIL PROTECTED] Sent: July 28, 2004 11:55 AM To: [EMAIL PROTECTED] Cc: Cam Subject: Re: mysql_safe just ends Cam wrote: >So I'm a little confused here > >I've installed mysql-standard-4.0.20-pc-linux-i686.tar to >/usr/local/mysql and then ran the scripts/mysql_install_db with >seemingly no errors. >After reading section 5.1 'the MySQL Server and Server Startup Scripts' >I figured that > >cd /usr/local/mysql >bin/mysqld_safe & > >would simply work but no. I get > >[EMAIL PROTECTED] mysql]# bin/mysqld_safe & >[2] 11616 >[EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from >/var/lib/mysql >040728 10:50:16 mysqld ended >[2]+ Done bin/mysqld_safe >[EMAIL PROTECTED] mysql]# > > <snip> I don't know why, but something at the back of my mind is shouting 'Check Permissions', I think you need to check the OS file permissions for the folder in which you have stored the data for mySql. If memory serves, part of the installation process is to change file permissions and /or groups and ownership - methinks this is where your problem lies.... -- Rory McKinley Nebula Solutions +27 21 555 3227 - office +27 21 551 0676 - fax +27 82 857 2391 - mobile www.nebula.co.za ==================== This e-mail is intended only for the person to whom it is addressed and may contain confidential information which may be legally privileged. Nebula Solutions accepts no liability for any loss, expense or damage arising from this e-mail and/or any attachments. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
