Unix Technical Forum

MySQL shuts down immediatly after (automated) start

This is a discussion on MySQL shuts down immediatly after (automated) start within the Slackware Linux Support forums, part of the Unix Operating Systems category; --> Hello! I am NOT familiar with MySQL, so I try to use the dumb-people-method of installing the packet from ...


Go Back   Unix Technical Forum > Unix Operating Systems > Slackware Linux Support

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-19-2008, 01:31 PM
Stephen L.
 
Posts: n/a
Default MySQL shuts down immediatly after (automated) start

Hello!

I am NOT familiar with MySQL, so I try to use the dumb-people-method of
installing the packet from Slackware 9.1, enabling the rc.mysql in pkgtool
/ Setup / Services option, or, executing "# /etc/rc.d/rc.mysql start"
manually.

I always ends up like this:
--- Quote Start ---
bash-2.05b# /etc/rc.d/rc.mysqld start
bash-2.05b# Starting mysqld daemon with databases from /var/lib/mysql
040711 12:57:43 mysqld ended


bash-2.05b#
--- Quote End ---

Maybe the problem is a missing MySQL Database (Who can tell, there is no
more output, and I couldn't find a corresponding log file)...
.... but I wanted to create a Database from within an external application
like Prokyon3 (http://prokyon3.sf.net).

I also run mysql_install_db (seemingly) succesfully, but no chance to run
mysqld without having it shut down immediatly.

Any ideas, if there is a short fix on this problem? I'm "studying" a mysql
tutorial or howto, but this will also take a lot of time.

Thanks in advance for replies!
- Stephen
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-19-2008, 01:31 PM
Stephen L.
 
Posts: n/a
Default Canceling request for help - Re: MySQL shuts down immediatly after (automated) start


Hello, problem is solved by google'ing in the history of this group! There
was the same problem, just I had to use the wrong key words on my first
search.

The problem seems to be solved.

If anybody is interested, read this:

http://groups.google.de/groups?q=%22...ews.com&rnum=1

- Stephen

On Sun, 11 Jul 2004 13:05:06 +0200, Stephen L.
<usenet.slackware@secondimpact.de> wrote:

> Hello!
>
> I am NOT familiar with MySQL, so I try to use the dumb-people-method of
> installing the packet from Slackware 9.1, enabling the rc.mysql in
> pkgtool / Setup / Services option, or, executing "# /etc/rc.d/rc.mysql
> start" manually.
>
> I always ends up like this:
> --- Quote Start ---
> bash-2.05b# /etc/rc.d/rc.mysqld start
> bash-2.05b# Starting mysqld daemon with databases from /var/lib/mysql
> 040711 12:57:43 mysqld ended
>
>
> bash-2.05b#
> --- Quote End ---
>
> Maybe the problem is a missing MySQL Database (Who can tell, there is no
> more output, and I couldn't find a corresponding log file)...
> ... but I wanted to create a Database from within an external
> application like Prokyon3 (http://prokyon3.sf.net).
>
> I also run mysql_install_db (seemingly) succesfully, but no chance to
> run mysqld without having it shut down immediatly.
>
> Any ideas, if there is a short fix on this problem? I'm "studying" a
> mysql tutorial or howto, but this will also take a lot of time.
>
> Thanks in advance for replies!
> - Stephen


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-19-2008, 01:31 PM
Jack Strangio
 
Posts: n/a
Default Re: MySQL shuts down immediatly after (automated) start

"Stephen L." <usenet.slackware@secondimpact.de> writes:
> bash-2.05b# /etc/rc.d/rc.mysqld start
> bash-2.05b# Starting mysqld daemon with databases from /var/lib/mysql
> 040711 12:57:43 mysqld ended


Check ownership of /var/lib/mysql. It should be mysql:mysql.

Easy way to make sure, as root:

chown -R mysql:mysql /var/lib/mysql


Jack
--
Once, they feared you. Then they matched you. Now they are
laughing at you. Soon they will ignore you. You have lost.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-19-2008, 01:32 PM
Vigil
 
Posts: n/a
Default Re: MySQL shuts down immediatly after (automated) start

On Sun, 11 Jul 2004 13:05:06 +0200, Stephen L. wrote:

> bash-2.05b# /etc/rc.d/rc.mysqld start bash-2.05b# Starting mysqld daemon
> with databases from /var/lib/mysql 040711 12:57:43 mysqld ended


There are instructions in /etc/rc.d/rc.mysqld for first-time running.

--

..

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 02-19-2008, 01:32 PM
slacker
 
Posts: n/a
Default Re: MySQL shuts down immediatly after (automated) start

Vigil wrote:
> On Sun, 11 Jul 2004 13:05:06 +0200, Stephen L. wrote:
>
>
>>bash-2.05b# /etc/rc.d/rc.mysqld start bash-2.05b# Starting mysqld daemon
>>with databases from /var/lib/mysql 040711 12:57:43 mysqld ended

>
>
> There are instructions in /etc/rc.d/rc.mysqld for first-time running.
>


run "mysql_install_db" to setup the database, then run "cd
/var/lib/mysql/;chown mysql:mysql * -R" so the permissions are set
correctly. from here "mysqld_safe &" runs perfectly for me (slack10).
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:07 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com