RE: [cobalt-users] MySQL for different users

["Jim Carey" <ozbcoz@xxxxxxxxxxxxxxxx>]

> -----Original Message-----
> From: cobalt-users-admin@xxxxxxxxxxxxxxx
> [mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of Bryan - Utopian
> Web Productions
> Sent: Saturday, 21 October 2000 6:46 PM
> To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: Re: [cobalt-users] MySQL for different users
>
>
> > Yes,  we downloaded and installed MySQL. Then installed DBI. Once you
> > install that, we installed a Web Based MySQL adminstration tool for our
> > custoemrs http://phpwizard.net/projects/phpMyAdmin/index.html
> >
> > The following 2 commands (under the MySQL DB) will allow you to
> set a user
> > to have a specific DB:
> >
> > INSERT INTO user (Host, User, Password, Select_priv, Insert_priv,
> > Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,
> > Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv,
> > Index_priv, Alter_priv) VALUES ('localhost', 'foo',
> PASSWORD('bar'), 'N',
> > 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N')
> >
> > INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv,
> > Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv,
> > Index_priv, Alter_priv) VALUES ('localhost', 'foo_db', 'foo', 'Y', 'Y',
> 'Y',
> > 'Y', 'Y', 'Y', '', '', '', '')
>
>
> We are using phpMyAdmin as well, but can only gain access to the root. The
> following is an example of the config file. What am I doing wrong?
>
> This WORKS
> $cfgServers[1]['host'] = 'localhost';
> $cfgServers[1]['port'] = '';
> $cfgServers[1]['adv_auth'] = true;
> $cfgServers[1]['stduser'] = 'root';
> $cfgServers[1]['stdpass'] = 'rootpassword';
> $cfgServers[1]['user'] = '';
> $cfgServers[1]['password'] = '';
> $cfgServers[1]['only_db'] = '';
> $cfgServers[1]['verbose'] = '';
>
> This DOES NOT WORK:
> $cfgServers[1]['host'] = 'localhost';
> $cfgServers[1]['port'] = '';
> $cfgServers[1]['adv_auth'] = false;
> $cfgServers[1]['stduser'] = '';
> $cfgServers[1]['stdpass'] = '';
> $cfgServers[1]['user'] = 'username';
> $cfgServers[1]['password'] = 'userpassword';
> $cfgServers[1]['only_db'] = '';
> $cfgServers[1]['verbose'] = '';

this works for me:
$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'] = '';                 // MySQL standard password
(only needed with advanced auth)
$cfgServers[1]['user'] = 'userid';                // MySQL user (only needed
with basic auth)
$cfgServers[1]['password'] = 'userpassword';                // MySQL
password (only needed with basic auth)
$cfgServers[1]['only_db'] = 'database';	                // 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

$cfgServers[2]['host'] = 'localhost';
$cfgServers[2]['port'] = '';
$cfgServers[2]['adv_auth'] = false;
$cfgServers[2]['stduser'] = 'root';
$cfgServers[2]['stdpass'] = '';
$cfgServers[2]['user'] = 'userid';
$cfgServers[2]['password'] = 'userpassword';
$cfgServers[2]['only_db'] = 'database';
$cfgServers[2]['verbose'] = '';

$cfgServers[3]['host'] = 'extenal domain name';
$cfgServers[3]['port'] = '';
$cfgServers[3]['adv_auth'] = false;
$cfgServers[3]['stduser'] = 'root';
$cfgServers[3]['stdpass'] = '';
$cfgServers[3]['user'] = 'userid';
$cfgServers[3]['password'] = 'userpassword';
$cfgServers[3]['only_db'] = 'database';
$cfgServers[3]['verbose'] = '';

etc - ie add root into stduser

cheers

Jim Carey