Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 5 Jul 2007 13:51:40 +0200
From:      "Johan Hendriks" <Johan@double-l.nl>
To:        <bob@a1poweruser.com>
Cc:        freebsd-questions@freebsd.org
Subject:   RE: How does one start mysql after installing from ports
Message-ID:  <57200BF94E69E54880C9BB1AF714BBCB19BB73@w2003s01.double-l.local>
References:  <NBECLJEKGLBKHHFFANMBAEIJCEAA.bob@a1poweruser.com>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help


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

>Add this to /etc/rc.conf to direct to use location where there is a =
large
>enough free disk space
>to hold your databases
>mysql_dbdir=3D"/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

Better is to use /usr/local/etc/rc.d/mysql start cq stop

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

If you did use /usr/local/etc/rc.d/mysql start, the above is not needed, =
it will do it automaticly if it does not find any database at startup.

>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

=20

No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.476 / Virus Database: 269.10.0/886 - Release Date: 4-7-2007 =
13:40
=20



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?57200BF94E69E54880C9BB1AF714BBCB19BB73>