# Error switching to mysql database

**URL:** <https://www.ruby-forum.com/t/error-switching-to-mysql-database/156286>\
**Category:** Rails\
**Created:** [December 23, 2008, 11:49pm UTC](https://www.ruby-forum.com/t/error-switching-to-mysql-database/156286 "2008-12-23T23:49:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![suman\_gurung](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/59ef9b/32.png) [@suman\_gurung](https://www.ruby-forum.com/u/suman_gurung)\
**Post date:** [December 23, 2008, 11:49pm UTC](https://www.ruby-forum.com/t/error-switching-to-mysql-database/156286/1 "2008-12-23T23:49:23Z")

</div>

Hi All,  
This is a rather trivial question, but i am sure this works for most  
of you but it just doesnot work for me.  
I am using Rails 2.2.2 on ubuntu. I created a rails app and i wanted  
to change the development database to one in mysql. So i created a  
database in mysql and changed the database.yml file to the following,

development:  
adapter: mysql  
encodeing: utf8  
database: jukebox  
username: root  
password:

However, when i start the server, and open the page in the browser i  
get the error saying that something is gone wrong and when i look at  
the development log file, it has the following entry:  
require ‘rubygems/gem\_runner’  
#Gem.manage\_gems

I know i can install a new version of the rails app with “rails app -d  
mysql” but can someone tell me what i am missing here…

thanks,  
suman

---

<div class="post-metadata">

**Author:** ![suman\_gurung](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/59ef9b/32.png) [@suman\_gurung](https://www.ruby-forum.com/u/suman_gurung)\
**Post date:** [December 24, 2008, 11:17pm UTC](https://www.ruby-forum.com/t/error-switching-to-mysql-database/156286/2 "2008-12-24T23:17:31Z")

</div>

Oh yeah… thanks for pointing out…

I apparently had to install mysql as a gem as well after installing in  
ubuntu, which solved the problem.

---

<div class="post-metadata">

**Author:** ![suman\_gurung](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/59ef9b/32.png) [@suman\_gurung](https://www.ruby-forum.com/u/suman_gurung)\
**Post date:** [December 24, 2008, 10:07am UTC](https://www.ruby-forum.com/t/error-switching-to-mysql-database/156286/3 "2008-12-24T10:07:39Z")

</div>

> encodeing: utf8  
> you have a typo: “encoding”.

but for your log-entry, i have no idea.