How does one start mysql after installing from ports

Johan Hendriks Johan at
Thu Jul 5 12:15:01 UTC 2007

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

>Add this to /etc/rc.conf to direct to use location where there is a large
>enough free disk space
>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

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


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

More information about the freebsd-questions mailing list