Configuring mysql server for ruby

Even though sqlite 3 officially ported with rails, in mass scale application production environments, the typical candidate will be MySQL due to several reasons like its open source, established an a reliability.

 

1. If you have already installed MySQl server skip to step 2 directly other wise download it from here and run the UI installer and it will guide u through the steps. ( You need to made couple of requirements inorder to run this msi package sucessfully one is .NET 4 framework and second Microsoft C++ runtime 2010 32 bit package.)
2. After that go to this location and download the zip file which contain MySQL c driver.
3. UNZIP the file.
4. Copy the dll file in "mysql-connector-c-noinstall-6.0.2-win32-vs2005\lib" location to " <your-ruby&rails-installation-directory>\ruby <version>\bin " directory.