[plug] mysql question.

[Shayne O'Neill]

If your giving permissions like that, its sort of par for the course
that they can abuse it. 

I think this is why a lot of web hosting type joints let you have all
the tables you want, but only let you use the cpanel rather than allow
it in phpmyadmin.

-----Original Message-----
From: plug-bounces at plug.org.au [mailto:plug-bounces at plug.org.au] On
Behalf Of W.Kenworthy
Sent: Friday, 18 August 2006 5:26 PM
To: Plug List
Subject: [plug] mysql question.

I have set up a mysql database using grant all priviledges to a user.
However, I have decided to remove any access to the mysql admin table
(passwords/logins etc), but I still want to allow the user to create
databases and generally do everything else.

>From what I can find in the manual, you cant seem to do this without
locking the user into a particular database(s)

Is this so?

BillK

_______________________________________________
PLUG discussion list: plug at plug.org.au
http://www.plug.org.au/mailman/listinfo/plug
Committee e-mail: committee at plug.linux.org.au