Trouble starting MySQL [SOLVED?]

Andy Firman andy at firman.us
Wed Jan 12 06:15:34 PST 2005


On Wed, Jan 12, 2005 at 11:33:21AM +0100, Colin J. Raven wrote:
> On Jan 12 at 11:17, Colin J. Raven launched this into the bitstream:
> 
> > On Jan 12 at 09:35, Walker, Michael suggested:
> >
> >>
> >> I installed MySQL from ports (mysql-4.1.7)
> >> then tried to start it. Nothing doing - wo way.
> >>
> >> Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No
> >> error message is emitted, but no running instance of mysql either.
> >>
> >> <snip>
> >>
> >> Read /usr/loca/etc/rc.d/mysql-server.sh you now have to start mysqld from
> >> your rc.conf file.
> >>
> > OK, I added the necessary stuff to /etc/rc.conf and attempted to start
> > mysql via the mysql-server.sh script. Nothing doing.
> >
> > I rebooted the box, checked to see if mysql was running. It wasn't.
> >
> > I attempted once more to start it from the script - Nothing.
> >
> > OK, I'm back to where I started.
> 
> BUT
> I pulled up webmin | Servers | MySQL Server  adjusted paths to where 
> stuff lives, hit "Start MySQL Server" and seemingly MySQL is now running.
> To wit:
> 
> root     1329  0.0  0.1  1652 1208  ??  I    11:26AM   0:00.01 /bin/sh 
> /usr/local/bin/mysqld_safe --user=mysql
> mysql    1347  0.0  2.5 55852 25832  ??  S    11:26AM   0:00.14 
> /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/
> colin    1359  0.0  0.1  1476  896  p2  S+   11:26AM   0:00.00 grep 
> mysql
> 
> Good, but I'm just puzzled why/how this worked from webmin. It doesn't 
> make sense. One thing, it started mysql as can be seen above from 
> /usr/local/bin/mysqld_safe, which sure 'aint the script way.
> 
> Then again, the "script way" from CLI didn't work.
> 
> <sigh>

I hear your frustration.  I was asking about this on Dec. 18, 2004
and I did not get any answers.  Look at this:
http://lists.freebsd.org/pipermail/freebsd-questions/2004-December/068425.html

I am still confused about /usr/local/etc/rc.d vs /etc/rc.conf.

Can anyone educate us how this works on FreeBSD 4.10?

I have nothing in rc.conf pertaining to mysql, but the mysql server
starts just fine when I boot my FreeBSD 4.10 stable box?

mysql-server-4.0.21 installed from ports.


More information about the freebsd-questions mailing list