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>
index | next in thread | previous in thread | raw e-mail
>To autostart mysql at boot add this to /etc/rc.conf >mysql_enable="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="/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=mysql 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 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.0/886 - Release Date: 4-7-2007 13:40help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?57200BF94E69E54880C9BB1AF714BBCB19BB73>