What are some important points to consider when installing mysql 5.1 on windows webserver 2008?

I never installed mysql on any production windows server, so apart from not using the default user root with empty password - what else should be considered in order to safely install the mysql database?

1 Answer 1


A lot of standard stuff applies.

Make sure that there are no open ports from the Internet (via hardware or software firewall, preferable hardware). Make sure that MySQL is running under an account which has the least permissions possible. Fast storage for the database and transaction logs

I'm sure there's lots of others that people can suggest.

  • i found this installation guide: analysisandsolutions.com/code/mysql-tutorial.htm -- it sounds very complicated. Is installing mysql really as tough as it sounds?
    – Max
    Oct 8, 2009 at 7:37
  • 1
    Installing MySQL is actually pretty simple. It has an install wizard just like other applications which walks you though the process.
    – mrdenny
    Oct 8, 2009 at 18:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.