Re: OT: Getting started with MySQL

["Sancho2k.net Lists" <lists@sancho2k.net>]

Richard P. Koett wrote:

> Dear misc:
> 
> I have never done anything with MySQL before. Now I need it to support
> some other software so I started like this (from 3.3 CD):
> 
> pkg_add mysql-server-3.23.55.tgz
> 
> As expected the package install concluded with some hints about things
> that need doing. I am finding out that a lot more is needed besides
> those hints.
> 
> So far I have copied my-small.cnf to /etc/my.cnf and tried running
> /usr/local/share/mysql/mysql.server start which results in "Can't start
> server: Bind on unix socket: Permission denied".
> 
> I'm finding the included documentation hard to follow. There is a lot of
> Linux and other stuff in there, along with references to stuff I can't
> even find like "mysql_install_db".

This installs the default database 'mysql' which is already done for you 
by installing the package.

> 
> Would anyone care to recommend a some good resources where I can learn
> how to get a simple install of MySQL running on OpenBSD?

I'm partial to a howto I wrote a while ago. It could use some updating 
but is generally good to follow:

http://www.sancho2k.net/filemgmt_data/files/mysql_notes.html

DS