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

joeb joeb at
Thu Aug 28 05:56:34 UTC 2008

To autostart mysql at boot add this to /etc/rc.conf

Add this to /etc/rc.conf to direct to use this location where there is disk
to hold your databases

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

The mysql databases and log files are written here

-----Original Message-----
From: owner-freebsd-questions at
[mailto:owner-freebsd-questions at]On Behalf Of David Christensen
Sent: Thursday, August 28, 2008 1:47 PM
To: freebsd-questions at
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.


Ahhh -- much better.  :-)

The explanation is here:

    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 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

The explanation is here:

    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



freebsd-questions at mailing list
To unsubscribe, send any mail to "freebsd-questions-unsubscribe at"

More information about the freebsd-questions mailing list