How does one start mysql after installing from ports

[Johan Hendriks]

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