MySQL

BoonZie · 01-16-2003, 05:44 PM

HI
I'm trying to get MySQL to run on my server, but when I try to start the daemon (safe_mysqld) it starts with the right path to the databases, but stops immediately again wit the following err-log:

030115 23:27:02 mysqld started
030115 23:27:02 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
030115 23:27:02 mysqld ended

The file host.frm exists, and I have given it chmod 777. I try to start the daemon as root.

I have read that to start and stop MySQL automatically, you could add mysql.server start, and mysql.server stop to the appropriate rc.* files, but witch files are the right ones?

hanzerik · 01-17-2003, 08:23 AM

Distro of Linux? Red Hat, Slackware, etc?

Astro · 01-17-2003, 09:59 AM

And did you install from source or did you use the one off the slack cd if it is slackware? (Assuming so since you posted here)

fskmh · 01-18-2003, 04:52 AM

Did you remember to do a "mysql_install_db" first?
Once you've done that you're supposed to check that the owner and group are mysql and the permissions should be 750, I think.

BoonZie · 01-20-2003, 01:25 AM

I installed from Slack 8.1 CD.
It seems like the problem was that mysql wasn't the owner of the datafiles from "mysql_install_db". This question seems to be solved.

How about the autostart? Anyone knows anything about that?

Tnx
BoonZie

Astro · 01-20-2003, 02:01 AM

This is what I put in my /etc/rc.d/rc.local file to start MySQL on boot...

Code:

# starting mysql -- astro
/bin/sh -c 'cd /usr/local/mysql ; ./bin/safe_mysqld --user=mysql &'

Keep in mind I installed mine from source.

AlleyTrotter · 01-20-2003, 12:23 PM

I use in rc.local

/usr/share/mysql/mysql.server start

AlleyTrotter

BoonZie · 01-21-2003, 01:32 AM

That seems good for starting mysql, but will it stop properly without any "stopscript". Have you had any problems with mysql if it just stops with the system?

AlleyTrotter · 01-24-2003, 12:04 PM

No problems shutting down mysql with the same script or with a reboot you get a message
mysql server shutting down

the regular slackware rc. whatever handles it no problem

AlleyTrotter

hing · 01-24-2003, 09:52 PM

i cant start mysql server in slackware 8.1 as well.
similar problem as yours.
can u supply me some hints on that? thx.

AlleyTrotter · 01-27-2003, 11:32 AM

This is how I got mysql to run, I got this info from some forum who I would like to credit but can't remember where

as root do the following

cd /usr/bin
su mysql
./mysql_install_db
exit

now set the mysql root password per on screen instructions.
then:

/usr/share/mysql.server start

now any user who is a member of the mysql group can run mysql by entering

mysql

AlleyTrotter

BoonZie · 01-28-2003, 05:41 PM

Well, I got my MySql to work finally. Thanks for your help.
Boon

qmon2002 · 02-02-2003, 11:18 AM

I was trying to follow the steps described in post #13, and I'm getting the following errror:

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)
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)
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)
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)

I'm using slackware 8.1 and mysql from the cd.

Help is much appreciated

BoonZie · 02-02-2003, 04:33 PM

When I got the (errno: 13)-code, it turned out that the owner of the databasefiles for MySQL was root, and not mysql.This caused my problems.
I logged in as root, and run mysql_install_db, then I changed the owner of the db-files with "chown -R mysql /var/lib/mysql/mysql". That worked for me, maybe it will work for you to?
Good Luck

MaDluvBxX · 03-11-2003, 05:32 AM

almost same problem here
here it is what I did:
(small note, I was logged as root)

Code:

cd /usr/bin
mysql_install_db
/usr/bin/mysqladmin -u root -p password mypass

Since I'm a

to be absolutely sure I-ve also did

Code:

/usr/bin/mysqladmin -u root -h Silver_Fang -p password mypass

and the shell returns:

Code:

/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!

then I tryed to start mysql service with the usual

Code:

safe_mysqld

and in the log appeared

Code:

030311 11:45:08  mysqld started
030311 11:45:08  /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
030311 11:45:08  mysqld ended

anything I forgot?