Distributed Software Systems LLC

Create New Database
create database <database>;

Create Administrator Account
grant all on <database>.* to ‘<user>’@'localhost’ identified by ‘<password>’;

Reset Privileges
flush privileges;

Install Package
pkg_add -v ftp://ftp.openbsd.org/pub/OpenBSD/4.0/packages/i386/mysql-server-5.0.22.tgz

Start Service And Set Root Password
/usr/local/bin/mysqld_safe &
/usr/local/bin/mysqladmin -u root password ‘<password>’

Start Daemon on Server Startup, Add to /etc/rc.local
if [ -x /usr/local/bin/mysqld_safe ]; then
  echo ‘MySQL’
  /usr/local/bin/mysqld_safe &
fi