Posts

Showing posts from May 17, 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 make 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 pass