LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 12-26-2004, 09:01 AM   #1
Obscure
Member
 
Registered: Apr 2003
Location: Milan
Distribution: Slackware 10 / FreeBSD 5.3
Posts: 175

Rep: Reputation: 32
Problem on starting MySql Server


Hi

I'm trying to start mysqld on my Slackware 10 but it won't start!
I have installed MySQL from Slackware original pkg.

Code:
#mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/thor.pid
041226 14:30:26  mysqld ended
On logs I can see:
Code:
041226 14:17:58  mysqld started
041226 14:17:59  InnoDB: Started
041226 14:17:59 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
041226 14:17:59 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
041226 14:17:59 Aborting

041226 14:17:59  InnoDB: Starting shutdown...
041226 14:18:01  InnoDB: Shutdown completed
041226 14:18:01 /usr/libexec/mysqld: Shutdown Complete
I tried (logged as mysql user) to do mysql_install_db but I recive this errors:
Code:
mysql@thor:~$ mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
041226 14:54:44 /usr/libexec/mysqld: File './thor-bin.index' not found (Errcode: 13)
041226 14:54:44 Could not use thor-bin for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
041226 14:54:44 /usr/libexec/mysqld: Can't find file: './mysql/db.frm' (errno: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
041226 14:54:44 /usr/libexec/mysqld: Can't find file: './mysql/db.frm' (errno: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
041226 14:54:44 /usr/libexec/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
041226 14:54:44 /usr/libexec/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
041226 14:54:44 /usr/libexec/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
041226 14:54:44 /usr/libexec/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
041226 14:54:44 /usr/libexec/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
041226 14:54:44 /usr/libexec/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
ERROR: 1  Can't create/write to file './mysql/db.frm' (Errcode: 13)
041226 14:54:44 /usr/libexec/mysqld: Shutdown Complete


Somone should help me to make it start please?
Thank you very much
 
Old 12-26-2004, 09:31 AM   #2
thermite_1033
Member
 
Registered: May 2004
Location: Antwerp, Belgium
Distribution: slackware
Posts: 112

Rep: Reputation: 18
i had the same problem
just compile it yourself and the problem will go away

or try another package from linux-packages.net
 
Old 12-26-2004, 10:17 AM   #3
Obscure
Member
 
Registered: Apr 2003
Location: Milan
Distribution: Slackware 10 / FreeBSD 5.3
Posts: 175

Original Poster
Rep: Reputation: 32
SOLVED!!

It's a permission problem!!
As written in /etc/rc.d/rc.mysqld file you must do su - mysql etc... but as Patrick says few line below:
Code:
# Note that step one is becoming the mysql user.  It's important to do this
# before making any changes to the database, or mysqld won't be able to write
# to it later (this can be fixed with 'chown -R mysql.mysql /var/lib/mysql').
This fix my problem!!
Bye
 
2 members found this post helpful.
Old 09-05-2009, 12:29 AM   #4
gkernel
LQ Newbie
 
Registered: May 2009
Posts: 3

Rep: Reputation: 1
Thumbs up thanks

Quote:
Originally Posted by Obscure View Post
SOLVED!!

It's a permission problem!!
As written in /etc/rc.d/rc.mysqld file you must do su - mysql etc... but as Patrick says few line below:
Code:
# Note that step one is becoming the mysql user.  It's important to do this
# before making any changes to the database, or mysqld won't be able to write
# to it later (this can be fixed with 'chown -R mysql.mysql /var/lib/mysql').
This fix my problem!!
Bye
thanks very match for this help
cause you explain solutions for problem with sample way
 
1 members found this post helpful.
Old 09-05-2009, 08:24 AM   #5
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,791
Blog Entries: 1

Rep: Reputation: 414Reputation: 414Reputation: 414Reputation: 414Reputation: 414
I think what he means is that important parts of mysql may be in directories owned by root. Have a look in /var/lib/mysql and make sure that everything is owned by mysql:mysql. If you're not sure, running the chown statement in Patrick's comment will set up permissions properly.
 
  


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
problem starting MYSQL 4.0.1 rixride00 Linux - Software 2 04-06-2004 11:45 AM
mysql starting server landonmkelsey Linux - General 0 12-20-2003 10:20 AM
Starting Mysql server at booting time learner Linux - Software 2 09-22-2003 08:47 AM
MySQL server not starting bige Linux - Software 5 07-02-2003 07:19 PM
MySQL Problem starting server oulevon Linux - Software 1 12-07-2002 02:47 PM


All times are GMT -5. The time now is 10:24 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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration