mysql not starting
this has been a problem to me from mysql 3.1 version now in 4.1 also the same problem during the instant configuration wizard the last screen which has start service does not turn green and mysql doesnt start ive tried removing mysql and reinstalling does this problem has anything to do with port or what is it please help? rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL not starting
Thanks Tom! Ya it was a problem of SELinux but i had to turn it off from GUI not from CUI(system-config-securitylevel). It really did worked. Thanks Again :) - Original Message - From: "Tom Brown" <[EMAIL PROTECTED]> To: "Atul Aggarwal" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, March 01, 2006 11:04 PM Subject: Re: MYSQL not starting > > > I have disabled selinux but no luck > > how? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Original Message - From: "Atul Aggarwal" <[EMAIL PROTECTED]> To: "Tom Brown" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, March 01, 2006 10:50 PM Subject: Re: MYSQL not starting > I have disabled selinux but no luck > [EMAIL PROTECTED] ~]# system-config-securitylevel > Security Level (*) Disabled OK > [EMAIL PROTECTED] ~]# /etc/init.d/mysql start > Starting MySQL... [FAILED] > [EMAIL PROTECTED] ~]# > > > I am receiving these errors in /var/lib/mysql/*.err > > > > 060301 14:32:08 mysqld started > 060301 14:32:08 [Warning] Asked for 196608 thread stack, but got 126976 > InnoDB: Error: pthread_create returned 11 > 060301 14:32:08 mysqld ended > > > And when I scroll through /var/log/messages I get these : > > > > Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { > execmem } for pid=20857 comm="mysqld" scontext=root:system_r:mysqld_t > tcontext=root:system_r:mysqld_t tclass=process > > > > I have also tried running these commands : > > > > [EMAIL PROTECTED] sqlserver4.1]# rpm -Uvh MySQL-server-4.1.14-0.i386.rpm > --force > warning: MySQL-server-4.1.14-0.i386.rpm: V3 DSA signature: NOKEY, key ID > 5072e1f > 5 > Preparing...### > [100%] > Giving mysqld a couple of seconds to exit nicely >1:MySQL-server ### > [100%] > 060301 15:16:12 [Warning] Asked for 196608 thread stack, but got 126976 > 060301 15:16:12 [ERROR] Can't create interrupt-thread (error 11, errno: 4) > Installation of system tables failed! > > Examine the logs in /var/lib/mysql for more information. > You can also try to start the mysqld daemon with: > /usr/sbin/mysqld --skip-grant & > You can use the command line tool > /usr/bin/mysql to connect to the mysql > database and look at the grant tables: > > shell> /usr/bin/mysql -u root mysql > mysql> show tables > > Try 'mysqld --help' if you have problems with paths. Using --log > gives you a log in /var/lib/mysql that may be helpful. > > The latest information about MySQL is available on the web at > http://www.mysql.com > Please consult the MySQL manual section: 'Problems running > mysql_install_db', > and the manual section that describes problems on your OS. > Another information source is the MySQL email archive. > Please check all of the above before mailing us! > And if you do mail us, you MUST use the /usr/bin/mysqlbug script! > Starting MySQL...[FAILED] > [EMAIL PROTECTED] sqlserver4.1]# > > > [EMAIL PROTECTED] sqlserver4.1]# /usr/sbin/mysqld --skip-grant > 060301 15:20:44 [Warning] Asked for 196608 thread stack, but got 126976 > 060301 15:20:44 [ERROR] Fatal error: Please read "Security" section of the > manual to find out how to run mysqld as root! > > 060301 15:20:44 [ERROR] Aborting > > 060301 15:20:44 [Note] /usr/sbin/mysqld: Shutdown complete > > [EMAIL PROTECTED] sqlserver4.1]# > > > > Can anyone Please HELP > > > > - Original Message - > From: "Tom Brown" <[EMAIL PROTECTED]> > To: "Atul Aggarwal" <[EMAIL PROTECTED]> > Cc: > Sent: Wednesday, March 01, 2006 9:18 PM > Subject: Re: MYSQL not starting > > > > > > > Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied > { execmem } for pid=20857 comm="mysqld" scontext=root:system_r:mysqld_t > tcontext=root:system_r:mysqld_t tclass=process > > > > you have enabled selinux > > > > disable it or learn how to use it correctly > > > > > > -- > > 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]
Re: MYSQL not starting
I have disabled selinux but no luck how? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL not starting
I have disabled selinux but no luck [EMAIL PROTECTED] ~]# system-config-securitylevel Security Level (*) Disabled OK [EMAIL PROTECTED] ~]# /etc/init.d/mysql start Starting MySQL... [FAILED] [EMAIL PROTECTED] ~]# I am receiving these errors in /var/lib/mysql/*.err 060301 14:32:08 mysqld started 060301 14:32:08 [Warning] Asked for 196608 thread stack, but got 126976 InnoDB: Error: pthread_create returned 11 060301 14:32:08 mysqld ended And when I scroll through /var/log/messages I get these : Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm="mysqld" scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process I have also tried running these commands : [EMAIL PROTECTED] sqlserver4.1]# rpm -Uvh MySQL-server-4.1.14-0.i386.rpm --force warning: MySQL-server-4.1.14-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f 5 Preparing...### [100%] Giving mysqld a couple of seconds to exit nicely 1:MySQL-server ### [100%] 060301 15:16:12 [Warning] Asked for 196608 thread stack, but got 126976 060301 15:16:12 [ERROR] Can't create interrupt-thread (error 11, errno: 4) Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can also try to start the mysqld daemon with: /usr/sbin/mysqld --skip-grant & You can use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! Starting MySQL...[FAILED] [EMAIL PROTECTED] sqlserver4.1]# [EMAIL PROTECTED] sqlserver4.1]# /usr/sbin/mysqld --skip-grant 060301 15:20:44 [Warning] Asked for 196608 thread stack, but got 126976 060301 15:20:44 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! 060301 15:20:44 [ERROR] Aborting 060301 15:20:44 [Note] /usr/sbin/mysqld: Shutdown complete [EMAIL PROTECTED] sqlserver4.1]# Can anyone Please HELP - Original Message - From: "Tom Brown" <[EMAIL PROTECTED]> To: "Atul Aggarwal" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, March 01, 2006 9:18 PM Subject: Re: MYSQL not starting > > > Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm="mysqld" scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process > > you have enabled selinux > > disable it or learn how to use it correctly > > > -- > 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]
Re: MYSQL not starting
Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm="mysqld" scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process you have enabled selinux disable it or learn how to use it correctly -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL not starting
Hi, I am using MYSQL 4.1. But since yesterday I am not able to start the mysqld daemon. I am receiving these errors in /var/lib/mysql/*.err 060301 14:32:08 mysqld started 060301 14:32:08 [Warning] Asked for 196608 thread stack, but got 126976 InnoDB: Error: pthread_create returned 11 060301 14:32:08 mysqld ended And when I scroll through /var/log/messages I get these : Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm="mysqld" scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process Can some one please help on an urgent basis as my neck is hanging as I was performing the backup when all this screw up took place. Till date I do not have any backup of mysql.
RE: new insallation of mysql not starting
Whoops - that wasn't an error code (thanks Prasanna!) Here is the log file.. 050429 11:32:08 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 050429 11:32:09 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 050429 11:32:10 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 050429 11:32:10 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 050429 11:32:12 InnoDB: Started; log sequence number 0 0 050429 11:32:13 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050429 11:32:13 mysqld ended Thanks Andy -Original Message- From: Andy Ford [mailto:[EMAIL PROTECTED] Sent: Friday, April 29, 2005 12:26 PM To: Mysql (E-mail) Subject: new insallation of mysql not starting I have just upgraded a mySQL installation on a Soalri 2.8 box for the source. It compiled and installed without error. The startup script redirect STDOUT & STDERR into /dev/null so this is what I did ... /usr/bin/mysqld_safe --datadir=/data/mysql-data/ --pid-file=/data/mysql-data/mysql.pid Starting mysqld daemon with databases from /data/mysql-data/ STOPPING server from pid file /data/mysql-data/romulus.pid 050429 11:19:13 mysqld ended Anyone have any ideas what the code 050429 means? And where are the log files? Thanks Andy This e-mail is private and may be confidential and is for the intended recipient only. If misdirected, please notify us by telephone and confirm that it has been deleted from your system and any copies destroyed. If you are not the intended recipient you are strictly prohibited from using, printing, copying, distributing or disseminating this e-mail or any information contained in it. We use reasonable endeavours to virus scan all e-mails leaving the Company but no warranty is given that this e-mail and any attachments are virus free. You should undertake your own virus checking. The right to monitor e-mail communications through our network is reserved by us. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
new insallation of mysql not starting
I have just upgraded a mySQL installation on a Soalri 2.8 box for the source. It compiled and installed without error. The startup script redirect STDOUT & STDERR into /dev/null so this is what I did ... /usr/bin/mysqld_safe --datadir=/data/mysql-data/ --pid-file=/data/mysql-data/mysql.pid Starting mysqld daemon with databases from /data/mysql-data/ STOPPING server from pid file /data/mysql-data/romulus.pid 050429 11:19:13 mysqld ended Anyone have any ideas what the code 050429 means? And where are the log files? Thanks Andy This e-mail is private and may be confidential and is for the intended recipient only. If misdirected, please notify us by telephone and confirm that it has been deleted from your system and any copies destroyed. If you are not the intended recipient you are strictly prohibited from using, printing, copying, distributing or disseminating this e-mail or any information contained in it. We use reasonable endeavours to virus scan all e-mails leaving the Company but no warranty is given that this e-mail and any attachments are virus free. You should undertake your own virus checking. The right to monitor e-mail communications through our network is reserved by us.
Re: MySQL not starting at boot-Fedora Core 3
Hello. Are you able to start MySQL server by this command? service mysqld start I think you should put the correct values for the basedir, datadir, PATH variables at the beginning of the /etc/init.d/mysql file. Mark Sargent <[EMAIL PROTECTED]> wrote: > Hi All, > > attempting another mysql install, on a 3rd machine. Extracted the tar.gz > file to /usr/local/mysql. Followed the install docs here, > > http://dev.mysql.com/doc/mysql/en/installing-binary.html > > and successfully ran the MySql grant tables script, > > 6. If you haven't installed MySQL before, you must create the MySQL > grant tables: > > shell> scripts/mysql_install_db --user=mysql > > > I then followed here, > > http://dev.mysql.com/doc/mysql/en/automatic-start.html > > to a T, and copied mysql.server to /etc/init.d, and just for good > measure, gave it permission to execute, > > chmod +x /etc/init.d/mysql > > I then rebooted, to see how things would go at boot, and saw a failed > message for mysqld_safe, > > Apr 16 21:20:01 localhost lsb_log_message: Can't execute > ./bin/mysqld_safe failed > > Can anyone explain why it wouldn't start..? Anything I should be looking > for..? I can start the server with ./mysqld_safe from within the bin dir > and I can connect as root or mysql. Cheers. > > /etc/init.dmysql permissions > > [EMAIL PROTECTED] init.d]# ls -lh mysql > -rwxr-xr-x 1 root root 6.2K Apr 16 21:11 mysql > > Mark Sargent. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Michael Stassen wrote: Mark Sargent wrote: Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy Hi All, that's just the problem. It won't start that way. I had already checked the logs, but, it only seems to log things after starting, bringing me back to zero position, a server that won't start this way. Cheers. (It was safe_mysqld in mysql 3.) Not sure what you mean there.. [EMAIL PROTECTED] ~]# /sbin/service mysql start Can't execute ./bin/mysqld_safe[FAILED] Your error message is right there -- "Can't execute ./bin/mysqld_safe". If you look in mysql.server, you'll see cd $basedir case "$mode" in 'start') # Start daemon if test -x $bindir/mysqld_safe then # ... code to start the server ... else log_failure_msg "Can't execute $bindir/mysqld_safe" fi Clearly, ./bin/mysqld_safe is failing the -x test. As you previously reported that ./mysqld_safe works if you are in mysql's bin directory, we know that mysqld_safe is executable. Hence, when mysql.server tries to run ./bin/mysqld_safe, it must not be in the right directory. That is, it has the wrong value for $basedir. Perhaps you installed mysql somewhere other than the standard location? Nope, it is located here, /usr/local/mysql. You could edit mysql.server to add an "echo $basedir" right before the cd, then run it by hand to you can see where the script thinks it should go. The fix will probably involve setting the basedir in /etc/my.cnf to the correct value. Yes, I went and looked at the script, to see if something was wrong. I couldn't see anything out of order, although, I'm a novice at scripts(programming). If that's not enough to get you going in the right direction, write back and let us know. Hopefully it'll get me going. Cheers. Michael Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Mark Sargent wrote: Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy Hi All, that's just the problem. It won't start that way. I had already checked the logs, but, it only seems to log things after starting, bringing me back to zero position, a server that won't start this way. Cheers. (It was safe_mysqld in mysql 3.) [EMAIL PROTECTED] ~]# /sbin/service mysql start Can't execute ./bin/mysqld_safe[FAILED] Your error message is right there -- "Can't execute ./bin/mysqld_safe". If you look in mysql.server, you'll see cd $basedir case "$mode" in 'start') # Start daemon if test -x $bindir/mysqld_safe then # ... code to start the server ... else log_failure_msg "Can't execute $bindir/mysqld_safe" fi Clearly, ./bin/mysqld_safe is failing the -x test. As you previously reported that ./mysqld_safe works if you are in mysql's bin directory, we know that mysqld_safe is executable. Hence, when mysql.server tries to run ./bin/mysqld_safe, it must not be in the right directory. That is, it has the wrong value for $basedir. Perhaps you installed mysql somewhere other than the standard location? You could edit mysql.server to add an "echo $basedir" right before the cd, then run it by hand to you can see where the script thinks it should go. The fix will probably involve setting the basedir in /etc/my.cnf to the correct value. If that's not enough to get you going in the right direction, write back and let us know. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy Hi All, that's just the problem. It won't start that way. I had already checked the logs, but, it only seems to log things after starting, bringing me back to zero position, a server that won't start this way. Cheers. [EMAIL PROTECTED] ~]# /sbin/service mysql start Can't execute ./bin/mysqld_safe[FAILED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy -- Registered Linux User Number 379093 -- --BEGIN GEEK CODE BLOCK- Version: 3.1 GAT/O/>E$ d-(---)>+ s:(+)>: a--(-)>? C$(+++) UL>$ P-(+)>++ L+++>$ E---(-)@ W+++>+++$ !N@ o? !K? W--(---) !O !M- V-- PS++(+++) PE--(-) Y+ PGP++(+++) t+(++) 5-- X++ R*(+)@ !tv b-() DI(+) D+(+++) G(+) e>$@ h++(*) r-->++ y--()> -- ---END GEEK CODE BLOCK-- -- Check out these few php utilities that I released under the GPL2 and that are meant for use with a php cli binary: http://www.vlaamse-kern.com/sas/ -- -- pgpAURHhrWK92.pgp Description: PGP signature
MySQL not starting at boot-Fedora Core 3
Hi All, attempting another mysql install, on a 3rd machine. Extracted the tar.gz file to /usr/local/mysql. Followed the install docs here, http://dev.mysql.com/doc/mysql/en/installing-binary.html and successfully ran the MySql grant tables script, 6. If you haven't installed MySQL before, you must create the MySQL grant tables: shell> scripts/mysql_install_db --user=mysql I then followed here, http://dev.mysql.com/doc/mysql/en/automatic-start.html to a T, and copied mysql.server to /etc/init.d, and just for good measure, gave it permission to execute, chmod +x /etc/init.d/mysql I then rebooted, to see how things would go at boot, and saw a failed message for mysqld_safe, Apr 16 21:20:01 localhost lsb_log_message: Can't execute ./bin/mysqld_safe failed Can anyone explain why it wouldn't start..? Anything I should be looking for..? I can start the server with ./mysqld_safe from within the bin dir and I can connect as root or mysql. Cheers. /etc/init.dmysql permissions [EMAIL PROTECTED] init.d]# ls -lh mysql -rwxr-xr-x 1 root root 6.2K Apr 16 21:11 mysql Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql not starting at boot
To have mysql to start at boot you need to inform the inetd (daemon) that mysql should be launched at one of the 6 levels: Use chkconfig to have mysql start in one of the level (2,3,4,5,6) 5 being X windows. There are two ways to check that mysql will be loaded: - 1 - by checking the file in /etc/rc.d/rcX.d (X being a number: 1,2,3,4,5,6) - 2 - by executing chkconfig execute the following to see if mysql runs at any level > /sbin/chkconfig --list | grep mysql you should see at which level mysql is running. mysql 0:off 1:off 2:off 3:off 4:off 5:off 6:off If it is all off then execute: > /sbin/chkconfig --level 2345 mysql on (this will make sure that mysql runs at level 2, 3, 4 and 5) On my machine (Fedora 2) it runs at 2,3,4 and 5. Once you have it run at a level you can verify it by looking at rcX.d (X being a level): for example to check that it runs at level 4: go to /etc/rc.d/rc4.d/ and look at a file named ...mysql S20mysql (S means it will be picked up by the inetd daemon) K30mysql (K means Kill and mysql wont start) good luck Laurie On Wednesday 30 March 2005 09:26 pm, Mark Sargent wrote: > Hi All, > > below is my /etc/init.d/mysql content, but, mysql is not starting at > boot on Fedora3. Have I missed something fundamental.? I need mysql to > start at boot for snort to connect to it. Currently, snort gives an > error stating it can't connect. Cheers. > > Mark Sargent. > > [EMAIL PROTECTED] ~]# cat /etc/init.d/mysql > #!/bin/sh > # Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron > HB # This file is public domain and comes with NO WARRANTY of any kind > > # MySQL daemon start/stop script. > > # Usually this is put in /etc/init.d (at least on machines SYSV R4 based > # systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql. > # When this is done the mysql server will be started when the machine is > # started and shut down when the systems goes down. > > # Comments to support chkconfig on RedHat Linux > # chkconfig: 2345 90 20 > # description: A very fast and reliable SQL database engine. > > # Comments to support LSB init script conventions > ### BEGIN INIT INFO > # Provides: mysql > # Required-Start: $local_fs $network $remote_fs > # Required-Stop: $local_fs $network $remote_fs > # Default-Start: 2 3 4 5 > # Default-Stop: 0 1 6 > # Short-Description: start and stop MySQL > # Description: MySQL is a very fast and reliable SQL database engine. > ### END INIT INFO > > # If you install MySQL on some other places than /usr/local/mysql, then you > # have to do one of the following things for this script to work: > # > # - Run this script from within the MySQL installation directory > # - Create a /etc/my.cnf file with the following information: > # [mysqld] > # basedir= > # - Add the above to any other configuration file (for example ~/.my.ini) > # and copy my_print_defaults to /usr/bin > # - Add the path to the mysql-installation-directory to the basedir > variable # below. > # > # If you want to affect other MySQL variables, you should make your changes > # in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files. > > basedir= > > # The following variables are only set for letting mysql.server find > things. > > # Set some defaults > datadir=/usr/local/mysql/data > pid_file= > if test -z "$basedir" > then > basedir=/usr/local/mysql > bindir=./bin > else > bindir="$basedir/bin" > fi > > PATH=/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin > export PATH > > mode=$1# start or stop > > case `echo "testing\c"`,`echo -n testing` in > *c*,-n*) echo_n= echo_c= ;; > *c*,*) echo_n=-n echo_c= ;; > *) echo_n= echo_c='\c' ;; > esac > > parse_arguments() { > for arg do > case "$arg" in > --basedir=*) basedir=`echo "$arg" | sed -e 's/^[^=]*=//'` ;; > --datadir=*) datadir=`echo "$arg" | sed -e 's/^[^=]*=//'` ;; > --pid-file=*) pid_file=`echo "$arg" | sed -e 's/^[^=]*=//'` ;; > esac > done > } > > # Get arguments from the my.cnf file, > # groups [mysqld] [mysql_server] and [mysql.server] > if test -x ./bin/my_print_defaults > then > print_defaults="./bin/my_print_defaults" > elif test -x $bindir/my_print_defaults > then > print_defaults="$bindir/my_print_defaults" > elif test -x $bindir/mysql_print_defaults > then > print_defaults="$bindir/mysql_print_defaults" > else > # Try to find basedir in /etc/my.cnf > conf=/etc/my.cnf > print_defaults= > if test -r $conf > then > subpat='^[^=]*basedir[^=]*=\(.*\)$' > dirs=`sed -e "/$subpat/!d" -e 's//\1/' $conf` > for d in $dirs > do > d=`echo $d | sed -e 's/[ ]//g'` > if test -x "$d/bin/my_print_defaults" > then > print_defaults="$d/bin/my_print_defaults" > break > fi > if test -x "$d/bin/mysql_print_defaults" > then > print_defaults="$d/bin/mysql_print_defaults" > break > fi > done > fi > > # Hope it's in the PATH ... but
Re: mysql not starting at boot
Tom Crimmins wrote: On Wednesday, March 30, 2005 23:26, Mark Sargent wrote: Hi All, below is my /etc/init.d/mysql content, but, mysql is not starting at boot on Fedora3. Have I missed something fundamental.? I need mysql to start at boot for snort to connect to it. Currently, snort gives an error stating it can't connect. Cheers. Mark Sargent. I assume you are able to start it after boot using 'service mysql start'. Run: chkconfig --list mysql This should show a list of runlevels with on and off. If not run: chkconfig --add mysql Hi All, thanx, that did it. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql not starting at boot
On Wednesday, March 30, 2005 23:26, Mark Sargent wrote: > Hi All, > > below is my /etc/init.d/mysql content, but, mysql is not starting at > boot on Fedora3. Have I missed something fundamental.? I need mysql to > start at boot for snort to connect to it. Currently, snort gives an > error stating it can't connect. Cheers. > > Mark Sargent. I assume you are able to start it after boot using 'service mysql start'. Run: chkconfig --list mysql This should show a list of runlevels with on and off. If not run: chkconfig --add mysql -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql not starting at boot
Hi All, below is my /etc/init.d/mysql content, but, mysql is not starting at boot on Fedora3. Have I missed something fundamental.? I need mysql to start at boot for snort to connect to it. Currently, snort gives an error stating it can't connect. Cheers. Mark Sargent. [EMAIL PROTECTED] ~]# cat /etc/init.d/mysql #!/bin/sh # Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB # This file is public domain and comes with NO WARRANTY of any kind # MySQL daemon start/stop script. # Usually this is put in /etc/init.d (at least on machines SYSV R4 based # systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql. # When this is done the mysql server will be started when the machine is # started and shut down when the systems goes down. # Comments to support chkconfig on RedHat Linux # chkconfig: 2345 90 20 # description: A very fast and reliable SQL database engine. # Comments to support LSB init script conventions ### BEGIN INIT INFO # Provides: mysql # Required-Start: $local_fs $network $remote_fs # Required-Stop: $local_fs $network $remote_fs # Default-Start: 2 3 4 5 # Default-Stop: 0 1 6 # Short-Description: start and stop MySQL # Description: MySQL is a very fast and reliable SQL database engine. ### END INIT INFO # If you install MySQL on some other places than /usr/local/mysql, then you # have to do one of the following things for this script to work: # # - Run this script from within the MySQL installation directory # - Create a /etc/my.cnf file with the following information: # [mysqld] # basedir= # - Add the above to any other configuration file (for example ~/.my.ini) # and copy my_print_defaults to /usr/bin # - Add the path to the mysql-installation-directory to the basedir variable # below. # # If you want to affect other MySQL variables, you should make your changes # in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files. basedir= # The following variables are only set for letting mysql.server find things. # Set some defaults datadir=/usr/local/mysql/data pid_file= if test -z "$basedir" then basedir=/usr/local/mysql bindir=./bin else bindir="$basedir/bin" fi PATH=/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin export PATH mode=$1# start or stop case `echo "testing\c"`,`echo -n testing` in *c*,-n*) echo_n= echo_c= ;; *c*,*) echo_n=-n echo_c= ;; *) echo_n= echo_c='\c' ;; esac parse_arguments() { for arg do case "$arg" in --basedir=*) basedir=`echo "$arg" | sed -e 's/^[^=]*=//'` ;; --datadir=*) datadir=`echo "$arg" | sed -e 's/^[^=]*=//'` ;; --pid-file=*) pid_file=`echo "$arg" | sed -e 's/^[^=]*=//'` ;; esac done } # Get arguments from the my.cnf file, # groups [mysqld] [mysql_server] and [mysql.server] if test -x ./bin/my_print_defaults then print_defaults="./bin/my_print_defaults" elif test -x $bindir/my_print_defaults then print_defaults="$bindir/my_print_defaults" elif test -x $bindir/mysql_print_defaults then print_defaults="$bindir/mysql_print_defaults" else # Try to find basedir in /etc/my.cnf conf=/etc/my.cnf print_defaults= if test -r $conf then subpat='^[^=]*basedir[^=]*=\(.*\)$' dirs=`sed -e "/$subpat/!d" -e 's//\1/' $conf` for d in $dirs do d=`echo $d | sed -e 's/[ ]//g'` if test -x "$d/bin/my_print_defaults" then print_defaults="$d/bin/my_print_defaults" break fi if test -x "$d/bin/mysql_print_defaults" then print_defaults="$d/bin/mysql_print_defaults" break fi done fi # Hope it's in the PATH ... but I doubt it test -z "$print_defaults" && print_defaults="my_print_defaults" fi # # Test if someone changed datadir; In this case we should also read the # default arguments from this directory # extra_args="" if test "$datadir" != "/usr/local/mysql/data" then extra_args="-e $datadir/my.cnf" fi parse_arguments `$print_defaults $extra_args mysqld server mysql_server mysql.se rver` # # Set pid file if not given # if test -z "$pid_file" then pid_file=$datadir/`/bin/hostname`.pid else case "$pid_file" in /* ) ;; * ) pid_file="$datadir/$pid_file" ;; esac fi # Safeguard (relative paths, core dumps..) cd $basedir case "$mode" in 'start') # Start daemon if test -x $bindir/mysqld_safe then # Give extra arguments to mysqld with the my.cnf file. This script may # be overwritten at next upgrade. $bindir/mysqld_safe --datadir=$datadir --pid-file=$pid_file >/dev/null 2>& 1 & # Make lock for RedHat / SuSE if test -w /var/lock/subsys then touch /var/lock/subsys/mysql fi else echo "Can't execute $bindir/mysqld_safe from dir $basedir" fi ;; 'stop') # Stop daemon. We use a signal here to avoid having to know the # root password. if test -s "$pid_file" then mysqld_pid=`cat $pid_file` echo "Killing mysqld with pid $mysqld_pid" kill $mysqld_pid # mysqld should remove the pid_file when it exits, so wait for
Re: MYSQL not starting
In the last episode (Sep 04), Jerry Rasmussen said: > I recently installed mysql 4 from source. After compiling everything I > am unable to start mysql. This is the error I get in the log when I try > to start mysql. > > 030901 19:41:35 Fatal error: Can't open privilege tables: Can't find > file: './mysql/host.frm' (errno: 13) > > I am trying to get this to run on a Red Hat 9 install of Linux. Any > help would be appreciated. $ perror 13 Error code 13: Permission denied Check the permissions on the datadir and make sure whatever user mysqld is running as can read the files. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL not starting
I do not have a my.ini. I do have a my.cnf. Any other ideas. On Fri, 2003-09-05 at 00:44, Martin Gainty wrote: > did you look at datadir specification in my.ini? > -Martin > - Original Message - > From: "Jerry Rasmussen" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, September 04, 2003 5:59 PM > Subject: MYSQL not starting > > > > I recently installed mysql 4 from source. After compiling everything I > > am unable to start mysql. This is the error I get in the log when I try > > to start mysql. > > > > 030901 19:41:35 Fatal error: Can't open privilege tables: Can't find > > file: './mysql/host.frm' (errno: 13) > > > > I am trying to get this to run on a Red Hat 9 install of Linux. Any > > help would be appreciated. > > > > Thanks > > Jerry > > > > > > -- > > 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]
Re: MYSQL not starting
did you look at datadir specification in my.ini? -Martin - Original Message - From: "Jerry Rasmussen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 5:59 PM Subject: MYSQL not starting > I recently installed mysql 4 from source. After compiling everything I > am unable to start mysql. This is the error I get in the log when I try > to start mysql. > > 030901 19:41:35 Fatal error: Can't open privilege tables: Can't find > file: './mysql/host.frm' (errno: 13) > > I am trying to get this to run on a Red Hat 9 install of Linux. Any > help would be appreciated. > > Thanks > Jerry > > > -- > 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 not starting
I recently installed mysql 4 from source. After compiling everything I am unable to start mysql. This is the error I get in the log when I try to start mysql. 030901 19:41:35 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) I am trying to get this to run on a Red Hat 9 install of Linux. Any help would be appreciated. Thanks Jerry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting.
Are you sure your sym-links have not been deleted? - Mark System Administrator Asarian-host.org --- "If you were supposed to understand it, we wouldn't call it code." - FedEx - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 23, 2002 10:14 PM Subject: Re: MySQL not starting. > One line says : > > The file /usr/local/mysql/libexec/mysqld doesn't exist or is not > executable - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL not starting.
One line says : The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Does it exist? Is it executable? Is it owned my mysql? Does mysql own /usr/local/mysql and all its subdirectories and files? Another line says ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) Error 2 means that the directory doesn't exist. Does it? Does mysql own it and all its subdirectories and files? Why is one directory "/usr/local/mysql" and the other "/usr/local/mysql-3.23.52-pc-linux-gnu-i686" ? It looks to me like the log is telling you everything you need to know to find the problem. [EMAIL PROTECTED] wrote: I have tried both as myself and as root and received the same results. Thanks, Ed On Wed, 23 Oct 2002, gerald_clark wrote: You are not logged in as root. [EMAIL PROTECTED] wrote: I recently installed MySQL-3.23.52 and ranthrough the config and installation without any trouble. The server was running just fine. Today I performed a reboot of the system and the server will not start up again. I also tried to start the server by hand and these are the error messages I'm receiving: from /usr/local/mysql/bin... [ed@home bin]$ ./safe_mysqld The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. [ed@home bin]$ ./mysqld 021023 7:03:11 Warning: setrlimit couldn't increase number of open files to mo re than 256 021023 7:03:11 Warning: Changed limits: max_connections: 100 table_cache: 73 ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) 021023 7:03:11 Aborting 021023 7:03:11 ./mysqld: Shutdown Complete Can anyone gather from this info why it's not starting and what I need to do to make it work again. The main installation directory is /usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link. Like I said before the server started just fine after initial installation. TIA, Ed Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL not starting.
I have tried both as myself and as root and received the same results. Thanks, Ed On Wed, 23 Oct 2002, gerald_clark wrote: > You are not logged in as root. > > [EMAIL PROTECTED] wrote: > > >I recently installed MySQL-3.23.52 and ranthrough the config and > >installation without any trouble. The server was running just fine. > > > >Today I performed a reboot of the system and the server will not start up > >again. I also tried to start the server by hand and these are the error > >messages I'm receiving: > > > >from /usr/local/mysql/bin... > >[ed@home bin]$ ./safe_mysqld > >The file /usr/local/mysql/libexec/mysqld doesn't exist or is not > >executable > >Please do a cd to the mysql installation directory and restart > >this script from there as follows: > >./bin/safe_mysqld. > > > >[ed@home bin]$ ./mysqld > >021023 7:03:11 Warning: setrlimit couldn't increase number of open files > >to mo > >re than 256 > >021023 7:03:11 Warning: Changed limits: max_connections: 100 > >table_cache: 73 > >./mysqld: Can't change dir to > >'/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' > >(Errcode: 2) > >021023 7:03:11 Aborting > > > >021023 7:03:11 ./mysqld: Shutdown Complete > > > >Can anyone gather from this info why it's not starting and what I need to > >do to make it work again. The main installation directory is > >/usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link. > >Like I said before the server started just fine after initial > >installation. > > > >TIA, > > > >Ed Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL not starting.
You are not logged in as root. [EMAIL PROTECTED] wrote: I recently installed MySQL-3.23.52 and ranthrough the config and installation without any trouble. The server was running just fine. Today I performed a reboot of the system and the server will not start up again. I also tried to start the server by hand and these are the error messages I'm receiving: from /usr/local/mysql/bin... [ed@home bin]$ ./safe_mysqld The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. [ed@home bin]$ ./mysqld 021023 7:03:11 Warning: setrlimit couldn't increase number of open files to mo re than 256 021023 7:03:11 Warning: Changed limits: max_connections: 100 table_cache: 73 ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) 021023 7:03:11 Aborting 021023 7:03:11 ./mysqld: Shutdown Complete Can anyone gather from this info why it's not starting and what I need to do to make it work again. The main installation directory is /usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link. Like I said before the server started just fine after initial installation. TIA, Ed Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL not starting
I recently installed 3.23.52 on a server and everything went fine throughout the configuration and install. The server started fine and has been running flawlessly for the past 3 months. However, I needed to reboot the system this morning and MySQL wouldn't start back up. I have tried using both ./safe_mysqld and ./mysqld without any reults. The installation directory is /usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link to the installation directory. Here's what I'm getting: from /usr/local/mysql/bin [ed@home bin]$ ./safe_mysqld --user=mysql & The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. -or- [ed@home bin]$ ./mysqld 021023 7:27:08 Warning: setrlimit couldn't increase number of open files to mo re than 256 021023 7:27:08 Warning: Changed limits: max_connections: 100 table_cache: 73 ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) 021023 7:27:08 Aborting 021023 7:27:08 ./mysqld: Shutdown Complete The ./safe_mysqld --user=mysql & command is exactly the same command I used to start the server after initial installation as per the documentation. I can't understand why it's not starting up. I've tried running the command both as myself and root without any luck. Any ideas? TIA, Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL not starting.
I recently installed MySQL-3.23.52 and ranthrough the config and installation without any trouble. The server was running just fine. Today I performed a reboot of the system and the server will not start up again. I also tried to start the server by hand and these are the error messages I'm receiving: from /usr/local/mysql/bin... [ed@home bin]$ ./safe_mysqld The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. [ed@home bin]$ ./mysqld 021023 7:03:11 Warning: setrlimit couldn't increase number of open files to mo re than 256 021023 7:03:11 Warning: Changed limits: max_connections: 100 table_cache: 73 ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) 021023 7:03:11 Aborting 021023 7:03:11 ./mysqld: Shutdown Complete Can anyone gather from this info why it's not starting and what I need to do to make it work again. The main installation directory is /usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link. Like I said before the server started just fine after initial installation. TIA, Ed Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL not starting ?
On Friday, June 14, 2002, at 03:48 PM, Laura Findley wrote: > > Normally, I issue the command: > > [root@localhost root]# safe_mysqld -user=root & > [1] 1781 > [root@localhost root]# Starting mysqld daemon with databases from > /var/lib/mysql > 020614 02:09:36 mysqld ended Are you really only using one hyphen before "user"? Try using two: [root]# safe_mysqld --user=root & Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL not starting ?
All- Good afternoon. I was able to get MySQL started this morning but it will not start now. I'm hoping someone may be able to offer a suggestion or insight... Normally, I issue the command: [root@localhost root]# safe_mysqld -user=root & [1] 1781 [root@localhost root]# Starting mysqld daemon with databases from /var/lib/mysql 020614 02:09:36 mysqld ended Normally, I am then able to log in by: [root@localhost root]# mysql -u root -p Enter password: ...but mysqld is ending so I'm not able to. I went to /var/lib/mysql & looked at localhost.localdomain.err. I ran the tail command: [lfindle@localhost mysql]$ tail localhost.localdomain.err 020508 01:00:31 mysqld ended 020508 01:02:09 mysqld started /usr/sbin/mysqld: ready for connections 020508 2:54:15 /usr/sbin/mysqld: Normal shutdown 020508 2:54:15 /usr/sbin/mysqld: Shutdown Complete 020508 02:54:15 mysqld ended I'm assuming that 020508 means May 8, 02 & I know I've used my MySQL since then b/c I had it running this morning. Even still, I do not see any glaring errors in the file. I pasted the contents of localhost.localdomain.err, just in case I'm missing something. Does anyone have any ideas on what might be going wrong? Thank you Laura - 020502 13:12:51 mysqld started /usr/sbin/mysqld: ready for connections 020502 13:25:34 /usr/sbin/mysqld: Normal shutdown 020502 13:25:34 /usr/sbin/mysqld: Shutdown Complete 020502 13:25:34 mysqld ended 020503 05:54:36 mysqld started /usr/sbin/mysqld: ready for connections 020503 6:37:26 /usr/sbin/mysqld: Normal shutdown 020503 6:37:26 /usr/sbin/mysqld: Shutdown Complete 020503 06:37:26 mysqld ended 020503 06:39:05 mysqld started /usr/sbin/mysqld: ready for connections 020503 7:47:31 /usr/sbin/mysqld: Normal shutdown 020503 7:47:31 /usr/sbin/mysqld: Shutdown Complete 020503 07:47:31 mysqld ended 020503 07:49:10 mysqld started /usr/sbin/mysqld: ready for connections A mysqld process already exists at Fri May 3 09:06:06 EDT 2002 020503 14:06:02 /usr/sbin/mysqld: Normal shutdown 020503 14:06:02 /usr/sbin/mysqld: Shutdown Complete 020503 14:06:02 mysqld ended 020504 09:50:21 mysqld started /usr/sbin/mysqld: ready for connections 020504 14:34:24 /usr/sbin/mysqld: Normal shutdown 020504 14:34:25 /usr/sbin/mysqld: Shutdown Complete 020504 14:34:25 mysqld ended 020504 14:36:07 mysqld started /usr/sbin/mysqld: ready for connections 020505 8:47:23 /usr/sbin/mysqld: Normal shutdown 020505 8:47:23 /usr/sbin/mysqld: Shutdown Complete 020505 08:47:23 mysqld ended 020505 09:57:48 mysqld started /usr/sbin/mysqld: ready for connections 020505 11:58:35 /usr/sbin/mysqld: Normal shutdown 020505 11:58:35 /usr/sbin/mysqld: Shutdown Complete 020505 11:58:35 mysqld ended 020505 12:00:39 mysqld started /usr/sbin/mysqld: ready for connections 020505 8:21:15 /usr/sbin/mysqld: Normal shutdown 020505 8:21:15 /usr/sbin/mysqld: Shutdown Complete 020505 08:21:15 mysqld ended 020505 09:14:10 mysqld started /usr/sbin/mysqld: ready for connections 020505 10:39:22 /usr/sbin/mysqld: Normal shutdown 020505 10:39:22 /usr/sbin/mysqld: Shutdown Complete 020505 10:39:22 mysqld ended 020505 10:42:06 mysqld started /usr/sbin/mysqld: ready for connections 020505 23:00:29 /usr/sbin/mysqld: Normal shutdown 020505 23:00:29 /usr/sbin/mysqld: Shutdown Complete 020505 23:00:29 mysqld ended 020506 00:08:04 mysqld started /usr/sbin/mysqld: ready for connections 020506 2:05:09 /usr/sbin/mysqld: Normal shutdown 020506 2:05:09 /usr/sbin/mysqld: Shutdown Complete 020506 02:05:09 mysqld ended 020506 02:06:48 mysqld started /usr/sbin/mysqld: ready for connections 020506 8:23:37 /usr/sbin/mysqld: Normal shutdown 020506 8:23:37 /usr/sbin/mysqld: Shutdown Complete 020506 08:23:37 mysqld ended 020506 08:25:55 mysqld started /usr/sbin/mysqld: ready for connections 020506 10:31:23 /usr/sbin/mysqld: Normal shutdown 020506 10:31:23 /usr/sbin/mysqld: Shutdown Complete 020506 10:31:23 mysqld ended 020506 13:47:32 mysqld started /usr/sbin/mysqld: ready for connections 020506 22:59:33 /usr/sbin/mysqld: Normal shutdown 020506 22:59:33 /usr/sbin/mysqld: Shutdown Complete 020506 22:59:33 mysqld ended 020507 00:31:58 mysqld started /usr/sbin/mysqld: ready for connections 020507 9:00:17 /usr/sbin/mysqld: Normal shutdown 020507 9:00:18 /usr/sbin/mysqld: Shutdown Complete 020507 09:00:18 mysqld ended 020507 09:03:11 mysqld started /usr/sbin/mysqld: ready for connections 020507 9:11:14 /usr/sbin/mysqld: Normal shutdown 020507 9:11:14 /usr/sbin/mysqld: Shutdown Complete 020507 09:11:15 mysqld ended 020507 10:56:31 mysqld started /usr/sbin/mysqld: ready for connections 020507 11:25:16 /usr/sbin/mysqld: Normal shutdown 020507 11:25:16 /usr/sbin/mysqld: Shutdown Complete 020507 11:25:16 mysqld ended 020508 00:41:09 mysqld started /usr/sbin/
mysql not starting
I installed Mysql using the Apachetoolbox. Everything installed correctly, but when linux boots, mysqld starts, and stops immediately. I checked out the docs, and tried using "./safe_mysqld --skip-grant-tables" which starts to load mysql, but then hangs, causing me to reboot. I ran "mysql_install_db" which worked fine, but I was never able to setup root password or anything like that since mysql wont run for me. I have tried running "./safe_mysqld --user=mysql &" and all the variations with no luck (I tried this at the beginning) Any ideas? Thanks in advance for the replys Budroe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MYSQL not starting properly
I had the same problem on with Red Hat 7 using mysql-3.23.33. I installed from RPM and source. Never could get the darn thing working. I just scrapped .33 and downloaded .36. Works like a charm now. DG >Description: I am having a problem starting the mysql daemon from the command line. I am using the following command from /usr/local/mysql :- bin/safe_mysqld -u root & The resultant error file /usr/local/mysql/data/bon.err, has the following entries:- mysqld started on Thursday April 26 14:24:48 BST 2001 010426 14:24:48 /usr/local/mysql/bin/mysqld: Table 'mysql.host' doesn't exist 010426 14:24:48 /usr/local/mysql/bin/mysqld: Normal shutdown 010426 14:24:48 /usr/local/mysql/bin/mysqld: Shutdown Complete mysqld ended on Thursday April 26 14:24:48 BST 2001 Any clues ? >How-To-Repeat: Use above command >Fix: Unknown >Submitter-Id: >Originator:Mark Leedham >Organization: Startle plc 18-21 Cavaye Place Chelsea London UK SW10 9PT +44 (0)207 341 0947 >MySQL support: none >Synopsis: mysql not starting properly >Severity: critical >Priority: high >Category: mysql >Class: support >Release: mysql-3.23.33 (Official MySQL binary) >Environment: machine System: SunOS bon 5.7 Generic_106541-14 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.8.1/specs gcc version 2.8.1 Compilation info: CC='gcc' CFLAGS='-O3 ' CXX='gcc' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1732880 Dec 15 00:43 /lib/libc.a lrwxrwxrwx 1 root root 11 Sep 30 2000 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1147500 Dec 15 00:44 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1732880 Dec 15 00:43 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Sep 30 2000 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1147500 Dec 15 00:44 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --disable-shared _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL not starting properly
>Description: I am having a problem starting the mysql daemon from the command line. I am using the following command from /usr/local/mysql :- bin/safe_mysqld -u root & The resultant error file /usr/local/mysql/data/bon.err, has the following entries:- mysqld started on Thursday April 26 14:24:48 BST 2001 010426 14:24:48 /usr/local/mysql/bin/mysqld: Table 'mysql.host' doesn't exist 010426 14:24:48 /usr/local/mysql/bin/mysqld: Normal shutdown 010426 14:24:48 /usr/local/mysql/bin/mysqld: Shutdown Complete mysqld ended on Thursday April 26 14:24:48 BST 2001 Any clues ? >How-To-Repeat: Use above command >Fix: Unknown >Submitter-Id: >Originator:Mark Leedham >Organization: Startle plc 18-21 Cavaye Place Chelsea London UK SW10 9PT +44 (0)207 341 0947 >MySQL support: none >Synopsis: mysql not starting properly >Severity: critical >Priority: high >Category: mysql >Class: support >Release: mysql-3.23.33 (Official MySQL binary) >Environment: machine System: SunOS bon 5.7 Generic_106541-14 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.8.1/specs gcc version 2.8.1 Compilation info: CC='gcc' CFLAGS='-O3 ' CXX='gcc' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1732880 Dec 15 00:43 /lib/libc.a lrwxrwxrwx 1 root root 11 Sep 30 2000 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1147500 Dec 15 00:44 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1732880 Dec 15 00:43 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Sep 30 2000 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1147500 Dec 15 00:44 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php