このエラーはなでしょうか?
データベースを作成したいのですがエラーが出てしまいます。
多分socketの問題だとは思うのですが。
aberyuuryoku-no-MacBook-Air:pictweet ryuki$ rake db:create
#<Mysql2::Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)>
Couldn't create database for {"adapter"=>"mysql2", "encoding"=>"utf8", "pool"=>5, "username"=>"root", "password"=>nil, "socket"=>"/tmp/mysql.sock", "database"=>"pictweet_development"}, {:charset=>"utf8", :collation=>"utf8_unicode_ci"}
(If you set the charset manually, make sure you have a matching collation)
#<Mysql2::Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)>
Couldn't create database for {"adapter"=>"mysql2", "encoding"=>"utf8", "pool"=>5, "username"=>"root", "password"=>nil, "socket"=>"/tmp/mysql.sock", "database"=>"pictweet_test"}, {:charset=>"utf8", :collation=>"utf8_unicode_ci"}
(If you set the charset manually, make sure you have a matching collation)
detabase.yml➡︎
MySQL. Versions 5.0+ are recommended.
Install the MYSQL driver
gem install mysql2
Ensure the MySQL gem is defined in your Gemfile
gem 'mysql2'
And be sure to use new-style password hashing:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
default: &default
adapter: mysql2
encoding: utf8
pool: 5
username: root
password:
socket: /tmp/mysql.sock
development:
<<: *default
database: pictweet_development
Warning: The database defined as "test" will be erased and
re-generated from your development database when you run "rake".
Do not set this db to the same as development or production.
test:
<<: *default
database: pictweet_test
As with config/secrets.yml, you never want to store sensitive information,
like your database password, in your source code. If your source code is
ever seen by anyone, they now have access to your database.
Instead, provide the password as a unix environment variable when you boot
the app. Read http://guides.rubyonrails.org/configuring.html#configuring-a-database
for a full rundown on how to provide these environment variables in a
production deployment.
On Heroku and other platform providers, you may have a full connection URL
available as an environment variable. For example:
DATABASE_URL="mysql2://myuser:mypass@localhost/somedatabase"
You can use this database configuration with:
production:
url: <%= ENV['DATABASE_URL'] %>
production:
<<: *default
database: pictweet_production
username: pictweet
password: <%= ENV['PICTWEET_DATABASE_PASSWORD'] %>
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2016/05/16 09:48
2016/05/16 13:13
2016/05/16 14:46 編集