Download MySQL 5.1 CE Essentials. (It should be the first link under “Windows Downloads.” If you aren’t running Windows… well, I suspect you know more about your Linux/Mac/Amiga machine than I do, so I leave that as an exercise to the enterprising reader.) Then, once you’ve downloaded it, run the MSI file.
Choose a “typical” install.
There will be some ads. Skip over them. Make sure that “Configure the MySQL server now” is checked. Chose “Detailed configuration.”
Then you’ll go through a set of pages asking you questions. Here are the answers:
- Developer Machine
- Non-Transactional Database Only
- Decision Support (DSS)/OLAP
- Continue on, using the defaults.
Either add a password or uncheck the box to alter security settings. (This will leave your root password blank.)