LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
LinkBack Search this Thread
Old 01-05-2006, 12:22 PM   #1
prasanta
Member
 
Registered: Mar 2005
Location: India
Distribution: Debian
Posts: 368

Rep: Reputation: 37
mysql server does not start up


Hello,

Wanted to install mysql for media wiki. Was unable to get mysql running. I am posting the errors that I am getting.

Code:
prasanta@gbook:/var/lib$ sudo mysqld type
Password:

InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html
051019 10:25:15 Can't init databases
051019 10:25:15 Aborting

051019 10:25:15 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
051019 10:25:15 mysqld: Shutdown Complete
/var/lib/mysql/mysql/ is empty.

Output from mysql_install_db

Code:
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)
ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)
ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)
ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)
ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)
ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)
ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)
ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)
....
....
Mysql restarts says the following.

Code:
prasanta@gbook:/var/lib$ sudo /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
The syslog also says the same thing.

I do not think permissions are the issue because I have even tried chmod 777 on the directory.

I have searched through the forum but was unable to get mysql running. Help.

Thanks

--
Prasanta
 
Old 01-05-2006, 12:32 PM   #2
onjoo
Member
 
Registered: Jan 2005
Location: Finland
Distribution: Suse 10, Suse-factory , RHEL4, SLES9, SLED10
Posts: 380

Rep: Reputation: 30
I guess you need to install mysql privilege tables.

Open console
Switch to superuser (with su or sudo or whatever you use...)
type: "cd bin"
type: "mysql_install_db --user=mysql"

simple "mysql_install_db" could also do the trick
 
Old 01-05-2006, 01:07 PM   #3
prasanta
Member
 
Registered: Mar 2005
Location: India
Distribution: Debian
Posts: 368

Original Poster
Rep: Reputation: 37
Thanks for the quick reply but that did not work. It gave me the same error.

--
Prasanta
 
  


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
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I start mysql server? barrythai Suse/Novell 4 04-05-2006 05:46 PM
Trying to start Mysql server number11 Linux - Newbie 3 06-06-2005 01:59 PM
MySQL server doesn't want to start AJ_Cantos Linux - Software 7 11-29-2004 04:24 PM
How to start mysql server krussell Linux - General 2 01-19-2004 10:24 AM
Mysql server will not start using OS Suse 8.1 steverino Linux - Software 3 03-06-2003 03:00 AM


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

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration