仅显示phpmyadmin用户的选定数据库

Question

i have one issue with phpmyadmin user, i have one new user and i want to assign specific database for access and view, i mean i have 5 database in phpmyadmin and i want to show only specific database for other user so its cant be view other database and not able to access them

i try with

On the phpMyAdmin default page (localhost) click on the "Privileges" link Click on the "Add a new User link" Assign the User a login and password Where it says "Database for User" select "None" Leave all checkboxes in global privileges unchecked Press the "Go" button

but using this user can view all the database

Answer 1

Create the user with only that database permission.

grant all on `db_name.*` to `'username'@'localhost'`;

For details Information Click Here