On Mar 16, 2005, at 12:56 AM, Ted Zeng wrote:
I set the username to root. That should be enough, I assume.
There's no need to guess, or to make assumptions - The tests, if they fail to log in, will explicitly say so, and display the username and host that they tried, and whether or not a password was used.
I didn't do the grant stuff.
It's been ages since I started with a brand-new clean MySQL install, and I can't recall what the default permissions are for the root user. If I remember right, only "[EMAIL PROTECTED]" is allowed to log in without a password. When MySQL fetches the host name of your Mac, it gets the Rendezvous name instead of 'localhost' - something like "computer-name.local.".
So, you do need to do the "grant stuff". It's a good idea to learn at least the basics of MySQL access authorization anyway. It's not just for security - you'll also want to create users to use when running your scripts. That will limit the damage a script in development can do; you don't want a buggy script going medieval on the system tables.
sherm--
Cocoa programming in Perl: http://camelbones.sourceforge.net Hire me! My resume: http://www.dot-app.org