Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: mcp_dk on March 01, 2005, 05:00:18 PM

Title: Allow users to log into phpmyadmin and only see their DB
Post by: mcp_dk on March 01, 2005, 05:00:18 PM

When i create a user in SME i would like if that same user could log into phpmyadmin and maintain their database without having access to other databases.

What i do know is

1) create user on SME (e.g. user_001)
2) create ibay, domain, email etc.
3) go into phpmyadmin with my admin lgon
4) create same user here (user_001)
5) create database (database_001)
6) give mysql user_001 access to database_001 (and only this on)

My only problem is that at this moment only the admin can log into phpmyadmin. Is it possible to enable users access to https://mydomain/phpmyadmin/ with their username and password and ONLY see their own database??

Title: phpmyadmin setup
Post by: gbaird on March 01, 2005, 07:35:18 PM

Take a look at the standard phpmyadmin program

you could install a copy in each domain and just edit the config
files for it

I recall you can add several users with acces only to "their' database

You may be able to also do this with the sme version I would think by a simple editing

Take a look at the phpmyadmin docs