Back to the sea ; the relational database management system (RDBMS), episode VI

At least my Web 2.0 application (aka WordPress) requires a database system.
I’m used to using MySQL and that’s what I installed on my OpenBSD server.


MySQL is available as a binary package:

# pkg_add
mysql-server-5.1.48:p5-Net-Daemon-0.43: ok
mysql-server-5.1.48:p5-PlRPC-0.2018p0: ok
mysql-server-5.1.48:p5-DBI-1.609: ok
mysql-server-5.1.48:mysql-client-5.1.48: ok
mysql-server-5.1.48:p5-DBD-mysql-4.014: ok
mysql-server-5.1.48: ok
--- +mysql-server-5.1.48 -------------------
You can find detailed instructions on how to install a database
in /usr/local/share/doc/mysql/README.OpenBSD.
# /usr/local/bin/mysql_install_db
Installing MySQL system tables...
Alternatively you can run:

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems with the /usr/local/bin/mysqlbug script!
# vi /etc/login.conf
# cap_mkdb /etc/login.conf
# vi /etc/rc.local
if [ -x /usr/local/bin/mysqld_safe ] ; then
        echo -n ' mysql'
        su -c mysql root -c '/usr/local/bin/mysqld_safe >/dev/null 2>&1 &'
# su -c mysql root -c '/usr/local/bin/mysqld_safe >/dev/null 2>&1 &'
# /usr/local/bin/mysql_secure_installation
All done!  If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!

That’s All Folks!

1 Comment

  • Back to the sea ; the OpenBSD services, episode I | TuM'Fatig Fri, 14 Jan 2011 21:48:14 +0000 Reply

    […] the relational database management system (RDBMS) […]

Leave a Reply

Your email address will not be published. Required fields are marked *


%d bloggers like this: