# Unable to compile mysql on windows **URL:** \ **Category:** Troubleshooting\ **Created:** [July 5, 2022, 3:17pm UTC](https://org-roam.discourse.group/t/unable-to-compile-mysql-on-windows/2683 "2022-07-05T15:17:59Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![J0ns4](https://avatars.discourse-cdn.com/v4/letter/j/eb9ed0/32.png) [@J0ns4](https://org-roam.discourse.group/u/J0ns4)\ **Post date:** [July 5, 2022, 3:18pm UTC](https://org-roam.discourse.group/t/unable-to-compile-mysql-on-windows/2683/1 "2022-07-05T15:18:00Z")
Hi! I’ve installed doom emacs on windows, and I get > (error No EmacSQL SQLite binary available, aborting) I realize that this usually indicates a missing GCC to compile the custom mysql - but I’ve installed GCC throught mingw, and I’ve verified that I can call it from windows command line - and I still get the same error. I’d really appreciate it if someone could help me debug this… Thanks! ---
**Author:** ![nobiot](https://yyz2.discourse-cdn.com/free1/user_avatar/org-roam.discourse.group/nobiot/32/159_2.png) [@nobiot](https://org-roam.discourse.group/u/nobiot)\ **Post date:** [July 5, 2022, 7:27pm UTC](https://org-roam.discourse.group/t/unable-to-compile-mysql-on-windows/2683/2 "2022-07-05T19:27:30Z")
It’s probably missing PATH environment variable. ---
**Author:** ![J0ns4](https://avatars.discourse-cdn.com/v4/letter/j/eb9ed0/32.png) [@J0ns4](https://org-roam.discourse.group/u/J0ns4)\ **Post date:** [July 6, 2022, 3:43am UTC](https://org-roam.discourse.group/t/unable-to-compile-mysql-on-windows/2683/3 "2022-07-06T03:43:28Z")
It was the first thing I checked… 🙂 > Jonathan@DESKTOP-KVVLOPE MINGW64 ~/Desktop > $ which gcc > /c/MinGW/bin/gcc > > Jonathan@DESKTOP-KVVLOPE MINGW64 ~/Desktop > $ echo $PATH > /c/Users/Jonathan/bin:/mingw64/bin:/usr/local/bin:/usr/bin:/bin:/mingw64/bin:/usr/bin:/c/Users/Jonathan/bin:/c/WINDOWS/system32:/c/WINDOWS:/c/WINDOWS/System32/Wbem:/c/WINDOWS/System32/WindowsPowerShell/v1.0:/c/WINDOWS/System32/OpenSSH:/c/Program Files/Polyspace/R2019a/runtime/win64:/c/Program Files/Polyspace/R2019a/bin ---
**Author:** ![nobiot](https://yyz2.discourse-cdn.com/free1/user_avatar/org-roam.discourse.group/nobiot/32/159_2.png) [@nobiot](https://org-roam.discourse.group/u/nobiot)\ **Post date:** [July 6, 2022, 4:58am UTC](https://org-roam.discourse.group/t/unable-to-compile-mysql-on-windows/2683/4 "2022-07-06T04:58:33Z")
Depending on how you installed Emacs, it may be worth checking if you can call gcc from cmd program. The path you show above may be only readable within MinGW (?). I have the following noted down, which does not seem to be part of your PATH(?) I use MSYS2 and install GNU Emacs official binary (not installed through MSYS2). MinGW would be different but maybe… ```auto C:\msys64\usr\bin ``` ---
**Author:** ![J0ns4](https://avatars.discourse-cdn.com/v4/letter/j/eb9ed0/32.png) [@J0ns4](https://org-roam.discourse.group/u/J0ns4)\ **Post date:** [July 6, 2022, 4:52pm UTC](https://org-roam.discourse.group/t/unable-to-compile-mysql-on-windows/2683/5 "2022-07-06T16:52:53Z")
Hmm… I’ve also installed the official windows binary of emacs, not through mysys. I’m running git bash, and have installed gcc through the mingw installer… How would you chcek that gcc is callable from a cmd program? ---
**Author:** ![nobiot](https://yyz2.discourse-cdn.com/free1/user_avatar/org-roam.discourse.group/nobiot/32/159_2.png) [@nobiot](https://org-roam.discourse.group/u/nobiot)\ **Post date:** [July 6, 2022, 6:46pm UTC](https://org-roam.discourse.group/t/unable-to-compile-mysql-on-windows/2683/6 "2022-07-06T18:46:09Z")
Perhaps call “gcc” directly? The note I took is as follows: > On Windows, add C:\msys64\usr\bin (command where gcc in MSYS2 terminal can tell you the directory) to PATH in your environmental variables > **[GitHub - nobiot/emacsql-sqlite.exe: Binary emacsql-sqlite.exe for Windows...](https://github.com/nobiot/emacsql-sqlite.exe)** > > Binary emacsql-sqlite.exe for Windows (for Org-roam V2) - GitHub - nobiot/emacsql-sqlite.exe: Binary emacsql-sqlite.exe for Windows (for Org-roam V2)