rake db:create をした際にこのようなエラーが出ます。このエラーはなんでしょうか？

Question

rake db:create をした際にこのようなエラーが出ます。このエラーはなんでしょうか？

aberyuuryoku-no-MacBook-Air:butelr 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, "host"=>"localhost", "database"=>"butelr_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, "host"=>"localhost", "database"=>"butelr_test"}, {:charset=>"utf8", :collation=>"utf8_unicode_ci"}
(If you set the charset manually, make sure you have a matching collation)

Answer 1

接続に失敗しているようですね、database.ymlの内容を確認してみてください。
"password"=>nil となっていますが、MySQLにパスワードは設定していないのでしょうか？

Comments

[AbeRyuki]

yml はこんな感じです????

default: &default
adapter: mysql2
encoding: utf8
pool: 5
username: root
password:
socket: /tmp/mysql.sock

development:
<<: *default
database: butelr_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: butelr_test

[AbeRyuki]

いろいろ試して今はこのようになりました。

aberyuuryoku-no-MacBook-Air:butelr ryuki$ rake db:cereate
rake aborted!
Don't know how to build task 'db:cereate' (see --tasks)

(See full trace by running task with --trace)

[ShoheiUyama]

db:create と言うタスクがないというエラーになっていますね、コマンドを実行する場所は正しいですか？

Answer 2

mysql起動させましょう、起動確認後にdatabase.yml眺めてみましょう。username, password, database間違っていないか。

Comments

[AbeRyuki]

brew install mysql→ mysql.server start

この手順で起動でまちがいないでしょうか？
エラーが出ます????

　　　aberyuuryoku-no-MacBook-Air:butelr ryuki$ brew install mysql

==> Installing dependencies for mysql: openssl
==> Installing mysql dependency: openssl
==> Downloading https://homebrew.bintray.com/bottles/openssl-1.0.2h_1.el_capitan

######################################################################## 100.0%
==> Pouring openssl-1.0.2h_1.el_capitan.bottle.tar.gz
==> Caveats
A CA file has been bootstrapped using certificates from the system
keychain. To add additional certificates, place .pem files in
/usr/local/etc/openssl/certs

and run
/usr/local/opt/openssl/bin/c_rehash

This formula is keg-only, which means it was not symlinked into /usr/local.

Apple has deprecated use of OpenSSL in favor of its own TLS and crypto libraries

Generally there are no consequences of this for you. If you build your
own software and it requires this formula, you'll need to add to your
build variables:

LDFLAGS: -L/usr/local/opt/openssl/lib
CPPFLAGS: -I/usr/local/opt/openssl/include

==> Summary
???? /usr/local/Cellar/openssl/1.0.2h_1: 1,691 files, 12M
==> Installing mysql
==> Downloading https://homebrew.bintray.com/bottles/mysql-5.7.12.el_capitan.bot
######################################################################## 100.0%
==> Pouring mysql-5.7.12.el_capitan.bottle.tar.gz

aberyuuryoku-no-MacBook-Air:butelr ryuki$ mysql.server start
　　Starting MySQL
..................................................................................................... ERROR! The server quit withoutupdating PID file (/usr/local/var/mysql/aberyuuryoku-no-MacBook-Air.local.pid).

[KeitaSuzuki]

ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents

このコマンドで解決できないでしょうか。
以前にこのページでそのエラーを解決できたことあります。

http://harry-the-cat.doorblog.jp/archives/cat_680355.html

[AbeRyuki]

ちなみにいろいろ試して今はこのようになりました。

aberyuuryoku-no-MacBook-Air:butelr ryuki$ rake db:cereate
rake aborted!
Don't know how to build task 'db:cereate' (see --tasks)

(See full trace by running task with --trace)

Answer 3

MySQLに繋がっていない状態です。接続設定を確認しましょう。

Comments

[AbeRyuki]

ちなみにいろいろ試して今はこのようになりました。

aberyuuryoku-no-MacBook-Air:butelr ryuki$ rake db:cereate
rake aborted!
Don't know how to build task 'db:cereate' (see --tasks)

(See full trace by running task with --trace)