Re: [cobalt-users] MySQL for different users

["Bryan - Utopian Web Productions" <bryan@xxxxxxxxxxx>]

> 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'] = '';