On Fri, May 15, 2009 at 12:48:18AM -0700, Scott Haneda wrote: > > Also, how do I set the slave to be read only? I set read-only in > my.cnf and it made all databases read only.
SET GLOBAL read_only = true; and as you've done in the my.cnf file. Unless the user has SUPER rights he can't change things in the database. There are some minor exceptions: - you can create temporary tables - you can run ANALYZE TABLE .... These are normally not an issue. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org