User cannot see databases in mysql workbench

Question

I'm trying to learn Spring Roo using this tutorial. So, what I did was:

• go to mysql workbench
• create a new schema called 'pizzashop'
• access localhost through the server administration account
• create a new user in 'users and privileges' with name 'pizzashop' and password 'pizzashop', and limit connectivity to hosts matching %

when I tried to connect to the server using this account I noticed that it couldn't see any database

I tried creating an entry in 'schema privileges' explicity allowing the 'pizzashop' user to see the 'pizzashop' schema, but it didn't work

Hope you can help me here. I don't know if it's a Workbench problem or a mysql problem.

Edit> Added to the User Accounts one more entry with the same characteristics as the other but with 'localhost' instead of %

Added to the schema privileges an entry saying host:localhost schema:pizzashop and all object and ddl rights (this is the only one I have for the pizzashop user)

Still, when I connect to localhost using the user pizzashop no schemas appear

Answer 1

Its a MySQL problem and faily common, % does not match localhost. Add an entry for user@localhost with the same permissions

http://bugs.mysql.com/bug.php?id=69570