Re: howto set mysql to readonly

[Jeremy Cole]

Hi Jehan,

OK so it seems to be a bad idea ... I was expecting that I missed a 
magic command like "set readonly on all databases" ...

I think you did:

  SET GLOBAL read_only=1;

This will keep all non-SUPER and non-replication users from writing to 
the database.

Regards,

Jeremy

--
high performance mysql consulting
www.provenscaling.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]