-
Getting Mysql to start in slackware
I'm having a little trouble getting mysql to start automatically in Slackware 11.0. During the install I selected the option to have mysql start automatically. Now when I boot slackware it states the the mysqld daemon is starting but then I get this message.
STOPPING server from pid file /var.run/mysql/mysql.pid.
I read the comments in rc.mysqld and did exactly what the file said and still I can't get mysql to start.
Any advice would be welcomed
If you don't know your rights you don't have any......Irv Homer radio talkshow host Irv homer archives
Sabayon 3.4E
kernel 2.6.22
KDE 3.5 with Beryl
X.org 7.2
Asus M2N-SLIDelux
2 Gig Ram
hda 60 gig WD Hard Drive
sda 320gig WD Hard Drive
sdb 80gig WD Hard drive
ASUS EN7600GS Silent
member of the justlinux folding@home time
-
Try deleting the mysql.pid and then restart the service.
-
There is no pid to delete.
If you don't know your rights you don't have any......Irv Homer radio talkshow host Irv homer archives
Sabayon 3.4E
kernel 2.6.22
KDE 3.5 with Beryl
X.org 7.2
Asus M2N-SLIDelux
2 Gig Ram
hda 60 gig WD Hard Drive
sda 320gig WD Hard Drive
sdb 80gig WD Hard drive
ASUS EN7600GS Silent
member of the justlinux folding@home time
-
It looks like slackware's init is indeed attempting to start MySQL at startup, but MySQL is failing to start. Most likely due to something inane like bad file permissions on the data directory, or whatever.
Try running mysql's init script by hand [ probably something like /etc/rc.d/rc.msyql ] and see if the same thing occurs. I'm betting it probably will. After that, find out where mysqld is putting it's log file. Chances are it's somewhere under /var/log, or it might be in mysql's datadir under hostname.log.err or something like that. As a last resort you can look at /etc/my.cnf and see if log-err=/path is specified anywhere in there. Look at the log and it will explain why mysqld is failing to start.
"There's a big difference between "copy" and "use". It's exatcly the same
issue whether it's music or code. You can't re-distribute other peoples
music (becuase it's _their_ copyright), but they shouldn't put limits on
how you personally _use_ it (because it's _your_ life)."
--Linus Torvalds
-
I have posted this earlier (I'm too lazy to look for it, so I will write it again)
If mysql attempts to start at boot but it errors out then you have to run the db script first. If not, use pkgtool to start the mysql service at boot.
So, if mysql service is attempting to start at boot , but it fails , you do this :
as root : mysql_install_db
as root : chown -R mysql.mysql /var/lib/mysql
as root : /usr/bin/mysqld_safe --user=mysql & (this will start the daemon safe)
open another terminal to check if is running and issue ps -e | grep my. Now it's time to connect for the first time if you see mysql running :
mysql -u root
If you have a mysql prompt , then everything is fine an dandy and you will have to go on configuration (change password for root etc)
_________________________
Registered Linux User #314213
_________________________
Desktop 1 : P4 3.2G HT 2GB TWINX CORSAIR 2X120GB S-ATA NV7800GT- Ubuntu 7.04 - Feisty Fawn
Desktop 2 : P4 2.4G 512MB SDRAM 60GB IntelGMA - Slackware 11 - Fluxbox
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|