LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 03-05-2004, 04:24 PM   #1
ilhbutshm
Member
 
Registered: Jul 2003
Location: Europe
Distribution: Slackware 10.2
Posts: 104

Rep: Reputation: 15
MySQL ended... wtf? :(


I installed MySQL according to the manual... everything went fine... now when I try to start it.. it wont work... pls help?

-------------------------
root@p166:/usr/local/mysql# bin/mysqld_safe --user=mysql &
[1] 593
root@p166:/usr/local/mysql# Starting mysqld daemon with databases from /usr/local/mysql/data
040305 22:34:04 mysqld ended
--------------------------

im losing my mind here... :|
 
Old 03-05-2004, 04:29 PM   #2
gregaryh
Member
 
Registered: Jan 2004
Location: Utah USA
Distribution: SuSE Pro 9.0
Posts: 43

Rep: Reputation: 15
What did you use to install? RPM, binaries from mysql.com, compiled from source?

If using RPM the install places the daemon startup in the /etc/init.d directory.
You can often start it using /etc/init.d/mysql start

Also what distro do you use? SuSE and Redhat both have admin panels that let you start and stop services.
 
Old 03-05-2004, 08:17 PM   #3
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
If your using slackware, you'll probably need to change the permissions.

Do this:

chown -R mysql.mysql /usr/local/mysql/data

And then try to start mysql.
 
Old 03-06-2004, 03:12 AM   #4
ilhbutshm
Member
 
Registered: Jul 2003
Location: Europe
Distribution: Slackware 10.2
Posts: 104

Original Poster
Rep: Reputation: 15
I'm on slack 9.1... i downloaded mysql-version-os.tar.gz and did this (from the manual):

--------------------------
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
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &
--------------------------

i get this:
--------------------------
root@p166:/usr/local/mysql# ./bin/mysqld_safe --user=mysql &
[1] 1040
root@p166:/usr/local/mysql# Starting mysqld daemon with databases from /usr/local/mysql/data
040306 09:33:26 mysqld ended
--------------------------

Last edited by ilhbutshm; 03-06-2004 at 03:23 AM.
 
Old 03-06-2004, 04:42 AM   #5
ilhbutshm
Member
 
Registered: Jul 2003
Location: Europe
Distribution: Slackware 10.2
Posts: 104

Original Poster
Rep: Reputation: 15
I just tried running /usr/local/mysql/bin/safe_mysqld again I have this in my machine.err file:
---------------------------------
040306 10:51:44 Can't init databases
040306 10:51:44 Aborting

040306 10:51:44 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
040306 10:51:44 /usr/local/mysql/bin/mysqld: Shutdown Complete

040306 10:51:44 mysqld ended
---------------------------------

then I tried runing /usr/local/mysql/bin/mysqld_safe and I got this

--------------------------------------------------------
040306 10:54:38 mysqld started
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
040306 10:54:39 Can't init databases
040306 10:54:39 Aborting

040306 10:54:39 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
040306 10:54:39 /usr/local/mysql/bin/mysqld: Shutdown Complete

040306 10:54:39 mysqld ended
--------------------------------------------------------

Why is this different than the mysql_safe? ... and what am I supposed to do? I cant find the file my.cnf... its not there...

Last edited by ilhbutshm; 03-06-2004 at 04:49 AM.
 
Old 12-09-2004, 08:48 AM   #6
pascalw
LQ Newbie
 
Registered: Dec 2004
Posts: 1

Rep: Reputation: 0
On my SuSE 9.0 box I accidentally ran the mysql_install_db script as root, which made /var/lib/mysql/mysql unaccessible by unix user mysql, and gave me the "mysqld ended" error on startup.

Issuing "chown -R mysql:daemon /var/lib/mysql" fixed the problem and I could then start with "/etc/init.d/mysql start"

Last edited by pascalw; 12-09-2004 at 08:50 AM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysqld error : 'mysql ended' anindyanuri Slackware 8 11-26-2005 12:14 AM
Fedora Core 3, MySql Server, mysql started mysql ended OkiTek Fedora 30 01-28-2005 10:15 AM
"mysqld ended" when trying to start mysql daemon guarriman Linux - General 1 01-19-2005 08:35 AM
Telnet Failed plus mysql ended ckamheng Slackware 2 12-09-2004 02:20 PM
Mysql ended BlackRabbit Linux - Software 2 10-25-2003 10:35 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:02 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration