RE: [cobalt-users] MySQL for different users

["Avi Brender" <support@xxxxxxxxxxxxxx>]

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', '', '', '', '')

Avi Brender
Tech Support
Elite Hosts


-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of Stephan P.
Muecke
Sent: Thursday, October 19, 2000 4:42 AM
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: [cobalt-users] MySQL for different users


> Hello,
>
> can anyone tell me how it is possible to offer the different RaQ3-users
> access to the MySQL-database installed. After a user has been added, he
> should only have access to his own database and not to the ones owned by
> others.
>
> Thanks for your help,
> Steve
>

_______________________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To Subscribe or Unsubscribe, please go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users