CocoaMySQL and MySQL 4.1

Was banging my head against a wall this afternoon, trying to troubleshoot a connection from the usually stellar CocoaMySQL and a new MySQL installation. Hours later and much consternation, turns out CocoaMySQL apparently won’t work with MySQL 4.1 or newer due to authentication issues. Feh. I do so love “issues.”

Anyhoo, removing 4.1.x and downgrading to 4.0.21 works, so if you happen to run into this problem, that’s the deal. There are other GUI clients available, though I haven’t tried those out. PHPMyAdmin is always an option, as is, of course, the CLI, which is quite easy to use if you’re comfortable in that environment.