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

[joeb]

To autostart mysql at boot add this to /etc/rc.conf
mysql_enable="YES"

Add this to /etc/rc.conf to direct to use this location where there is disk
space
to hold your databases
mysql_dbdir="/usr/local/mysql"

To start or stop mysql server do this
/usr/local/share/mysql/mysql.server start
/usr/local/share/mysql/mysql.server stop

You have to tell mysql to create its internal control db
by running this command one time first before trying to create databases.
mysql_install_db --user=mysql

To verify mysql is operational issue these commands
mysqladmin version
mysqladmin variables

To start command line session with mysql server to
create a DB enter
mysql -u root

The online mysql manual is at
http://dev.mysql.com/doc/refman/5.0/en/index.html

The mysql databases and log files are written here
/var/db/mysql

-----Original Message-----
From: owner-freebsd-questions at freebsd.org
[mailto:owner-freebsd-questions at freebsd.org]On Behalf Of David Christensen
Sent: Thursday, August 28, 2008 1:47 PM
To: freebsd-questions at freebsd.org
Subject: RE: mysql-server-5.1.22 system administration docs
onFreeBSD7.0-RELEASE-i386 ?

Fraser Tweedale wrote:
> put the following line in /etc/rc.conf:
>     mysql_enable="YES"
> and run (as root):
> /usr/local/etc/rc.d/mysql-server start

    # echo 'mysql_enable="YES"' >> /etc/rc.conf

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

    # mysql
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 1
    Server version: 5.1.22-rc FreeBSD port: mysql-server-5.1.22

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql>

Ahhh -- much better.  :-)


The explanation is here:


http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/configtuning-rcd.h
tml

    Since the rc.d system is primarily intended to start/stop services
    at system startup/shutdown time, the standard start, stop and
    restart options will only perform their action if the appropriate
    /etc/rc.conf variables are set. For instance the above sshd restart
    command will only work if sshd_enable is set to YES in
    /etc/rc.conf. ...


freebsdemail at gmail.com wrote:
> 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

    # /usr/local/etc/rc.d/mysql-server rcvar
    # mysql
    mysql_enable=YES

The explanation is here:


http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/configtuning-rcd.h
tml

    It is easy to check if a service is enabled in /etc/rc.conf by
    running the appropriate rc.d script with the option rcvar. Thus, an
    administrator can check that sshd is in fact enabled in
    /etc/rc.conf by running:

    # /etc/rc.d/sshd rcvar
    # sshd
    $sshd_enable=YES


Thanks!

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"