Added 2007-08-10:
How to setup phpMyAdmin (Apache 2.2.4, MySQL Server 5.0.45, PHP 5.2.3, phpMyAdmin 2.10.3): http://caffetine.org/freebsd-amp.php
How to configure phpMyAdmin: phpmyadmin.html
Added 2005-03-31:
If you are on FreeBSD, ignore this tutorial.
Install MySQL from the ports collection instead.
At the time of this writing the port is in /usr/ports/databases/mysql40-server.
Just do the following:
cd /usr/ports/databases/mysql40-server
make install clean
/usr/local/etc/rc.d/mysql-server.sh start
Optionally, but highly recommended, is the phpMyAdmin web interface (it installs both Apache and PHP if missing, so it can take some time to build this port):
cd /usr/ports/databases/phpmyadmin
make install clean
/usr/local/etc/rc.d/apache.sh start
Point your browser to http://localhost/phpMyAdmin (don't be surprised if this link doesn't work at the time of reading!), enter with the root user and password, and you are ready to administrate your database in a very flexible manner.
Check out the tiny tutorial about adding a MySQL account from the command line.
Here goes the original tutorial (2002-08-18):
This is a MySQL install how-to.
Download the mysql tarball from www.mysql.com.
Install mysql:
# gunzip -c mysql-X.XX.XX.tar.gz |tar -xf -
# cd mysql-X.XX.XX
# ./configure
# make
# make check (this is optional)
# make install
Check the documentation (from the same directory):
# opera ./Docs/manual_toc.html
Install the grant tables (from the same directory):