How to limit PHPMYADMIN access to specific database

Hi ,
Can someone please tell me how I can give limit access from phpMYADMIN to a specific database as I have some other database that I do not want to give access to.
just add this that I already have installed the phpmyadmin in my server.
do I have to install another one into my website directory and configure it for the database I want to give access?
or what?
Thanks for any help .

 

Create a user in SQL with access only to the database but without access to the other databases.

 

Thanks for your comment.
but How to apply the process as I am new to these things.
would be much appreciate if any how to steps to get to that.
Regards

 

If it is MySQL then you can look here https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql

When you run
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password;

Then the new user has no permission to do anything with databases

and

GRANT ALL PRIVILEGES ON database_name.* TO 'newuser'@'localhost';

allows him to do everything with "database_name"

Don't forget to run

FLUSH PRIVILEGES;

 

Thanks again for reply.
I am sorry but it seems there is miss understanding of what I am trying to do.
I know how to create a user and mysql database from server c/panel.
actually what I want to do is that I need to give my c/panel access credential to a person to look at my database and works on a specific database from phpmyadmin which also gives ability accessing to my other database .
so I want to limit to give access only to a specific database when the person access to phpmyadmin.
hope this clarify for my needs.
is that the way you mentioned and meant earlier for this .
Thanks

 

Should be as easy as site.com/phpmyadmin which will only allow them into that db in particular.(unless I am nuts) sorta like site.com/webmail

 

You could just take a backup of all databases.