How to give a user privileges to one database?

Question

MySQL

Hello! When I log into PhpMyAdmin, I see databases too. And some of them are systemic. How to make sure that a certain user has access only to a certain database, the way it is done on hosting?

Answer 1

Elementary, give the user rights only to a specific database

GRANT ALL PRIVILEGES ON databaseName.* To 'user'@'hostname' IDENTIFIED BY 'password';