January 2010 Archives

Installed a new blog today! .. based on Movable Type 5.0, which was released yesterday (January 5, 2010). All new entries henceforth will be published there. This will therefore be the FINAL ENTRY for this blog (which contains nearly 200 entries).

See here » Ye Olde Rad Blog 4.

First entry from the new blog posted here » First Post with Movable Type 5.0

[ Older blogs » Ye Olde Rad Blog II .. and Ye Olde Rad Blog v1.0 ]

Test update to MySQL 5.1.51

Test Feb 14, 2017

I have something to show you. Something very exciting. Sexy, even. "What it is, Rad?" you ask, oozing with curiosity. "A picture of a European supermodel? Lying scantily-clad on the sandy beaches of St. Tropez?"

Sexy SwimsuitNo, my fellow technoluster. Something far more enticing. And seductive. See » HERE (.. but only if you're 18).

No, your eyes don't deceive you. That's right » a screen-shot from phpMyAdmin showing the tables of a MODx database using the UTF-8 character set and utf8_general_ci collation. Smokin', ain't it?

"But, Rad. I thought you said that was impossible?" It is! .. For mere mortals.

"How did you ever pull it off?" Well, I can tell you that banging my head against the wall produced only limited success. It may've even impeded the process. (I can't remember.)

To be honest, I'm not really sure WHAT the magic-bullet was. Cuz I made a number of changes (including enabling suPHP)  .. which I'll tell you all about. I learned a lot. But first, I need to take care of some biz .. and get some coffee. (Was up pretty late last night. Where did I put that Advil?)

Feliz año nuevo. Most Content Management Systems (such as Drupal & MODx) work in conjunction with (require) a database. So do blogs (such as Movable Type) & forums (such as SMF).

MySQL is the world's most popular database software for web-based applications (.. such as CMS's & blogs & forums). It's what I use. It's the only database system I've ever used.

cPanel / Web Host ManagerThe Rad VPS (« physically located downtown Chicago) uses the cPanel/WHM control panel to help administer the site. cPanel makes it stupid-easy to create a new MySQL database.

You simply » enter a descriptive name for your new DATABASE (such as » rad_modx) and click the button labeled 'Create Database.' cPanel talks to MySQL and creates the database for you. Viola! Done. Too easy.

To use your new DATABASE, you'll also need to create a USER (such as » rad_modx, conveniently same as the database_name). Give this USER a password and click the button labeled » 'Create User.' Voila! Done creating new USER.

Lastly you need to assign a particular USER to a particular DATABASE. You do this by selecting both from their respective drop-down menus (one lists all available DATABASES, the other all possible USERS) and clicking the button labeled 'Add.'

Then you assign to this USER the appropriate PRIVILEDGES (normally ALL) necessary to perform the database functions. Click the button labeled 'Make Changes' and you're done. Voila! As if this weren't easy enough, cPanel even has a wizard to walk you thru these steps.

MySQL Database ManagementSo, in order to configure a database to work with a particular web application (such as Drupal or MODx), you need 3 pieces of info:

  1. database_name
  2. user_name
  3. user_password

Couldn't be easier. Tho I sometimes forget the final step of actually assigning the USER to the DATABASE (after creating both). Creating new DATABASES is not something I do on a regular basis.

RADIFIED currently uses 5 databases. Three for the blogs » 1-each for the 3 different versions of Movable Type I have installed .. based on v263 (installed 2003), v335 (installed 2007) & v432 (installed 2008). Another for Drupal (2008). And 1 for MODx Revolution (beta5), which I installed a few days ago.

The Rad forum, which uses YaBB, doesn't use a database. (At least not yet.) Might be worth noting here that Movable Type, Drupal, MODx & YaBB are all OPEN SOURCE (better than free) .. as is MySQL.

While installing MODx a few days ago, I noticed they include an option to test your database connection & credentials .. to see if MODx can access it okay.

About this Archive

This page is an archive of entries from January 2010 listed from newest to oldest.

December 2009 is the previous archive.

Find recent content on the main index or look in the archives to find all content.