Rails rake db:create causing error

I am trying to start up a rails project and I run:

rake db:create

And I get:

Couldn't create database for {"encoding"=>"utf8", "username"=>"root", "adapter"=>"mysql", "host"=>"localhost", "password"=>"root", "database"=>"MyProject_development"}, charset: utf8, collation: utf8_general_ci (if you set the charset manually, make sure you have a matching collation)

Any idea why? I did some searching on google and not sure why it is doing that, and my MySQL server is up. I am using MAMP, so I am not using the default mysql.sock, I tried this but not sure if it worked:

http://www.nogeek.org/2008/08/10/no-such-file-or-directory-tmpmysqlsock/

Thoughts?
LVL 1
catonthecouchproductionsAsked:
Who is Participating?
 
Andrew DoadesConnect With a Mentor IT TechnicianCommented:
" charset: utf8, collation: utf8_general_ci (if you set the charset manually, make sure you have a matching collation)"

In your config/database.yml file try to remove the line encoding: ...

I had this problem when trying to migrate to a mysql database, removing this line fixed it for me.
0
 
wesgarrisonCommented:
Can you connect with the username/password of root/root with the plain mysql command line console, just to confirm that your password is correct?
0
 
catonthecouchproductionsAuthor Commented:
I got it, I just had to add in my sock to specifiy it. Do you know if there is a way to always use that sock to by default?

0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
catonthecouchproductionsAuthor Commented:
Hey, I also have another question here if you have a second:

http://www.experts-exchange.com/Programming/Editors_IDEs/RubyOnRails/Q_23866977.html

thank you!

Ryan
0
 
wesgarrisonCommented:

# in database.yml
  socket: /path/to/your/mysql.sock

Open in new window

0
 
catonthecouchproductionsAuthor Commented:
Yeah.. I got that, but is there away to set a default so everytime you create a new server it uses that? Or do I need to enter it manually?

Thanks,

Ryan
0
 
catonthecouchproductionsAuthor Commented:
Yeah.. I got that, but is there away to set a default so everytime you create a new server it uses that? Or do I need to enter it manually?

Thanks,

Ryan
0
 
wesgarrisonCommented:
"Create a new server"?  Not sure what you mean.

You'll have to set that in every Rails project you create, yes, just like you might have a different password for each database or environment you might have.
0
 
catonthecouchproductionsAuthor Commented:
Thank you both! i will give that a try!

Ryan
0
All Courses

From novice to tech pro — start learning today.