Finally fixed 'bundled mysql.rb driver has been removed from Rails 2.2' issue

Well, I finally sorted out what the problem was that was causing the 'bundled mysql.rb driver has been removed from Rails 2.2' error. If you read back a few posts you'll see my saga of updating ruby from 1.8.6 to 1.8.7 and the issues it caused with my gems. Well, I fixed those for my user account, but not for when I used sudo--they give different lists of installed gems when I do 'gem environment'/'sudo gem environment'. Ran the old gem tool and got the same list with and without sudo. Hmmm. So I tried uninstalling/reinstalling the mysql gem with the old gem tool, and bam! problem solved.

Well, almost. After all the stuff I'd done I nuked all my mysql databases (no big deal, only dev/test data, and easy to restore with Rails migrations) but more importantly all my mysql users. So used the MySQL Administrator tool to add back my user, get the permissions set up correctly, and everything running again.

Well...almost. My app runs fine inside RubyMine, but doing script/server from Terminal still fails for some reason (and as far as I can tell, script/server doesn't have a 'verbose' option to give details). Whatever. If I can run it in RubyMine, I can work again. Woohoo!

Oh--and one other handy thing I found: Start and Stop MySql in Mac Os X 10.5 Leopard