DIY

DIY: Securing Windows MySQL

Jack Wallen answers a TechRepublic member's question about securing a MySQL installation on Windows.

Read my answer to TechRepublic reader Hubert Aguilar's question, and then please post your suggestions for the member in the discussion.

Q: I read your article about securing [a] MySQL installation in Linux, but do you have any tips as far as doing the same in a MySQL Windows installation?

A: Believe it or not, this one is a simple one. The answer to your question is yes. The only trick is locating the script. On my Windows 7 testbed, I find the mysql_secure_installation.pl script located in C:\wamp\bin\mysql\mysql5.5.8\bin\. If you do not find that script in the same location, you will need to open Explorer and search for mysql_secure_installation.pl. Once you find the script, you can run the command. Before you do that, you must have Perl installed, or the command will not run. (I suggest installing Strawberry Perl.) Once Perl is installed, you are ready. To run this command, do the following:

  1. Open the command window.
  2. Change to the directory containing the script.
  3. Issue the command mysql_secure_installation.pl.

You could also locate the command in Explorer and double click the .pl file.

When you run this command a window will pop up that will walk you through the process of securing your MySQL installation. That's it!

Ask Jack: If you have a DIY question, email it to me, and I'll do my best to answer it. (Read guidelines about submitting DIY questions.)

About

Jack Wallen is an award-winning writer for TechRepublic and Linux.com. He’s an avid promoter of open source and the voice of The Android Expert. For more news about Jack Wallen, visit his website getjackd.net.

0 comments

Editor's Picks