Do 'service mysql restart --skip-networking'
This prevents all TCP/IP connections
You can login as root@localhost and the client program will use the socket file rather
than TCP/IP.
Do all your DDL work.
When done, 'service mysql restart'
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM & Skype : RolandoLogicWorx
redwards@stripped
-----Original Message-----
From: TETTERTON George [mailto:George.Tetterton@stripped]
Sent: Wednesday, May 20, 2009 4:30 PM
To: mysql@stripped
Subject: Starting MySQL in Maintenance mode
How do I start MySQL in maintenance/single user mode so I can create
indexes on a table that is being updated often?
I prefer for the update transactions to fail immediately with a
connection error rather than to wait for a lock to be released.
In Oracle you can startup nomount. What is the equivalent for MySQL?
George Tetterton
Alcatel-Lucent
3400 W. Plano Pkwy
Plano, TX 75075
Office: 972-477-1571
Cell: 972-400-0887
Email: george.tetterton@stripped
<blocked::mailto:george.tetterton@stripped>
Yahoo Messenger ID: george_tetterton
