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: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?57200BF94E69E54880C9BB1AF714BBCB19BB73>