joomla mysql cannot see database via workbench

We have a joomla site up and running using a user called 'product_joomla' and a database with the same name.

I am able to connect to the mysql server using the that user above and password.

But I can only see the 'information_schema' database. the user does not seem to have access to the joomla database.

But that does not seem to be the case becau开发者_StackOverflowse the joomla site is using the same user and is working.

I am total noob with respect to mysql and joomla.

I am accessing the mysql database remotely via mysql-workbench.

I cannot figure out why that user cannot see the joomla database via workbench.

---

Even though we changed the user to accept connections from anywhere (not just localhost) that never updated the actual permissions on the joomla database – users still only granted admin rights if that user logged in from localhost.

So, the website was working via localhost but I was not able to connect remotely.