MySQL and PHP

[Bastien]

Hi All,

is there a way to create roles for the MySQL DB? Similar to oracle and sql server, where i can set the permissions and accessibilty of the users?

TIA Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[fortytwo]

You can set permissions for different users of a MySQL database. You might fing the following helpful:

http://www.mysql.com/doc/A/d/Adding_users.html

and it is extremely easy to modify permissions for users using phpmyadmin:

http://phpmyadmin.sourceforge.net

Will.
fortytwo
will@hellacool.co.uk