Monday, November 19, 2018

How To Install Ruby on Rails Mysql2 Gem on Windows 10

If you cannot install the MYSQL2 gem in Windows, you need to download the C-Header files from MYSQL. Unlike other gems, MYSQL2 requires direct linking into some of the native build files provided by the library. Unless you have MYSQL installed already, it means you need to download - and reference - this library from the Internet.

The problem is that since the MYSQL2 gem requires certain files to help it connect to the Internet, the gem uses these to at build. The error you'll receive will mention "Failed to build native extensions". This means your Windows system did not have the header files required for the gem to be installed correctly.

The way to resolve this is to first log onto the MYSQL website and look for "C-Connector". This is basically the "driver" for MYSQL, allowing Windows to call a number of pre-compiled functions to help it communicate with local or external MYSQL installations. The purpose of this download is to ensure your computer has the necessary files to install the gem.

Once you have found the MYSQL C-Connector file, you need to download it to your hard drive. From this, unzip the file and place its contents on your hard drive. You must put it in a path which has no spaces, otherwise the installation reference will break. A path such as C:/downloads/mysql-c-connector/files will work fine. Please note you do NOT need to install this - only download the zipped archive, we can remove it after the gem has been installed.

If you have downloaded and placed the files on your hard drive, you need to then install the gem again. To do this, you should load up CMD and type the following command "gem install mysql2 --platform=ruby -- '--with-mysql-dir="C:mysql-connector-path"'".

This command will reference the newly installed MYSQL C-Connector library files which Ruby requires to build the gem. If you've downloaded / installed it correctly, this should allow Ruby to install the required files etc. If successful, the cmd will explain the gem has been installed; if not, it will likely be that you have either downloaded the incorrect files OR you have not got another necessary library installed on your system.

Since Windows comes with no external libraries, it's necessary to install any required from the Internet. This is one of the reasons most people don't like developing with Windows - ultimately, if you're able to download the correct header files, you should be fine.












  • A Credit Report Can Help To Go A Long Way With Financial Deals Free credit reports are very essential components in the business of financial transactions. It helps to keep track of all the business related facts and information of an individual. It helps to put all previous transaction under one page…
  • ZaGGsparq: The Perfect Portable Battery Convenient, easy to use, and lightweight all describe the ZaGGsparq: a multifunctional device for iPhone 4s and iPad 2s. Zagg is most known for their invisibleSHIELD screen protectors for mobile devices. Have you ever run out of battery life in…
  • Guide to Building Custom Gaming Computers Getting all the right components to play your favorite games and fit in your budget - usually that is hard to do but not impossible with this guide. There is a lot of hardware on the market to choose from, but we will give you all the info you…
  • Save Money On Car Buying Buying a new car is an adventurous journey, especially when you are purchasing your first car. It is one experience which you will cherish for the rest of your life and there is no doubt that the car we own is a very prized possession which we…
  • How To Fix The 1304 Error - Working Office Installation 1304 Error FixThe 1304 error is a typical Windows error which is caused by your computer not being able to correctly "write" to a specific file on your system. Whenever you install a program onto your PC, 100's of files & settings are going to be placed onto your…