Alright, I installed the MySQL PKG from pkg.nl.cobalt.com like everyone suggests. Now when I go to change the root password for MySQL I get the following error:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

How can I check if MySQL is running, what I should do to start it, and if it will automatically startup with the server is rebooted? I did a search on this board and didn't find any answers.

As root, type /etc/rc.d/init.d/mysql start

that will start MySQL and to stop it, type stop rather than start.

Hope this helps.

Oh ya and awesome website.. nice design.

Well someone said I should uninstall the previously installed instance of MySQL (I believe it was the client tools only) so I ran the uninstall script for the PKG. Now when I try to reinstall the MySQL PKG from pkg.nl.cobalt.com I recieve the error:

Problem installing package component: MySQL-3.22.32-1.i386.rpm

So descriptive...thank you Cobalt...

Well in case anyone really cares I got it to work. Apparently the previous installation was screwing things up. The uninstall was rather sloppy and left a bunch of RPM's installed. So I unpacked the PKG file to get the names of all the RPM files, then did rpm -e on each one. Then the PKG would install...

Now if I can only figure out how to use it...

Just change the root password for MySQL and setup phpMyAdmin to administrate it. That's what I did, and it works great.

http://www.phpwizards.net