All databases are visible !

[Line Yoble]

Hello,

From the DA reseller panel, I have created a new user 'foo' with its own domain 'foo.com'.
When I log to this user's panel (login 'foo') and click on the phpMyAdmin link, I have access to all databases : I can manage all content of all databases.

How can I prevent this user to access the other databases (when I go to the phpMyAdmin privileges pages, 'foo' is not listed) ?

Thanks.

Line.

 

[scsi]

What do you see when you check the mysql.user table in mysql.

mysql -u root -p

mysql> select * from mysql.user where User='foo';

Do all the fields have a Y or do they have an N?

 

[Line Yoble]

Under phpMyAdmin, I have executed your request on the 'mysql' database, and there is absolutely no record for the user 'foo'.

So, I have created a new user with a new database (name 'foo', too) with all rights on this database and no rights on other databases.
But when I connect with this user name, I can see the 'foo' database but also the 'information_schema' database, and no one else.
How can I hide this last database ?

 

[scsi]

Then I am not sure...

Ask directadmin for assistance.

https://www.directadmin.com/clients/safesubmit.php

 

[Line Yoble]

Thanks for your answer.
I'll ask the DA support.

 

[LawsHosting]

I can see the 'foo' database but also the 'information_schema' database, and no one else.

I thought this was normal?

 

[Line Yoble]

May be it is normal, I dont know.
This database content seems to be readonly.

But since my last message I have learned how to hide it from the list of databases (but not preventing it from being accessed) by modifying the phpMyAdmin config file.