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

 

Windfall Computer Part 2

 ...Previously

 

• installed 2x4GB sticks DDR3L RAM and Ubuntu 20.04

DDR3L RAM low(er) voltage so uses less power 

Doing almost anything on Linux requires some amount of sudo apt update get install. 

• reverted to Windows 10 H21

unknown SMB bios device

no setup DVD-iso on ASUS site

Asus H81M-K audio driver:

• H81M-K - Support - Asus

• No sound when you plug in audio device on back/front audio port

• installed Virtualbox 6.1
  
• installed Starcraft 2 and World of Warships
  

Next ...