Prerequisites:      FreeBSD 7.1-REL

MySQL database is used everywhere. You can read more about it by visiting http://www.mysql.com/.

This tutorial installs build version 5.0.x

Install MySQL via ports:

prompt# cd /usr/ports/databases/mysql50-server
prompt# make install && make clean

Note: for future:
************************************************************************
Remember to run mysql_upgrade (with the optional --datadir=<datadir>
flag) the first time you start the MySQL server after an
upgrade from an earlier version.
************************************************************************

Reboot the machine: <-- Old lingering windows habits never die..

prompt# reboot

Start MySQL:

prompt# /usr/local/etc/rc.d/mysql-server start

Secure MySQL root user account and delete nameless user(s):

prompt# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_mysql_root_password') WHERE User='root';
mysql> DELETE FROM user WHERE User='';
mysql> FLUSH PRIVILEGES;
mysql> quit

Add mysqld to system startup:

prompt# echo 'mysql_enable="YES"' >> /etc/rc.conf

All done. Good Luck.

Ren

Originally all Howto, config, setups, and supporting documentation was researched and compiled so we could find working solutions for our particular environment. We primarily run and develop FreeBSD 7.2, 7.1, and Mac OS X 10.6 Clients and servers. Check out the forums for any further help.

Thank You for visiting we hope you find this site useful in your network projects.