Re: [cobalt-users] Creating databases using phpMyAdmin

[baltimoremd@xxxxxxxxxxxxxxx]

> Hi Daniel,
> The problem if you use phpMyAdmin to create new mysql databases is that all
> your customer have the same username and password, so this means that one
> customer can view the content of another customer.

Another way around that is to create the database for the customer via
phpadmin, then paste the following in

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON database.* TO
username@localhost IDENTIFIED BY "his_password"

That way the user only has access to the named database.

Thom

baltimoremd@xxxxxxxxxxxxxxx             Thom LaCosta K3HRN Webmaster  
               http://www.baltimoremd.com/cobaltfacts/
Home of the CobaltFacts Web Ring - cobalt-ot and hosting-biz mailing lists