Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Gerald Jansen on February 24, 2001, 08:13:49 AM

Title: phpMyAdmin
Post by: Gerald Jansen on February 24, 2001, 08:13:49 AM

Has anyone loaded phpMyAdmin on an e-smith server. It evidently manages mysql use.
http://www.phpwizard.net/projects/phpMyAdmin

Title: Re: phpMyAdmin
Post by: Luuk Jansen on February 24, 2001, 02:04:58 PM

Yes I did.
I installed it on the e-smith server, and it works.
I havn't workt with it after I finished the installation, but I seem to run OK.

I greated a e-bay for phpMyAdmin (secure with password!), and modified the configuration file (username and password) (file:config.inc.php3) .
You can find your password in '/root/.my.cnf'

Then with Index you can start the phpmyadmin.

I hope this is what you were tooking for...

Luuk

Title: Re: phpMyAdmin
Post by: Gerald on March 04, 2001, 08:14:22 AM

I set up phpMyAdmin in its own ibay and virtual domain. Found my password but am getting my user name refused. What user name is it looking for: I have listed the config.inc.php3 below with user names in and passwords in two differand places.

// The $cfgServers array starts with $cfgServers[1].  Do not use $cfgServers[0].
// You can disable a server config entry by setting host to ''.
$cfgServers[1]['host'] = 'localhost';           // MySQL hostname
$cfgServers[1]['port'] = '';                    // MySQL port - leave blank for default port
$cfgServers[1]['adv_auth'] = true;              // Use advanced authentication?
$cfgServers[1]['stduser'] = 'root';             // MySQL standard user (only needed with advanced$
$cfgServers[1]['stdpass'] = 'ldv8972';          // MySQL standard password (only needed with adva$
$cfgServers[1]['user'] = 'admin';               // MySQL user (only needed with basic auth)
$cfgServers[1]['password'] = '05707571';        // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db'] = '';                 // If set to a db-name, only this db is accessible
$cfgServers[1]['verbose'] = '';                 // Verbose name for this host - leave blank to sh$

TIA :-)

Title: Re: phpMyAdmin
Post by: Luuk Jansen on March 04, 2001, 12:39:41 PM

Ho,

You almost did it the right way, but the user is 'root', not your username.
For both advanced and basic use.

There is a way to create a user name in MySQL, but I you haven't done it you must use the root account.The admin account is for 'e-smith', and not for MySQL.

By the way, never put password in mail! Replease them by <> or something, there is no one out here that needs your password for legal use!

// The $cfgServers array starts with $cfgServers[1].  Do not use $cfgServers[0].
// You can disable a server config entry by setting host to ''.
$cfgServers[1]['host'] = 'localhost';           // MySQL hostname
$cfgServers[1]['port'] = '';                    // MySQL port - leave blank for default port
$cfgServers[1]['adv_auth'] = false;             // Use advanced authentication?
$cfgServers[1]['stduser'] = 'root';             // MySQL standard user (only needed with advanced auth)
$cfgServers[1]['stdpass'] = 'password';                 // MySQL standard password (only needed with advanced auth)
$cfgServers[1]['user'] = 'root';                // MySQL user (only needed with basic auth)
$cfgServers[1]['password'] = 'password';                // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db'] = '';                 // If set to a db-name, only this db is accessible
$cfgServers[1]['verbose'] = '';                 // Verbose name for this host - leave blank to show the hostname