Sam: I removed MySQL by removing the directory /etc/local/<mysql-version> & /etc/local/mysql and then re-installing the mysql-4.0.18.tar.gz. I follwed the procedure (as you described) & from mysql documentation & again I can not get mysql auto start.
Do you know which directory/file has mysql error so I can look into it. I am completely burned!! Will start again tomarrow morning if I get few responses. Kirti -----Original Message----- From: Sam [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 6:52 PM To: [EMAIL PROTECTED] Subject: RE: MySQL does not automatically start at BOOT time?? Kirti: I think you already did that as you said in you first msg about you installation steps. > > >>Setup to start MySQL automatically > > >> % cp /usr/local/<mysql Version > No>/mysql.server > > >>/etc/init.d Did you get my prev msg where I suggested to check the previleges on your mysql. Usually I do it this way: 8) Change ownership of binaries to root and ownership of the data directory to the user that you will run mysqld as (in our case mysql): chown -R root . chown -R mysql var chgrp -R mysql . ( this is important too) 9) To start MySQL server automatically when you boot your machine, copy the mysql.server script to the `/etc/init.d' directory with the name mysql, and then make it executable cp support-files/mysql.server /etc/init.d/mysql chmod +x /etc/init.d/mysql 10) Activate to run the script at system startup by adding to the chkconfig list chkconfig --add mysql chkconfig --level 345 mysql on For more information read http://dev.mysql.com/doc/mysql/en/Automatic_start.html Good luck... Sam --- "Kirti S. Bajwa" <[EMAIL PROTECTED]> wrote: > Brian: > > No. From where I copy this file from? Is it stright > copy or something else? > > You might be my savior!! > > Thanks. > > Kirti > > -----Original Message----- > From: Brian Duke [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 09, 2004 5:44 PM > To: 'Kirti S. Bajwa'; [EMAIL PROTECTED] > Subject: RE: MySQL does not automatically start at > BOOT time?? > > > I know that feeling. perhaps I can help. > do you have an /etc/rc.d/init.d/mysqld file? > > > -----Original Message----- > > From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] > > Sent: Sunday, May 09, 2004 3:29 PM > > To: '[EMAIL PROTECTED]' > > Subject: RE: MySQL does not automatically start at > BOOT time?? > > > > Hello List: > > > > I have spent the entire weekend solving this > problem without success. > > PLEASE > > HELP. > > > > After the last response from Paul, and MySQL not > starting at BOOT time, I > > thought that I may have done something wrong. So I > went ahead and did a > > fresh install of RH9 & MySQL Source Distro with > one difference. This time > > I > > installed "mysql-4.0.18". I followed the > installation script as noted > > below, > > still MySQL does not automatically re-start at > BOOT time. > > > > For those who did not follow this posting; > previously I have installed > > MySQL > > and followed the same installation script. Each > time MySQL started at BOOT > > time. The only major difference is that in > previous cases, I installed > > from > > the "binaries" & this time I installed from > "source". > > > > I can start the MySQL by "mysqld_safe". > > > > Paul had suggested looking into the MySQL error > logs. Since I am new, I > > can't find where are error logs are kept. I have > looked in "/var/log" & > > "/usr/local/mysql" and have not found any error > logs for MySQL. > > > > I sure need help!! > > > > Thanks. > > > > Kirti > > > > > > > > > > -----Original Message----- > > From: Paul DuBois [mailto:[EMAIL PROTECTED] > > Sent: Saturday, May 08, 2004 6:44 PM > > To: Kirti S. Bajwa > > Subject: RE: MySQL does not automatically start at > BOOT time?? > > > > > > >Paul: > > > > > >Did what you said. Here is the response: > > > > > >% chkconfig --list mysql.server > > >mysql.server 0:off 1:off 2:on 3:on 4:on 5:on > 6:off > > > > That looks correct. > > > > If you did chkconfig mysql.server on, *and then > restarted*, and the > > server still doesn't start automatically, check > the MySQL error log > > to see if it has a clue. If it doesn't, I dunno. > > > > > > > > > > >What next? > > > > > >Kirti > > > > > > > > >-----Original Message----- > > >From: Paul DuBois [mailto:[EMAIL PROTECTED] > > >Sent: Saturday, May 08, 2004 2:24 PM > > >To: Kirti S. Bajwa; [EMAIL PROTECTED] > > >Subject: Re: MySQL does not automatically start > at BOOT time?? > > > > > > > > >At 14:08 -0400 5/8/04, Kirti S. Bajwa wrote: > > >>Hello List: > > >> > > >>I have been learning MySQL. I have installed & > tested MySQL server 3-4 > > >times > > >>without problem. This time I used the an > "alpha-nightly snapshot" and > > have > > >>run into problems. > > >> > > >>My current Installation: > > >>---------------------- > > >>LINUX RH9 > > >>Source Installaion: > mysql-5.0.1-alpha-nightly-20040504.tar.gz > > >> > > >>DUAL Pentium 1GHz CPU > > >>1.5 GB Memory > > >> > > >>Installation Procedure: > > >>---------------------- > > >>I follow the installation procedure is as > described in MySQL > > documentation > > >& > > >>a doze of consulting MySQL by Paul DuBois book: > > >> > > >> % cd /usr/local > > >> % gunzip -dc > mysql-5.0.1-alpha-nightly-20040504.tar.gz | tar xvf > - > > >> % cd mysql-5.0.1-alpha-nightly-20040504 > > >> % ./configure -prefix=/usr/local/mysql > > >> % make > > >> % make install > > >>% scripts/mysql_install_db > > >> % chown -R mysqladm.mysqlgrp > /usr/local/mysql/var > > >> % chown -R mysqladm.mysqlgrp /rad/var > > >> % chmod -R go-rwx /usr/local/mysql/var > > >> * It is a good idea to first see if the MySQL > can be > > >>started: > > >> % /usr/local/mysql/bin/mysqld_safe > -user=mysqladm & > > >> % ps -aux | grep mysql > > >> There should be 4-5 lines showing how MySQL > > >>is running. > > >> Wonderful, MySQL is running. > > >> % reboot > > >>Setup to start MySQL automatically > > >> % cp /usr/local/<mysql Version > No>/mysql.server > > >>/etc/init.d > > >> % cd /etc/init.d > > >> % chmod 500 mysql.server > > >> % chkconfig - -add mysql.server > > > > > >Try adding: > > > > > >chkconfig mysql.server on > > > > > >Then run this to see if it's been enabled for the > appropriate runlevels: > > > > > >chkconfig --list mysql.server > > > > > >> % reboot > > >> > > >> Check if MySQL is running: > > >> % ps -aux | grep mysql > > >> > > >>Problem: > > >>--------- > > >>Well, MySQL does not start automatically. > > > >>------------------------------------------------------------------------ > > -- > > - > > >- > > >>---------- > > >>As I said, I have used a similar installation > script before without > === message truncated === ===== _o /\ ---- __o -< \_ / \ ---- < \, __(_)/_(_)________/ \_______(_) /_(_)__ __________________________________ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- 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]