Connect to MariaDB (mysql) and MS Access mdb databases via localhost using unixODBC on Debian?

I'm a relative linux newby just trying to move my computing from Windows 10 to Debian. I have been struggling to setup shared dual boot access to my MS Access data bases. I have found it very hard to get unixODBC to work with MariaDB (or MySQL), and so will share with you what works below, as I answer my own question here.