dump sql from 5.1 to on new server 5.5 permissions error

[Andrew]

Dumped db from a version 5.1 - restored to Ubuntu 14.04 with latest mysql 5.5

Using tomcat catalina to launch app. Write something to the DB, then get a permissions error for 'user'@'localhost' even though user has all privileges with grant option.

[Max Bubenick (max-bubenick)]

Did you check the mysql.users table on source and destination? Did you find a difference?

[Domas Mituzas (domas-mituzas)]

also, you need to run 'flush privileges'

[Andrew (am-public-o)]

I have checked mysql.users and it is different because I am using different passwords on the new server. HOWEVER, they are the same user names.

And yes I always remember to flush privileges.

There's one other thing I'll have to check with jdbc Driver to confirm whether this actually has to do with mySQL itself.

[Andrew (am-public-o)]

Just an update that this "bug" can be closed. Apparently it was an incomplete mySQL upgrade that was causing several issues, as well as this one.