Re: MySQL Read_only Mode

2006-06-28 Thread Eric Braswell
--read_only is probably what you are looking for. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html -- Eric Braswell Web Manager MySQL AB Cupertino, USA Clyde Lewis wrote: The idea is to prevent all users from applying changes to the system. Not just a single user. I'

Re: MySQL Read_only Mode

2006-06-28 Thread Clyde Lewis
The idea is to prevent all users from applying changes to the system. Not just a single user. I'm trying to find something similar to Oracle's Read-only mode option during startup. Thanks, CL At 02:38 PM 6/28/2006, João Cândido de Souza Neto wrote: Why you don´t create a user with just sele

Re: MySQL Read_only Mode

2006-06-28 Thread jabbott
Only allow your users select rights. --ja On Wed, 28 Jun 2006, Clyde Lewis wrote: > All, > > Does MySQL have an option where the database can startup in READ-ONLY > mode? The idea is to have the server running with users connected, > but now allowing any updates to me applied to the databas

Re: MySQL Read_only Mode

2006-06-28 Thread Jo�o C�ndido de Souza Neto
Why you don´t create a user with just select right and use him? "Clyde Lewis" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > All, > > Does MySQL have an option where the database can startup in READ-ONLY > mode? The idea is to have the server running with users connected, bu