Hi,
Thanks for the followup/reply.
On Tue, Sep 30, 2003 at 01:56:11PM +0100, Andy Eastham wrote:
> I've never tried this, so it's pure speculation, but I believe all of the
> grant information is contained in a regular table called user.
I had a look into this and it seems that some of the info
[EMAIL PROTECTED]
> Subject: GRANT update query: Updating host access entry for users but
> retaining existing passwords
>
>
> Hi,
>
> I've got a MYSQL 3.23.x setup that has approx 4000 database and 4000
> user accounts. 1 database per user.
>
> I created each u
Hi,
I've got a MYSQL 3.23.x setup that has approx 4000 database and 4000
user accounts. 1 database per user.
I created each userid from a script of the form
CREATE DATABASE mdb_userid;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX,RELOAD ON
mdb_userid.* TO [EMAIL PROTECTED]
