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 must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (via the "enable-named-pipe" option) will render mysqld useless! # #skip-networking <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< <<<<<<< This to be uncommented before running administrative task, and commented back to put MySQL back to live Regards, Mikhail Berman -----Original Message----- From: Wagner, Chris (GEAE, CBTS) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 14, 2006 4:08 PM To: mysql@lists.mysql.com Subject: taking MySQL down into "admin" mode Greetz. We have a database that is highly used, around 500 queries/s, and doing administrative tasks can stuff up the database. Is there a way to temporarily prevent client connections from within MySQL? Like unix u can drop the runlevel to do administration, is there something similar in MySQL? I haven't seen anything promising in the manual. We're on 5.0.24. -- Chris Wagner CBTS GE Aircraft Engines [EMAIL PROTECTED] -- 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]
