MySQL Windows 10

MySQL on Windows 10

 a list of tiny gotchas

Firstly, MySQL works great out of the box!

However, I wanted to change the location of the data directory.  What should have been an easy Custom install option turned into a nightmare (this option may have disappeared in version 8.2).

linux platform notes and hints often do not apply to Windows

edit my.ini with notepad++ do not use Windows notepad something about ANSI vs. UTF-8 text!

changing the location of the data directory is a goose chase.

extended directory attributes a nightmare to get right  

datadir location has changed between MySQL 5.6 and 8.x

crash course in Windows services

 

Stack Overflow and searching is your friend:

Change existing datadir path

 

MySQL database and Workbench and MariaDB on MBP x86

Hardware

MacBook Pro early 2015 Intel, macos 12.x

Reason run a database on my laptop. 

 1. MySQL database and Workbench

Installs flawlessly; ready to go right from the installation.  As a noob, Workbench was a life saver.

 

2.  Maria db

This is another story.  10.1 -10.x are marked beta on macport.  They don't successfully install.  I did not try homebrew which mixes their binaries with the stock ones.  

 

Your best bet is going with the official Docker image which worked great and you get the most recent release 11.2.