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 some settings

Impressions

Installed MySQL and MySQL Workbench on my Macbook Pro x86 and everything worked right out of the box!  Workbench is very useful and takes care of connections and settings that as a non-database person would have gotten in the way of getting work done.

Setting up

Timeouts

Increase connect and wait timeouts.

 

Grid view

To see results in Workbench make sure the middle pane in grid view is visible.

 

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.