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
test databases. From the understanding, should not
bean only able to seeing
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?
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?
information_schema is definitely accessible you cannot grant rights for this database.
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...