The XAMPP project produces pre-configured webhosting packages based on Apache, MySQL, PHP, and Perl for Linux, Windows, Mac, and (early beta) Solaris. Once you have installed it, you have all you need to run a website, including a one using an SQL database, such as a blog, on your local computer, with all the different elements configured to work with each other.
It’s intended for development and testing, not for production. When it installs, it is completely without security and without password protection, though that can be changed.
After implementing the security, I used it to self-host my public website for three years (eventually, the site’s database outgrew the capabilities of my P4 server and I put it on GoDaddy).