joomla mysql cannot see database via workbench

Question

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 because 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.

CF_Maintainer · Accepted Answer · 2011-07-07 16:37:19Z

0

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.

answered Jul 7, 2011 at 16:37

CF_Maintainer

9732 gold badges12 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

joomla mysql cannot see database via workbench

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related