I found a great resource here that walks you step by step through compiling and installing MySQL on a Mac from the source code:

http://hivelogic.com/articles/installing-mysql-on-mac-os-x/

And it just worked!

The nice thing about this approach is that you can install any future version of MySQL this way very reliably, simply by changing a few references in the instructions.

On Leopard:

1. Open the Directory Utility: In the Finder, navigate to the Utilities folder (tip: click on the desktop, hit Cmd+Shift+U).
2. Click on the padlock to allow edits.
3. Go Edit > Enable Root Password
4. Enter and re-enter your password.

The protected files on your system still won't be accessible via the Finder, and unless there is a setting I'm not aware of yet to enable that, the best way I've found so far to edit these files is by using TextWrangler, a free editor you can download here! Fire up TextWrangler and navigate to File > Open Hidden ...

You can also access them via the Terminal, if you like using the command line. I'm almost sure there must be a way to manipulate these files with a UI of some sort, but I haven't found that yet.

Logged into the site, found the file, right clicked on it to check the context menu and found a choice to edit the file in Dreamweaver (and others). It opened immediately in DW. I made my small change, saved it, and saw Transmit working behind the DW window. Sure enough, on save Transmit simply uploaded the file for me. Sweet. I like it already!