pkg_add mysql-server
And then start the setup:
mysql_install_db
Because of how the chroot jails are setup, when creating users, grant them access from hostname ''127.0.0.1'' instead of localhost. This can solve some headaches involved when setting up a web server stack.