FYI: Mysql on Vista Home

The latest MySQL (5.1.30) setup does not work properly on Vista Home Edition. I think that MySQL team will solve it eventually, so here’s how to make it work:

  1. DO NOT install into the directory that setup offers. Change both install dir and data dir to something that does not contain spaces, e.g. c:\mysql, c:\mysql\data

  2. Create your own my.ini file and add the following parameter there:
    datadir =

  3. As administrator, run
    mysqld --install --defaults-file=

  4. start service

That’s all

Thanks for the tip!