Topic: Add a user to phpmyadmin

[egueguen]

Hello,

I have SME Server 6.0.1-01.
I have installed the rpm for the implementation to Phpmyadmin (2.5.6). It works fine. But it is only possible to log with the "admin". Is it possible to add a user to PhpMyadmin ?

Thanks

[jbillings]

I'm not sure how it works when you install it as an RPM.  Was it a contrib?  I usually install phpmyadmin in an Ibay, and then you should be able to have better control over who has access to it. Just unzip the latest tar.gz into the html directory of the Ibay edit the config.inc.php file.

[egueguen]

Yes it is a contrib.

I will try, your way so that I can customize PHPMyadmin.

But the pb is now, how to remove the RPM. I am new in Linux.

Thanks

[Boris]

rpm --help
rpm -e packagename_without_version_number

[egueguen]

Thanks, that is ok.

I have now install PhpMyadmin on an I-bay. Here is mine. What is wrong ? That kinds of parameters work fine one others servers...

Thanks

The pb is now to find the parameters in "config.inc.php"

$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                    // (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
                                                    // (this user must have read-only
$cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
                                                    // and "mysql/db" tables).
                                                    // The controluser is also
                                                    // used for all relational
                                                    // features (pmadb)
$cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user

[jbillings]

I use the "config" authentication method.  You will have to set a password for your root mysql user, or create another admin user: http://dev.mysql.com/doc/mysql/en/Default_privileges.html

The only editing I did of the php.conf.inc file was adding the password.

[egueguen]

Right ! That's it I must create another user with "grant" rights via command line (oh !!!) and then I can use it in Phpmyadmin and do what I want. Thanks !