Darrell,
Another option is to take advantage of Advanced Authentication using
phpMyAdmin. The advantage of using this feature is that phpMyAdmin can be
set to run with the privileges of specific users. So, if you need to give
multiple users access to MySQL, you don't have to give them all your
system's admin password. The other advantage is that you don't have to
store your MySQL root password in the phpMyAdmin config file.
To enable Advanced Authentication using your rpm, do the following:
- Remove the authentication settings in the phpmyadmin directive in
your httpd.conf file. phpMyAdmin will initiate authentication itself.
- Create an account in MySQL that can read the mysql table.
For example: grant SELECT on mysql.* to phpMyAdmin@localhost identified by
"SomePassword";
- Edit phpMyAdmin's config file as follows:
$cfgServers[1]['adv_auth'] = TRUE;
$cfgServers[1]['stduser'] = 'phpMyAdmin';
$cfgServers[1]['stdpass'] = 'SomePassword';
$cfgServers[1]['user'] = '';
$cfgServers[1]['password'] = '';
- Create accounts in MySQL for your users (they only need access from
localhost to use phpMyAdmin). This can now easily be done using phpMyAdmin.
Every time you use phpMyAdmin now, phpMyAdmin will prompt for a username
and password. Simply enter the values for any valid MySQL user and
<yAdmin will access your MySQL server as that user.
Noah
--
Please report bugs to [EMAIL PROTECTED]
Please mail [EMAIL PROTECTED] (only) to discuss security issues
Support for registered customers and partners to [EMAIL PROTECTED]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Archives by mail and http://www.mail-archive.com/devinfo%40lists.e-smith.org
