Starting And Stopping MySQL Using Windows .bat Files

13th May 2009 - 2 minutes read time

I use my PC for a lot of different things, and I don't necessarily need to have MySQL server running all the time, especially when I want to play a game. So I wondered if there was a simple way in which I could start and stop the server using a simple .bat file.

I had a look at the MySQL website and found a page that details how to start MySQL from the command line. This page suggested that I use the following command.

"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld"

Use the following command to stop the server. In this case the username is root and the password is wibble.

"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin" -u root -pwibble shutdown

However, this just didn't work when I tried to use it in a .bat file. Realising that MySQL installs a service, I wondered if I could use the net command in order to start and stop the server. It turns out that the command is quite easy to use, so to turn the MySQL server on use the following command.

net start mysql

To stop the server use the following command.

net stop mysql

Add these commands to separate files, perhaps called stopmysql.bat and startmysql.bat, and you will have a neat way of turning on and off your MySQL server at the touch of a button.

If you are using Vista you can still do the same thing but you will need to right click and select "Run as administrator" or the script won't have enough privileges to alter the service.

MySQL

Comments

Permalink

Deep appreciation for outlining this process!

Corey (Sun, 06/05/2011 - 22:27)

Permalink
How would you write the .bat file so that you can make one button that toggles it on and off, instead of writing two separate buttons?

brandon (Thu, 08/16/2012 - 01:28)

Permalink
may be you can search at google.

blogwidget (Sat, 08/25/2012 - 07:18)

Add new comment

The content of this field is kept private and will not be shown publicly.

Related Content

Case Insensitive Like Searches In MySQL

2nd July 2011 - 1 minute read time

I needed to create a query that did a case insensitive search using the LIKE command in MySQL and I quickly realised that in order to do this I would need to alter both the parameter and the table data to be the same case. This can be done by using the MySQL UPPER() command on the table data and the strtoupper() PHP function on the input data.

Connecting To A Non Standard MySQL Socket In PHP

11th February 2011 - 3 minutes read time

Connecting to a MySQL database in PHP is usually not a difficult thing to do, in fact it is one of the first things that many tutorials will go though. However, there are certain curcumstances that require more information than the standard host, password and username details. A good example of this is when connecting to a local MySQL server through a different (or at least non standard) socket. The normal place for the MySQL socket to be on a Linux install is /var/run/mysqld/mysqld.sock, but some hosts might change this.

Count Number Of Characters In A String With MySQL

30th September 2010 - 2 minutes read time

Today I needed to grab some data from a table where there was more than one occurrence of a string within another string. Basically, I needed to find all URL's from a table that were more than 3 levels deep (i.e. with 3 slashes), but realised there wasn't a function to do this in MySQL. I found an alternative method, but it got me thinking on how that might be possible.

Finding the solution wasn't too difficult really, all I needed to do was find out the length of the URL string and then subtract the length of the string with the slashes removed. This MySQL statement will give you the URL and the number of slashes in that URL in a table.

MySQL Order Table By Character Length

24th September 2009 - 1 minute read time

As part of debugging a bit of code I needed to know the longest possible field lengths that a record contains. You might need to know this if you are performing a database migration. The following query returns a field, along with the length of the string, and orders the results by the number of characters in that string.

  1. SELECT FIELD, CHARACTER_LENGTH(FIELD) AS fieldCharacterCount
  2. FROM TABLE
  3. ORDER BY fieldCharacterCount DESC

 

Backup MySQL Database PHP Script

12th August 2009 - 6 minutes read time

There are quite a few scripts available on the Internet that allow you to dump data from a database into a format that can be used to replicate that database structure elsewhere. The following function is my take on this commonly occurring script.