Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: egueguen on July 10, 2004, 06:05:28 PM

Title: Add a user to phpmyadmin
Post by: egueguen on July 10, 2004, 06:05:28 PM

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

Title: phpmyadmin
Post by: jbillings on July 11, 2004, 04:53:20 AM

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.

Title: Phpmyadmin
Post by: egueguen on July 11, 2004, 10:03:56 AM

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

Title: Add a user to phpmyadmin
Post by: Boris on July 11, 2004, 10:16:42 AM

rpm --help
rpm -e packagename_without_version_number

Title: How to config phpmyadmin in an i-bay
Post by: egueguen on July 11, 2004, 04:01:28 PM

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

Title: Add a user to phpmyadmin
Post by: jbillings on July 11, 2004, 06:42:18 PM

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.

Title: Add a user to phpmyadmin
Post by: egueguen on July 11, 2004, 09:23:44 PM

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 !