A few days ago I tried installing WordPress on our MySQL 3.23.54 and ran into problems almost immediately. Using phpMyAdmin, I create the blog database, create a new user called 'blogger' (who can log in from any host), give him a password, reload the server, grant him a couple of permissions (just general permissions now, to make sure it works), reload the server then log out and try to log in as this 'blogger' and can't log in.
After running into this problem, I tried following the MySQL terminal directions on the installation page, but once it was done I was still unable to log in and 'blogger' didn't even show up on the users table when I looked at it with phpMyAdmin.
I have a feeling this problem might have a really simple solution, but I'll be damned if I know what it is. Can anyone offer a better idea of what I'm doing wrong?