Wesley's Tool-Box

You know, installing MySQL stumped me a lot in the past. I'm a little better at it now, hopefully. Let's dive in!

3. MySQL

Now we need another pillar to put up - a database engine. MySQL is a popular open-source choice for this and works with most of the solutions needing database functionality. Installation of MySQL completes are triple-module setup commonly referred to as "APM" (Apache-PHP-MySQL) or "AMP". Since it's installed on OS X, the whole server setup is called "MOXAMP" (Mac OS X-Apache-PHP-MySQL). Install on Linux and you have "LAMP". You get the idea. The APM setup is prequisite for a lot of dynamic website configuration: you have a web server (Apache) that accesses various database entries (MySQL) through scripting language (PHP), like a blog post.

Oh, yeah, the installation.

This article serves two purposes: to show what steps are needed to have a functioning website running on a Macintosh computer, and to remind myself not to forget how to do this later. Yes, I must be dumb.

Okay, you need:

- A Macintosh computer (mine is a Mac mini)
- Mac OS X 'Panther' 10.3.9 or higher (mine is running 'Tiger' 10.4.1)
- Internet connection (direct, or through a router that you can configure)

The phpBB forum system now has appopriate forums and topics created, as well as links that allows you to return here. Note that it's now called 'Wesley's Extended Forums' instead of 'Wesley's Experimental Forums'. I might need to replace the 'phpBB' logo on the top left, but only after the rest of the sites are moved out.

Let's see... for now I'm not doing Korean support on the site, but I saw that there was this multilingual plug-in. Maybe it could be feasible to support two languages on this site if this works as intended. But the encoding problem (apparently the 'English' setting corrupts Korean input, as noted eariler) must be resolved in the plug-in as well. I'll have to get around to this after getting the forums running.

Okay, so the transition is official as of now. Wesley's Tool-Box is now serving from this new website.
There is a link on the right that still takes you to the old pages, but all the contents are here, so that link's just for reference (well, it'll be taken down eventually anyway).

A few changes: the introduction and profile pages are available, as well as a page that lists all the articles. Also, I've applied the previous/next page plug-in so it's easy to navigate between several pages of the old articles. This plug-in had a bug where it kept pointing to the first post I wrote (the 'This is where it starts anew' one) for the 'next' post, so I had to dive into the code and fix (well, it works for me, anyway).

Alright, I think I should do something about the forums now.