I’m an admin for a MySQL database server, and today I needed to add a user account. I’m used to doing this using the commandline program or phpMyAdmin, but today I thought “let’s use the nifty MySQL Administrator for Mac,” a GUI tool, very much point-and-click and supposedly easy to use.
Or so I thought. For creating a user, you need to fill in, of course, username and password. When you want to save that, you get notified that you need to add a hostname for the user, first. That makes sense, because in MySQL, a user consists of a username and a hostname. So I press the tiny icon that seems to mean “add host”. Wrong, MySQL admin tells me. I need to save the properties of this user before I can add a host. Allright, but I just tried that.. but whatever. Pressing Save again.. wrong again! Need to add a host first.
As you can see, I can fill my day with this. The MySQL Administrator is no good. Back to the drawing boa.. eh, the commandline tool. At least those things always work.
The new Ubuntu is out. It’s version 6.06 LTS, in which LTS stands for Long Term Support. For desktops, this means that for 3 years, packages wil be kept up-to-date with security patches. For server users this is 5 years.
I run a few Ubuntu machines myself. Some desktops, some servers. My desktop PC at home was the first one. It started with Ubuntu Hoary, now runs Breezy and in a few days or weeks, when I have time, it will be upgraded to Dapper, which is the code name for 6.06.
Ubuntu is easy to use, based upon Debian, which rocks, and alltogether a great platform for any desktop or server. Really. You should try it!