Tuesday, May 19, 2009

Installing MySQL v6 in FreeBSD

FreeBSD places its packages under /usr/ports/. Now for databases, types this command

cd /usr/ports/databases/mysql60-server

Then issue


after make, issue

make install

You can even specify it's configuration options like --prefix by doing "make install --prefix=/usr/local" where it will install the mysql packages.

This is applied also to the client package, just follow the steps how the server is being installed.

Create /var/db/mysql if that direcotry doesn't exist, then "chown mysql:mysql /var/db/mysql" and "chmod 770 /var/db/mysql" for security. Run the mysql_install_db command which will create default tables that mysql will used on its server process.

Run the mysql background process by issuing the command "/usr/local/etc/rc.d/mysql-server start" or perhaps it might be "/usr/local/etc/rc.d/mysql-server.sh start". I think older BSD preserves the .sh suffix on the start up scripts.

Don't forget to provide password to your root. Issue this command "mysqladmin -u root password egret" where "egret" is my database password, just an example.

Hope this helps!