MySQL and Tiger
OS/X Tiger Server comes with a reasonably current version of MySQL bundled and nicely integrated. Right now it seems to be about one minor release behind the latest from the MySQL site.
Unfortunately, if you simply fire up the MySQL administrative console, set a password and start MySQL — you won’t be able to do anything. You’ll get a message to the effect of access is denied for ''@'localhost' for just about any operation you attempt. This is probably a configuration oversight on Apple’s part and will hopefully be fixed soon; in the meantime, you can solve the problem by creating a ”root“ account / password combination, as follows:
mysqladmin -u root password your_password_here
Once established you can then connect to MySQL as the ”root“ user and create databases, grant rights and perform other administrative tasks.
But you’ll probably want to forego the command line interface in favor of the (fairly new) MySQL Administrator application. You’ll find version for most platforms, including OS/X, on the MySQL site. MySQL Administrator provides all of the management tools you’ll need, as well as database health reporting, log monitoring and schema inspection.
