LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices

Reply
 
Search this Thread
Old 08-02-2010, 03:38 PM   #1
tamtam
Member
 
Registered: May 2004
Distribution: Slackware.
Posts: 314

Rep: Reputation: 30
mysql_install_db fail


Hi people,

Just done a clean install of Slackware 13.1.

Had trouble starting mysql. Been there before. I went through the usual routine. Created my.cnf. Ran install_db. Failed.

Okay, so following advice given in other posts with the same problem. I uninstalled mysql and reinstalled. Getting the same error...Tables creation fails..

Quote:
Installing MySQL system tables...
100802 21:29:36 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100802 21:29:37 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/db.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/db.frm' (errno: 13)
100802 21:29:37 [ERROR] Aborting

100802 21:29:37 [Note] /usr/libexec/mysqld: Shutdown complete


Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.

You can try to start the mysqld daemon with:

shell> /usr/libexec/mysqld --skip-grant &

and 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.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!
Anyone got any ideas...completely stumped on this one...

Just remembered to read rc.mysqld like I had done on numerous occasions before when installing slack..
Quote:
# Note that the mysql user must exist in /etc/passwd, and the created files
# will be owned by this dedicated user. This is important, or else mysql
# (which runs as user "mysql") will not be able to write to the database
# later (this can be fixed with 'chown -R mysql.mysql /var/lib/mysql').

Last edited by tamtam; 08-02-2010 at 04:06 PM. Reason: [SOLVED]
 
Old 08-03-2010, 01:08 AM   #2
EricTRA
Guru
 
Registered: May 2009
Location: Gibraltar, Gibraltar
Distribution: Fedora 18 with Awesome WM
Posts: 6,805
Blog Entries: 1

Rep: Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290
Hi,

Since you marked it as solved: Gone from the Zero Reply list.

Kind regards,

Eric
 
  


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
MySQL setup: I ran mysql_install_db ***without *** --user=mysql. slackmate Slackware 5 01-28-2010 05:54 PM
running mysql_install_db foampile Linux - Server 2 03-18-2009 10:38 AM
mysql - mysql_install_db (error) n0p.cracker Linux - Server 1 08-04-2008 12:23 PM
mysql mysql_install_db problems xrado Slackware 3 05-09-2006 01:10 AM
mysql_install_db hus Linux - Newbie 1 05-11-2005 12:33 AM


All times are GMT -5. The time now is 10:14 AM.

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