# Connect with MySql and Ruby

**URL:** <https://discuss.rubyonrails.org/t/connect-with-mysql-and-ruby/62555>\
**Category:** rubyonrails-talk\
**Created:** [January 31, 2012, 11:47am UTC](https://discuss.rubyonrails.org/t/connect-with-mysql-and-ruby/62555 "2012-01-31T11:47:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![11155](https://avatars.discourse-cdn.com/v4/letter/1/d26b3c/32.png) [@11155](https://discuss.rubyonrails.org/u/11155)\
**Post date:** [January 31, 2012, 11:47am UTC](https://discuss.rubyonrails.org/t/connect-with-mysql-and-ruby/62555/1 "2012-01-31T11:47:28Z")

</div>

Hi everybody, &nbsp;&nbsp;&nbsp;I am very new in Ruby on Rails. I install ruby(1.9.2p180) and Rails(3.1.3). Also I install RubyMine3.1.1 as IDE. &nbsp;&nbsp;&nbsp;&nbsp;I successfully have done some simple simple practices. Now I want to play with database(mysql).Though I have checked so some of the URLs but unable to make out. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Please help me how to do that, what files or folders should I place and where should I place those. Please guide me. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Colin\_Law1](https://avatars.discourse-cdn.com/v4/letter/c/91b2a8/32.png) [@Colin\_Law1](https://discuss.rubyonrails.org/u/Colin_Law1)\
**Post date:** [January 31, 2012, 11:51am UTC](https://discuss.rubyonrails.org/t/connect-with-mysql-and-ruby/62555/2 "2012-01-31T11:51:47Z")

</div>

> Hi everybody, I am very new in Ruby on Rails. I install ruby(1.9.2p180) and Rails(3.1.3). Also I install RubyMine3.1.1 as IDE. I successfully have done some simple simple practices. Now I want to play with database(mysql).Though I have checked so some of the URLs but unable to make out. Please help me how to do that, what files or folders should I place and where should I place those. Please guide me.

Do you mean you are trying to install a mysql server on your pc, or what? Please give more detail on exactly what you want to do. Also tell us which operating system you are using.

Colin

---

<div class="post-metadata">

**Author:** ![11155](https://avatars.discourse-cdn.com/v4/letter/1/d26b3c/32.png) [@11155](https://discuss.rubyonrails.org/u/11155)\
**Post date:** [January 31, 2012, 12:01pm UTC](https://discuss.rubyonrails.org/t/connect-with-mysql-and-ruby/62555/3 "2012-01-31T12:01:57Z")

</div>

Colin Law wrote in post #1043229:

---

<div class="post-metadata">

**Author:** ![Colin\_Law1](https://avatars.discourse-cdn.com/v4/letter/c/91b2a8/32.png) [@Colin\_Law1](https://discuss.rubyonrails.org/u/Colin_Law1)\
**Post date:** [January 31, 2012, 12:30pm UTC](https://discuss.rubyonrails.org/t/connect-with-mysql-and-ruby/62555/4 "2012-01-31T12:30:34Z")

</div>

I don't know much about Windows, most Rails developers use Mac or Linux (often Ubuntu). However first you must check that your mysql server is working, presumably there is some way of accessing mysql from the command line to check it and to setup users and so on. Assuming you have already done this then setup the database details in database.yml and all should work.

Personally I advise people not to do Rails development Windows, but others do manage this. Either use a virtual machine running, for example, Ubuntu, using VirtualBox or VMWare or set your PC up to dual boot Windows and Ubuntu, which is very easy.

If you must use windows then I believe using railsinstaller is considered the best option at the moment.

Other than the above, if you have further problems while using Windows, I am afraid I will have to leave it to others to help.

Colin

---

<div class="post-metadata">

**Author:** ![11155](https://avatars.discourse-cdn.com/v4/letter/1/d26b3c/32.png) [@11155](https://discuss.rubyonrails.org/u/11155)\
**Post date:** [January 31, 2012, 1:42pm UTC](https://discuss.rubyonrails.org/t/connect-with-mysql-and-ruby/62555/5 "2012-01-31T13:42:30Z")

</div>

Colin Law wrote in post #1043237:
