Cameron, Take a look in the data directory for a .err file. This error log will almost certainly contain the reason why Mysql failed to load and will make fixing it much easier.
Richard On Wed, 28 Jul 2004 13:15:34 -0600, Cameron Roe <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
