質問するログイン新規登録

質問編集履歴

3

修正

2020/09/12 22:19

投稿

tomsuma
tomsuma

スコア38

title CHANGED
File without changes
body CHANGED
@@ -14,13 +14,14 @@
14
14
  database.yml
15
15
 
16
16
 
17
+
17
18
  default: &default
18
19
  adapter: mysql2
19
20
  encoding: utf8
20
21
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
21
22
  username: root
22
- password: <%= ENV['DATABASE_PASSWORD'] %>
23
+ password: example
23
- socket: /tmp/mysql.sock
24
+ # socket: /tmp/mysql.sock
24
25
 
25
26
  # host: db
26
27
 
@@ -38,8 +39,7 @@
38
39
 
39
40
  username: root
40
41
  password: <%= ENV['DATABASE_PASSWORD'] %>
41
- socket: /var/lib/mysql/mysql.sock
42
+ # socket: /var/lib/mysql/mysql.sock
42
-
43
43
  ```
44
44
 
45
45
  ```
@@ -68,8 +68,12 @@
68
68
  volumes:
69
69
  mysql-data:
70
70
  ```
71
+ ```
72
+ Creating books_web_run ... done
73
+ Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
74
+ Couldn't create 'Books_development' database. Please check your configuration.
75
+ ```
71
76
 
72
-
73
77
  環境変数が抜けてたので
74
78
 
75
79
  sudo vim /etc/environment

2

エラー修正

2020/09/12 22:19

投稿

tomsuma
tomsuma

スコア38

title CHANGED
@@ -1,1 +1,1 @@
1
- Access denied for user 'root'@'localhost' (using password: NO)
1
+ Access denied for user 'root'@'localhost' (using password: YES)
body CHANGED
@@ -1,5 +1,8 @@
1
1
  Access denied for user 'root'@'localhost' (using password: NO)
2
2
 
3
+ から
4
+ Access denied for user 'root'@'localhost' (using password: YES)
5
+ になりました
3
6
  rails s
4
7
  やdocker-compose up をするとこのエラーが出て困ってます。
5
8
 

1

修正

2020/09/12 11:18

投稿

tomsuma
tomsuma

スコア38

title CHANGED
File without changes
body CHANGED
@@ -37,4 +37,41 @@
37
37
  password: <%= ENV['DATABASE_PASSWORD'] %>
38
38
  socket: /var/lib/mysql/mysql.sock
39
39
 
40
- ```
40
+ ```
41
+
42
+ ```
43
+ version: '3'
44
+ services:
45
+ db:
46
+ image: mysql:5.6
47
+ environment:
48
+ MYSQL_ROOT_PASSWORD: example
49
+ MYSQL_DATABASE: root
50
+ ports:
51
+ - "4306:3306"
52
+ volumes:
53
+ - mysql-data:/var/lib/mysql
54
+ web:
55
+ build: .
56
+ command: bash -c "rm -f tmp/pids/server.pid && bundle exec rails s -p 3000 -b '0.0.0.0'"
57
+ volumes:
58
+ - .:/Books
59
+ ports:
60
+ - 3000:3000
61
+ depends_on:
62
+ - db
63
+ tty: true
64
+ stdin_open: true
65
+ volumes:
66
+ mysql-data:
67
+ ```
68
+
69
+
70
+ 環境変数が抜けてたので
71
+
72
+ sudo vim /etc/environment
73
+
74
+ コマンド後、
75
+ DATABASE_PASSWORD='****'
76
+
77
+ と記入したのですがダメでした