Re: [q] can I start MySQL in READONLY mode?

2003-09-02 Thread Mark Swanson
Matt, Peter - thanks guys!! -- Schedule your world with ScheduleWorld.com http://www.ScheduleWorld.com/ Java Web start (JNLP): http://www.ScheduleWorld.com/sw/ScheduleWorld.jnlp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

RE: [q] can I start MySQL in READONLY mode?

2003-09-02 Thread Peter Lovatt
Hi When you set up the mysql user use a GRANT statement that only gives SELECT access. That is effectivly read only access for that user Peter -Original Message- From: Mark Swanson [mailto:[EMAIL PROTECTED] Sent: 02 September 2003 01:34 To: [EMAIL PROTECTED] Subject: [q] can I start

Re: [q] can I start MySQL in READONLY mode?

2003-09-02 Thread Matt W
Hi Mark, How about just giving the user(s) only the SELECT privilege temporarily? Matt - Original Message - From: "Mark Swanson" Sent: Monday, September 01, 2003 7:33 PM Subject: [q] can I start MySQL in READONLY mode? > Hello, > > I have a situation where

[q] can I start MySQL in READONLY mode?

2003-09-02 Thread Mark Swanson
Hello, I have a situation where I'd like to do some debugging against a MySQL database that's setup so I couldn't modify it (select only). I did some google searching and searched mysql.com but didn't find much on "readonly". Is this possible? I already know I can just backup/restore the dataf