DaemonForums  

Go Back   DaemonForums > FreeBSD > FreeBSD General

FreeBSD General Other questions regarding FreeBSD which do not fit in any of the categories below.

Reply
 
Thread Tools Display Modes
  #1   (View Single Post)  
Old 24th December 2008
rtwingfield rtwingfield is offline
Real Name: Ron Wingfield
Port Guard
 
Join Date: Oct 2008
Location: Little Rock, AR USA
Posts: 36
Question MySQL: How to start the mysqld

For some reason, the mysqld is not starting on my old FreeBSD v4.8 system (please, I know, I know . . .I should upgrade the box, but my world does not revolve around IT . . .I wear many hats ). It has been two years since I needed MySQL on the box. I have no idea what is missing. I have googled to no avail (between FreeBSD versions, Linux/RedHat, other "unixes", and (gast!) Windoze . . .the config's are mind boggling). My system does not have an /etc/my.cnf file. I've added a "mysql_enable="YES" to /etc/rc.conf , yet no daemon start ("ps x | grep mysql" returns zip.). I deleted the /tmp/mysql_sock that was last created in 2006 . . .thinking that it might be a legacy problem. Obviously, since the mysql server is not restarting, then the socket file is not recreated.

What to do
Reply With Quote
  #2   (View Single Post)  
Old 24th December 2008
phoenix's Avatar
phoenix phoenix is offline
Risen from the ashes
 
Join Date: May 2008
Posts: 696
Default

If it's installed via ports/packages, then have a look at /usr/local/etc/rc.d/mysql* to see what variable needs to be set in /etc/rc.conf. Set it, and then run the rc.d script.

Check /var/log/messages, dmesg, /var/log/mysql* to see if any error messages are shown. Double-check the permissions on /var/db/mysql/.
__________________
Freddie

Help for FreeBSD: Handbook, FAQ, man pages, mailing lists.
Reply With Quote
  #3   (View Single Post)  
Old 25th December 2008
Carpetsmoker's Avatar
Carpetsmoker Carpetsmoker is offline
Real Name: Martin
Tcpdump Spy
 
Join Date: Apr 2008
Location: Netherlands
Posts: 2,243
Default

Which version of MySQL are you using? FreeBSD 4 is no longer supported, so if you install a new version this probably won't work.
When checking out the ports tree with cvsup, use the RELEASE_4_EOL tag.

You can also try starting mysqld from the command-line, i.e.:
# mysqld_safe --user=mysql
__________________
UNIX was not designed to stop you from doing stupid things, because that would also stop you from doing clever things.
Reply With Quote
Reply

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Which is the best solution from start bsd.mp? aleunix OpenBSD General 18 4th May 2009 06:33 PM
Can start rtorrent like apache and mysql when system boot mfaridi FreeBSD Ports and Packages 0 26th November 2008 09:27 AM
MYSQL can't start "UNABLE TO LOCK disappearedng FreeBSD General 0 14th October 2008 02:01 AM
MYSQL HOW TO START disappearedng FreeBSD General 7 18th September 2008 09:48 AM
KDE wont start up dctr FreeBSD General 9 11th June 2008 05:59 AM


All times are GMT. The time now is 04:16 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick