MySQL Server starting then immediately stopping.

MySQL Server starting then immediately stopping.

Post by Bill Leona » Tue, 06 Aug 2002 22:57:39



What might be the cause of this... ?

The console simply reports that it is starting, but then immediately ends,
no errors etc. And then why I try to connect with the mysql client it gives
the 2002 socket error. Any ideas? Any permissions to check?

--

www.machinemen.com                                            407.464.0147

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)



Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 
 
 

MySQL Server starting then immediately stopping.

Post by Victoria Reznichen » Tue, 06 Aug 2002 23:03:19


Bill,

BL> What might be the cause of this... ?

BL> The console simply reports that it is starting, but then immediately ends,
BL> no errors etc. And then why I try to connect with the mysql client it gives
BL> the 2002 socket error. Any ideas? Any permissions to check?

Check host_name.err file in the MySQL data dir. Is there any causes of
failed start?

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko

/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)



Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 
 
 

MySQL Server starting then immediately stopping.

Post by David Lubow » Tue, 06 Aug 2002 23:41:10


have a look at the ownership of the location of the installed_db, should be
mysql.daemon and mysql.mysql on some other OS's, that might be the main
problem i think.

ma 2 cents

cheers

Ziggy

-----Original Message-----

Sent: Monday, August 05, 2002 4:50 PM

Subject: MySQL Server starting then immediately stopping.

What might be the cause of this... ?

The console simply reports that it is starting, but then immediately ends,
no errors etc. And then why I try to connect with the mysql client it gives
the 2002 socket error. Any ideas? Any permissions to check?

--

www.machinemen.com                                            407.464.0147

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)


To unsubscribe, e-mail

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)



Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 
 
 

MySQL Server starting then immediately stopping.

Post by Bill Leona » Wed, 07 Aug 2002 10:39:29




Quote:> BL> The console simply reports that it is starting, but then immediately ends,
> BL> no errors etc. And then why I try to connect with the mysql client it
> gives
> BL> the 2002 socket error. Any ideas? Any permissions to check?

> Check host_name.err file in the MySQL data dir. Is there any causes of
> failed start?

Well, the error now appearing in the console is:

2002-08-05 20:34:53.655 MySQLInfoTool[1490] path:/usr/bin/safe_mysqld
args <CFArray 0x5a660 [0xa01403fc]>{type = immutable, count = 1, values = (
0 : <CFString 0x54280 [0xa01403fc]>{contents = "--user=mysql"}
)}
Env (null)

And in the .err log I get:

mysql started
/usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
mysql ended

Still trying to figure out what happened... I will have to wipe the drive
soon and start from scratch and I am trying to avoid that...!

Thanks,

--

www.machinemen.com                                            407.464.0147

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)



Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 
 
 

1. MySQL stops immediately after starting

I am trying to run the MySQL that comes with Red Hat Linux 7.3.
It is MySQL 3.23.49 for Red Hat Linux on i386. I can not get it to start and then stay on.

From root I type : /etc/init.d/mysqld start
I get :? Starting MySQL?? [OK]

When I look in:? /var/lib/mysql/localhost.localdomain.err
I see:?????????? /usr/libexec/mysqld : unrecognized option'--key_buffer=16M

I changed 'key_buffer' to 'key_buffer_size',
but then the err was 'unrecognized option'--key_buffer_size'

I have tried to reinstal mysql and mysql server
from the CD with the -U command, but this did not make
a difference.

Also, I have run the commands :mysql_install_db???????????????????????????????????????????????????????????????????????????????????????????????         cd /usr????
??????? /usr/bin/safe_mysqld

From this I get :
[2] 272?????????????????????????????????????????

 040708????????? 17:13:59 mysqld ended

It then does not go to a # prompt, but seems to hang.
If I type anything and then return
it returns :? ERROR 2002 : Can't connect to local MySQLserver through socket '/tmp/mysql.sock (2)???????????????
?            [2-] - Done

I have consulted the manual as well as tried a lot of things, but no help.
I am new to this so please forgive it the answer is obvious.
--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

2. compiling libraries...

3. logs: is there a possibility to stop/start them without stopping server

4. another test

5. starting , stopping server

6. ENSONIC SoundScape sound card over Solaris 2.5 for i86pc

7. Suggestions wanted on a client/server architecture

8. Starting/stopping server on WinXP Home standalone -- what's appropriate way?

9. problem mysql deamon start and end immediately

10. MySQL Starts, but quits immediately

11. mysqld immediately stops

12. MySQL Newbie: MySQL stops as soon as it starts