I've produced a person with this particular command

CREATE USER 'bean'@'localhost' IDENTIFIED BY 'password'; GRANT ALL ON databaseA.* to 'bean'@'localhost';

However, after i login as bean I can se information_schema and test databases. From the understanding, should not bean only able to seeing databaseA?

I additionally attempt to run use information_schema and apparently there's nothing preventing bean from doing this.

So, are information_schema and test available to every user?

FYI, the root user includes these default tables: information_schema, mysql, test. Company, bean cannot see mysql, making me believe that maybe individuals table are available to each user.

It is possible to method in which I possibly could do to ensure that bean only able to being able to access databaseA, not others?

The information_schema is definitely accessible you cannot grant rights for this database.

Concerning the test database in the reference - The exam database frequently can be obtained like a workspace for customers to research.

I'd exactly the same probIn the configuration file of phpMyAdmin (config.corporation.php), you can include:

$cfg['Servers'][$i]['hide_db'] = 'information_schema';

this can hide that DB...