Monday, November 6, 2023

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:

 


No comments:

Post a Comment