Date: Wed, 4 Jul 2007 21:37:49 -0400 From: "Bob" <bob@a1poweruser.com> To: "Andrew Falanga" <af300wsm@gmail.com>, "User Questions" <freebsd-questions@freebsd.org> Subject: RE: How does one start mysql after installing from ports Message-ID: <NBECLJEKGLBKHHFFANMBAEIJCEAA.bob@a1poweruser.com> In-Reply-To: <340a29540707041500g25289b6la1aec3340b5cd628@mail.gmail.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="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 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 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?NBECLJEKGLBKHHFFANMBAEIJCEAA.bob>