Re: [q] can I start MySQL in READONLY mode?
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 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 datafiles as many times as I need to - I was just hoping for a flag or startup option or something. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [q] can I start MySQL in READONLY mode?
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 MySQL in READONLY mode? 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 datafiles as many times as I need to - I was just hoping for a flag or startup option or something. Thanks. -- 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.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [q] can I start MySQL in READONLY mode?
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.com/[EMAIL PROTECTED]
