Bootstrapping & Running MySQL server standalone on Windows
Two extra tips when you try to (manually) bootstrap MySQL on Windows from the command line:
- When bootstrapping, use --no-defaults or --defaults-file.
- Use --standalone when starting the MySQL server.
The first point really bugged me yesterday. I’m used to installing MySQL manually and having no option files available where MySQL would read them by default.
On Windows, however, I used the MySQL installer. So, when I launch unit testing for Connector/Python it bugged me saying log files of InnoDB didn’t match the configuration. This is indeed a newbie error..