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 information is also held in the Db table as well - hopefully someone can correct me if I'm wrong. > You should be able to copy this information into a temporary table using > select into, then perform regular updates to change the host information to > match your new subnets. Then simply copy it back to the user table, which > will add these records to the existing records, crucially with the same > passwords. You might have to repeat this a few times to get all the subnets > in. I was kinda hoping I could avoid doing such hoops - but thanks for the suggestion. I will have a play on my test database. > I'd certainly perform lots of testing away from the live system before I > tried this for real. :-)) Rgds Shin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
