I am using MySQL 5.5 on FreeBSD, and everything is operational and has been for some time. The only problem is, no DB users other than root can authenticate properly.
mysql Ver 14.14 Distrib 5.5.7-rc, for portbld-freebsd7.2 (i386) using 5.2
My primary method for adding users is by using phpMyAdmin. I have also tried using the command line. Either way, the users create just fine, but if I try mysql -u someuser -ppassword, it fails, even if I specify a DB that they have full access to (including GRANT even).
Because of this, I've been using the root login for everything, which is obviously a large security hole.
EDIT: I have flushed privileges multiple times with no luck. Below is output for show grants, I changed the real user/dbname pair to "someuser" here.
Grants for someuser@%: GRANT USAGE ON *.* TO 'someuser'@'%' GRANT ALL PRIVILEGES ON `someuser`.* TO 'someuser'@'%' WITH GRANT OPTION