So, one an older instance of mysql (3.23.58 to be exact) we recently came across a very odd permission problem which I haven’t encountered before. Basically I created a database and then granted all privileges on the database and any of it’s tables to a user on the localhost identified by a password.
MySQL:
- mysql> GRANT all PRIVILEGES on fakedb.* to fakeuser@localhost \
- identified BY ‘fakepassword’;
- mysql> flush PRIVILEGES;
All afternoon I was getting ERROR 1045: Access denied and it was really starting to annoy me. Of course, I just reset the password on the user and it works now. Not cool. Not cool at all. Maybe the database was just running too hot and needed time to cool off. Maybe it was the Flying Elves™.