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 .
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