v2.5



  home nerd inside pictures projects ascertain Click here to maximize viewing area when viewing pics.  

CONTACT
ASCERTAIN | Installing MySQL on OpenBSD 3.4
LINKS
Recent: (2 days)
Random Pics:

  
  
  
Search anoop.net

Google Powered
[ less ] [ edit ] [ + ]
Installing MySQL on OpenBSD 3.4
This little guide will help to install MySQL on OpenBSD. I had a little bit of trouble with it and decided to write it down incase I ever had to do it again and just completely forgot how to do it.

The last time I used this process was on OpenBSD 3.4 so as future versions are released, I will try to keep this page updated.

For this install, we will use the ports tree. To learn more about the OpenBSD ports tree, visit http://openbsd.org/ports.html.

Once you've installed OpenBSD and downloaded the ports tree, follow these steps and you'll have MySQL installed.

# cd /usr/ports/databases/mysql
# make && make install

This step will only install the mysql client on your machine. I wondered at first as to why only the client was installed and my guess would be that many people may want to only install the mysql client and not the server on their machines. The server package is actually downloaded to the system but just not installed. It actually exists in /usr/ports/packages/ARCH/all/ where ARCH is your architecture (sparc64, i386...).

so

# cd /usr/ports/packages/ARCH/all/
# pkg_add mysql-server-3.23.x.tgz

In some cases, you will see this error. I however have always incurred this error.

pkg_add(mysql-server-3.23.49): add of dependency `p5-DBI-1.21' failed!
pkg_add(mysql-server-3.23.49): add of dependency `p5-DBD-Msql-Mysql-1.22.19' failed!

This only means that the MySQL server installation failed because the two packages it needs are also not installed on the system.

To remedy this, simply

# cd /usr/ports/databases/p5-DBI/
# make && make install
# cd /usr/ports/databases/P5-DBD-Msql-Mysql/
# make && make install

This will install the two dependencies provided nothing else screws up.

Once this is done, simply go back to /usr/ports/packages/ARCH/all and pkg_add mysql-server-3.23.x.tgz and the server will be installed on your machine.

For further information on mysql because its beyond the scope of this document, consult www.mysql.com.

Needless to say, I'm not responsible for any damage incurred by following these steps. This is still something you are doing at your own risk.
   
[less] [edit]

View Anoop Bhat's profile on LinkedIn

Perry99.net
Ivan Mikan dot Com
Ela's Flickr Page
qOrbit Technologies
Club GP
Java.SUN.com
OpenBSD
ThinkGeek
Slashdot
Mozilla
7 Dove
php.net
MySQL
IBM
70 Years of Indian Cinema
T.M. Ramachandran





Design and implementation done by Anoop Bhat
Copyright © by Anoop Bhat 2010. All rights reserved.
Used to be powered by OpenBSD, PHP, MySQL, and The VI Editor. ADN recommends the use of Mozilla Firefox.
Now powered by Linux, PHP, MySQL, and The VI Editor.