Databases
StackOverflow2013
Postsdbo
POShutting down mysql from command line [Windows][DOS]
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POShutting down mysql from command line [Windows][DOS]
    text
    copied!<p>I want to shutdown mysql server from command line.</p> <p>If I use <code>taskkill.exe</code> or forcefully, it stops the mysql server but when I start mysql again. It shows </p> <pre><code>2013-08-31 16:00:35 3940 [Note] InnoDB: Database was not shutdown normally! 2013-08-31 16:00:35 3940 [Note] InnoDB: Starting crash recovery. 2013-08-31 16:00:35 3940 [Note] InnoDB: Reading tablespace information from the .ibd files... 2013-08-31 16:00:35 3940 [Note] InnoDB: Restoring possible half-written data pages 2013-08-31 16:00:35 3940 [Note] InnoDB: from the doublewrite buffer... 2013-08-31 16:00:35 3940 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-31 16:00:35 3940 [Note] InnoDB: Waiting for purge to start 2013-08-31 16:00:35 3940 [Note] InnoDB: 5.6.13 started; log sequence number 1600927 2013-08-31 16:00:35 3940 [Note] Recovering after a crash using mysql-bin 2013-08-31 16:00:35 3940 [Note] Starting crash recovery... 2013-08-31 16:00:35 3940 [Note] Crash recovery finished. </code></pre> <p>Recovery actually takes time to start the server. And also sometimes it gets failed to start, if the database is extremely large. </p> <p>So I want to shutdown normally like:</p> <p><code>mysqladmin -u root -pmysql shutdown</code></p> <p>Above command works but <strong>MySQL Root Password may change</strong> so I want a <strong>similar command of Mac OS X</strong> below for <strong>Windows</strong>:</p> <pre><code>mysqladmin -u root -p$(cat /path/to/mysql/root/password) shutdown </code></pre> <p>Basically I want to read the password from file. Is it possible in DOS ?</p> <p>Any help ? Thanks.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload