I’m not sure if this is something that some people had experienced as well, but in my case, it stole around 15 minutes of my work time just to figure out what’s wrong. Not much time maybe, but those precious minutes could have been spent for more productive or relaxing moments. 
I tried to install MySQL 5.5 on my Mac OS X Leopard by downloading the Mac package (.dmg) installer from the MySQL website and then installed in a breeze. It worked fine and a startup package was even included in the installer. So after setting things up and firing up my fresh DB server, I started importing some existing databases and users. When I thought that everything went well and tried connecting a DB user (e.g. testUser@localhost) to its corresponding DB (e.g. testDB) , I got an “Access denied” error. I checked everything especially the GRANT privileges and even re-installed several times the mysql_install_db script included with the installer just to make sure the proper GRANT tables and DB permissions had been set. After investigating for a while, I realized that testDB user is being logged in as an anonymous user thus it is being logged in as a user not authorized to access my testDB. Weird as it seems but instead of investigating more, I decided to just removed the default anonymous user account from MySQL and everything worked well.
I still haven’t got into the root of the problem as I am quite busy, but this is the first time I ever encountered this problem during my many years of experience with MySQL. I repeat.. it’s weird but true ..
Popularity: 5% [?]