Mysql2 installation in ruby on rails window platform error
Now to begin the installation we need the following:
- Ruby
- Rails
- Git
- Devkit
- Webserver
- Mysql and Mysql2 (database)
- E txt (text editor)
I choose mysql and mysql2 as my database for ease of use and
its free. Now to download the following
manually download the link from this link: http://rubyonrails.org/download. Or
download the updated package and skip all the head aches and erros, http://www.rubyinside.com/rails-installer-ruby-and-rails-on-windows-in-a-single-install-4201.html
After installing the Ruby on Rails including the Git and the
Devkit. We gonna need a database. Follow this link to download mysq version 5.1
http://dev.mysql.com/downloads/mysql/5.1.html.
Now here is the tricky thing. After installing mysql
database go to directory folder and copy the libmysql.dll inside the bin
folder.
After copying the libmysql.dll of the mysql database, go to
the directory folder of Ruby. Inside it go to the bin.
- Note:If you choose to download and install the stand alone package. You can locate the ruby folder inside the railsinstaller folder in “c:”.
After the pasting is done. Run the command prompt is window
and type the following. “gem install mysql”
To check whether it is successfully installed, type “gem
list” to view all the install plugins in gem.
Now we will install the mysql2, other say its quite complicated,
however it can be install in one script.
Again, go to command prompt with ruby on rails in window and
type the following or just copy paste it, gem install mysql2 --
'--with-mysql-lib="c:\Program Files\MySQL\MySQL Server 5.1\lib\opt"
--with-mysql-include="c:\Program Files\MySQL\MySQL Server
5.1\include"'
- Note: That the following directory is base from my computer directory installation.
After the process, type in the “gem list” to check the
mysql2. If exist, were done.
Credits to : Ritesh Kumar and lynda.com
Credits to : Ritesh Kumar and lynda.com
