A MySQL is running happily on a machine situated in a land far far away. I grant access to a user@machine_aaaaaa (grant select on db.* to ‘user’@'machine_aaaaa’ identified by ‘password’; flush privileges;), send an email to the user saying it should run fine and happily go off my way. Mistake!
It seems this user can’t connect to the mysql gets access
Access denied for user ‘user’@'machine_bbbbb’ (using password: YES)
Note that the machine the user is being seen from is totally different from the one I set up in the grant!! WHY?
run a reverse lookup on the ip of machine_aaaaa, turns out it shows machine_bbbbb. …[Read more...]