mysql-server-5.1.22 system administration docs on FreeBSD7.0-RELEASE-i386 ?

[freebsdemail at gmail.com]

Try adding mysql_enable="YES" to /etc/rc.conf after this is done try starting again via the rc script. In the future pass the parameter rcvar to the rc script.

Eg. /usr/local/etc/rc.d/mysql-server rcvar
mysql_enable="YES" this would indicate what to add to rc.conf


Sent from my BlackBerry device on the Rogers Wireless Network

-----Original Message-----
From: "David Christensen" <dpchrist at holgerdanske.com>

Date: Tue, 26 Aug 2008 21:57:10 
To: <freebsd-questions at freebsd.org>
Subject: mysql-server-5.1.22 system administration docs on FreeBSD
	7.0-RELEASE-i386 ?


freebsd-questions:

I am a FreeBSB noob who has read http://nostarch.com/abs_bsd2.htm and is
attempting to build a FreeBSD 7.0 box for Apache/ MySQL/ Perl applications.
I've installed mysql-server-5.1.22 via sysinstall from ftp1.us.freebsd.org, but
I am unable to figure out how to start it.


RTFM:

    # man mysqld
    No manual entry for mysqld

    # makewhatis

    # apropos mysql
    mysql: nothing appropriate

    # whatis mysql
    mysql: nothing appropriate

I don't understand why apropos and whatis can't find mysql:

    # man mysql


Yup, it's there; but that's the client.  So is the admin utility:

    # man mysqladmin


The FreeBSD Handbook doesn't mention mysql in the TOC:

    http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/index.html

(Attempting to get the whole thing as HTML locks up my browser.)


The mailing list archives didn't help.  (Including using Google with site:).


STFW led me to /usr/local/etc/rc.d/mysql-server.  Attempting to use that:

    # /usr/local/etc/rc.d/mysql-server start

    # ps -a | grep mysql

    # mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

    # mysqladmin ping
    mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(2)'
    Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!


I've been fumbling my way around FreeBSD, and thus far have been able to get
things working via /etc/rc.d/* scripts and/or /etc/rc.conf --  (apache_enable,
hostname, ifconfig_*, defaultrouter, ntpd*, inetd.   mysql-5.1 doesn't seem to
follow the pattern.  Why?


Where is the FreeBSD 7.0 system administration documentation for mysqld 5.1?
Specifically, how to start it manually and how to start it at book via the rc
system?


TIA,

David

_______________________________________________
freebsd-questions at freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"