Koozali.org: home of the SME Server

User acces to phpmyadmin

Thissel

User acces to phpmyadmin
« on: January 07, 2004, 06:08:26 PM »
When I am accessing the phpmyadmin at https://192.168.2.1/phpmyadmin I have to use the server-manager username and password. I've created a lot of different users in the mysql database, but I'm not allowed to use any of those as authentication.
I would like to connect to the phpmyadmin with my Mysql users and go directly to the granted database(s). Is that possible?

Best Regards

Thissel

Thissel

Re: User acces to phpmyadmin
« Reply #1 on: January 10, 2004, 01:02:08 PM »
Does anyone have a suggestion?

Jens Kruuse

Re: User acces to phpmyadmin
« Reply #2 on: January 12, 2004, 07:48:02 PM »
Your problem is one of authentication. Take a look at http://www.phpmyadmin.net/documentation/, specifically the section on "Using authentication modes".

SME uses "'config' authentication mode" which grants anybody who has the right credentials to access the page FULL access as the MySQL root user! If you look at the phpmyadmin config file, you will find the MySQL password in clear text.

If you want to use a different method of authentication, you can go about it in two seperate ways (CAVEAT: not tested personally):
1) Change the authentication method and make "suitable" adjustments in /opt/administration/phpmyadmin/config.inc.php via the template system. (/etc/e-smith/templates-custom/opt/administration/phpmyadmin/config.inc.php/10config and /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/86PhpmyadminAlias - base them on the corresponding original templates).

2) Install an extra phpmyadmin based on the original source package from the site and configure it differently (for users). Create a suitable template fragment for httpd (eg. /bla/bla/bla/87phpmyadmin-users etc)

/Jens