Re: taking MySQL down into "admin" mode

2006-09-14 Thread Wagner, Chris (GEAE, CBTS)
Thanks for that but I was hoping there was a way to do it "live" that didn't require restarting/reloading. Something to do at the mysql> prompt. We had to repair a table and all the backed up connections were threatening to take down the daemon. Mikhail Berman wrote: > > Hi Chris, > > In my.cn

RE: taking MySQL down into "admin" mode

2006-09-14 Thread Mikhail Berman
Hi Chris, In my.cnf in the following section, remove comment from skip-networking statement, and re-start your MySQL # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld mu