I Hosed mySQL, and Subsequently, My Sunday Evening
I can think of numerous other things I could have been doing this evening. But I just had to go and completely destroy the mySQL installation on my G5 this afternoon. I think I’ve reinstalled mySQL nearly 10 times. I’ve run shell scripts that erase everything for me so I can start over, only to fail again. I’ve dug into hidden files and folders to erase traces of old installations. I’ve tried to change permissions (don’t think I haven’t googled the heck out of this situation) only to have my shell tell me that it doesn’t understand what “chown” means. I’m not that much of a geek, but last I checked, that was a pretty common thing one might type in, so methinks something is really wrong with my machine. And if I’m in the bash shell, it doesn’t even understand what “sudo” means. This can’t be right. WTF.
I’m freaking pissed. Especially because I had it running before, and now I can’t remember why I was feeling feisty enough to mess with it in the first place. What the heck was I doing? Why?
If there’s one thing I dislike, it’s going to bed with something like this hanging over my head. This type of crap drives me insane. Not mySQL in particular, but anything. Problems. I enjoy getting things to work. I mean, I was able to get Rails running fine on my G5 last night - what could be so hard about getting mySQL running on it, when it has successfully run on it before? Maybe I have time for another attempt or two before turning in for a restless night’s sleep loaded with dreams of Terminal windows throwing endless errors.
UPDATE: I was using CocoaMySQL to try and connect to my new mySQL 4.1.15 install. Turns out that you can’t connect to mySQL versions 4.1 and higher with it. So here I am thinking that I couldn’t set a root user to save my life. If you still want to use this program with the higher versions of mySQL, you need to download a modified version of the program, which you can find here.
I had the same problem with cocoamysql and mysql 5. The solution I used to was to use the OLDPASSWORD() command to hash my mysql user passwords. Worked a charm.
# Sun, November 20 2005 @ 11:55 pm (3 years ago)
Thanks for the tip, Jeff. I solved it two ways. I got the modified version of CocoaMySQL, which works fine, and I also dropped some money on Navicat, which, although fairly expensive, works very, very well.
# Fri, November 25 2005 @ 1:36 pm (2 years, 12 months ago)
A coworker of mine has been raving about how great the Windows version of Navicat is, so maybe I’ll have to download the demo now that I’ve heard another opinion about it.
# Fri, November 25 2005 @ 10:39 pm (2 years, 12 months ago)
The structure and data syncing are worth the price of admission, in my opinion. Verrrrry handy!
# Sun, November 27 2005 @ 11:22 pm (2 years, 11 months ago)