# Cannot connect to MySql

**URL:** <https://www.ruby-forum.com/t/cannot-connect-to-mysql/145283>\
**Category:** Rails\
**Created:** [August 7, 2008, 2:23pm UTC](https://www.ruby-forum.com/t/cannot-connect-to-mysql/145283 "2008-08-07T14:23:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sriharshanamala](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/7bcc69/32.png) [@sriharshanamala](https://www.ruby-forum.com/u/sriharshanamala)\
**Post date:** [August 7, 2008, 2:23pm UTC](https://www.ruby-forum.com/t/cannot-connect-to-mysql/145283/1 "2008-08-07T14:23:42Z")

</div>

HI Everyone,

me new to Ruby on Rails,  
For me its getting difficult to connect To Database .  
Previously i followed some tutorial and installed sqlite ,  
Now when i change the configuration file (database.yml)configurations  
from sqlite to mysql im getting problems.

when me trying to hit the following command.  
C:\rails\connect\>ruby script/generate controller list  
me getting the following error.

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/connection\_a  
dapters/abstract/connection\_specification.rb:218:in  
`establish_connection': deve lopment database is not configured (ActiveRecord::AdapterNotSpecified) from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record /connection_adapters/abstract/connection_specification.rb:209:in`establish\_conn  
ection’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/initializer.rb:332:i  
n `initialize_database' from c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/initializer.rb:120:i n`process’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/initializer.rb:93:in  
`send' from c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/initializer.rb:93:in`run’  
from C:/rails/connect/config/environment.rb:13  
from  
c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in `ge m_original_require' from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in`re  
quire’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/commands/generate.rb  
:1  
from  
c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in `ge m_original_require' from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in`re  
quire’  
from script/generate:3

```
                 Thanks for help in advance.
```

---

<div class="post-metadata">

**Author:** ![sriharshanamala](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/7bcc69/32.png) [@sriharshanamala](https://www.ruby-forum.com/u/sriharshanamala)\
**Post date:** [August 7, 2008, 2:38pm UTC](https://www.ruby-forum.com/t/cannot-connect-to-mysql/145283/2 "2008-08-07T14:38:12Z")

</div>

Hi

I guess each beginner on rails would face this problem  
I faced it too when i started working on rails 🙂

the solution is to create a new project using this command

rails project -d mysql

-d mysql will generate the database.yml for mysql in accordance to  
your platform

so copy this file and paste it in your original project, restart the  
server, and enjoy

if anyone has a better way, please do tell us

thanks

On Aug 7, 8:23 pm, Sriharsha Namalala \<rails-mailing-l…@andreas-

---

<div class="post-metadata">

**Author:** ![sriharshanamala](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/7bcc69/32.png) [@sriharshanamala](https://www.ruby-forum.com/u/sriharshanamala)\
**Post date:** [May 7, 2009, 2:41am UTC](https://www.ruby-forum.com/t/cannot-connect-to-mysql/145283/3 "2009-05-07T02:41:49Z")

</div>

Thanks a lot !

Shuaib Z. wrote:

> Hi
> 
> I guess each beginner on rails would face this problem  
> I faced it too when i started working on rails 🙂
> 
> the solution is to create a new project using this command
> 
> rails project -d mysql
> 
> -d mysql will generate the database.yml for mysql in accordance to  
> your platform
> 
> so copy this file and paste it in your original project, restart the  
> server, and enjoy
> 
> if anyone has a better way, please do tell us
> 
> thanks
> 
> On Aug 7, 8:23�pm, Sriharsha Namalala \<rails-mailing-l…@andreas-