質問編集履歴
4
コードブロックへの変更
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -138,6 +138,57 @@
|
|
|
138
138
|
"engine" => null,
|
|
139
139
|
"options" => [],
|
|
140
140
|
],
|
|
141
|
+
"pgsql" => [
|
|
142
|
+
"driver" => "pgsql",
|
|
143
|
+
"url" => null,
|
|
144
|
+
"host" => "127.0.0.1",
|
|
145
|
+
"port" => "3306",
|
|
146
|
+
"database" => "homestead",
|
|
147
|
+
"username" => "homestead",
|
|
148
|
+
"password" => "secret",
|
|
149
|
+
"charset" => "utf8",
|
|
150
|
+
"prefix" => "",
|
|
151
|
+
"prefix_indexes" => true,
|
|
152
|
+
"schema" => "public",
|
|
153
|
+
"sslmode" => "prefer",
|
|
154
|
+
],
|
|
155
|
+
"sqlsrv" => [
|
|
156
|
+
"driver" => "sqlsrv",
|
|
157
|
+
"url" => null,
|
|
158
|
+
"host" => "127.0.0.1",
|
|
159
|
+
"port" => "3306",
|
|
160
|
+
"database" => "homestead",
|
|
161
|
+
"username" => "homestead",
|
|
162
|
+
"password" => "secret",
|
|
163
|
+
"charset" => "utf8",
|
|
164
|
+
"prefix" => "",
|
|
165
|
+
"prefix_indexes" => true,
|
|
166
|
+
],
|
|
167
|
+
],
|
|
168
|
+
"migrations" => "migrations",
|
|
169
|
+
"redis" => [
|
|
170
|
+
"client" => "predis",
|
|
171
|
+
"options" => [
|
|
172
|
+
"cluster" => "predis",
|
|
173
|
+
"prefix" => "laravel_database_",
|
|
174
|
+
],
|
|
175
|
+
"default" => [
|
|
176
|
+
"url" => null,
|
|
177
|
+
"host" => "127.0.0.1",
|
|
178
|
+
"password" => null,
|
|
179
|
+
"port" => "6379",
|
|
180
|
+
"database" => 0,
|
|
181
|
+
],
|
|
182
|
+
"cache" => [
|
|
183
|
+
"url" => null,
|
|
184
|
+
"host" => "127.0.0.1",
|
|
185
|
+
"password" => null,
|
|
186
|
+
"port" => "6379",
|
|
187
|
+
"database" => 1,
|
|
188
|
+
],
|
|
189
|
+
],
|
|
190
|
+
]
|
|
191
|
+
>>>
|
|
141
192
|
|
|
142
193
|
```
|
|
143
194
|
|
3
コード追記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -106,6 +106,43 @@
|
|
|
106
106
|
}
|
|
107
107
|
}
|
|
108
108
|
```
|
|
109
|
+
php artisan tinker実行結果
|
|
110
|
+
```ここに言語を入力
|
|
111
|
+
[vagrant@localhost practice]$ php artisan tinker
|
|
112
|
+
Psy Shell v0.9.9 (PHP 7.1.32 — cli) by Justin Hileman
|
|
113
|
+
>>> config('database')
|
|
114
|
+
=> [
|
|
115
|
+
"default" => "mysql",
|
|
116
|
+
"connections" => [
|
|
117
|
+
"sqlite" => [
|
|
118
|
+
"driver" => "sqlite",
|
|
119
|
+
"url" => null,
|
|
120
|
+
"database" => "/home/vagrant/laravel_lessons/practice/database/database.sqlite",
|
|
121
|
+
"prefix" => "",
|
|
122
|
+
"foreign_key_constraints" => true,
|
|
123
|
+
],
|
|
124
|
+
"mysql" => [
|
|
125
|
+
"driver" => "mysql",
|
|
126
|
+
"url" => null,
|
|
127
|
+
"host" => "127.0.0.1",
|
|
128
|
+
"port" => "3306",
|
|
129
|
+
"database" => "homestead",
|
|
130
|
+
"username" => "homestead",
|
|
131
|
+
"password" => "secret",
|
|
132
|
+
"unix_socket" => "/Applications/MAMP/tmp/mysql/mysql.sock",
|
|
133
|
+
"charset" => "utf8mb4",
|
|
134
|
+
"collation" => "utf8mb4_unicode_ci",
|
|
135
|
+
"prefix" => "",
|
|
136
|
+
"prefix_indexes" => true,
|
|
137
|
+
"strict" => true,
|
|
138
|
+
"engine" => null,
|
|
139
|
+
"options" => [],
|
|
140
|
+
],
|
|
141
|
+
|
|
142
|
+
```
|
|
143
|
+
|
|
144
|
+
|
|
145
|
+
|
|
109
146
|
**試したこと**
|
|
110
147
|
エラーメッセージをコピーし、検索にかけてみましたが分かりませんでした。
|
|
111
148
|
初歩的な問題かもしれませんが、どうかよろしくお願い致します。
|
2
コードブロックへの変更
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -5,8 +5,8 @@
|
|
|
5
5
|
laravelとMySQLの接続ができません。
|
|
6
6
|
php artisan migrateでエラーが表示されました。
|
|
7
7
|
|
|
8
|
-
[
|
|
8
|
+
[http://qiita.com/yoriblog/items/60b7cea4f991b842022f](http://qiita.com/yoriblog/items/60b7cea4f991b842022f)
|
|
9
|
-
[
|
|
9
|
+
[https://qiita.com/coldsleep6666/items/506fd6a92ff29aee90bb](https://qiita.com/coldsleep6666/items/506fd6a92ff29aee90bb)
|
|
10
10
|
これらのサイトなど試してみましたが、出来ませんでした。
|
|
11
11
|
因みにhomesteadは利用していません。
|
|
12
12
|
|
1
リンクタグの追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -5,13 +5,15 @@
|
|
|
5
5
|
laravelとMySQLの接続ができません。
|
|
6
6
|
php artisan migrateでエラーが表示されました。
|
|
7
7
|
|
|
8
|
-
|
|
8
|
+
[リンク内容](http://qiita.com/yoriblog/items/60b7cea4f991b842022f)
|
|
9
|
-
https://qiita.com/coldsleep6666/items/506fd6a92ff29aee90bb
|
|
9
|
+
[リンク内容](https://qiita.com/coldsleep6666/items/506fd6a92ff29aee90bb)
|
|
10
10
|
これらのサイトなど試してみましたが、出来ませんでした。
|
|
11
11
|
因みにhomesteadは利用していません。
|
|
12
12
|
|
|
13
13
|
**発生している問題・エラーメッセージ**
|
|
14
|
+
|
|
14
|
-
|
|
15
|
+
コマンド上
|
|
16
|
+
```
|
|
15
17
|
[vagrant@localhost practice]$ php artisan migrate
|
|
16
18
|
|
|
17
19
|
Illuminate\Database\QueryException : SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = homestead and table_name = migrations and table_type = 'BASE TABLE')
|
|
@@ -37,7 +39,9 @@
|
|
|
37
39
|
|
|
38
40
|
Please use the argument -v to see more details.
|
|
39
41
|
```
|
|
42
|
+
|
|
40
|
-
|
|
43
|
+
.env
|
|
44
|
+
```
|
|
41
45
|
DB_CONNECTION=mysql
|
|
42
46
|
DB_HOST=127.0.0.1
|
|
43
47
|
DB_PORT=3306
|
|
@@ -45,7 +49,8 @@
|
|
|
45
49
|
DB_USERNAME=設定した名前
|
|
46
50
|
DB_PASSWORD=設定したパス
|
|
47
51
|
```
|
|
48
|
-
|
|
52
|
+
database.php
|
|
53
|
+
```
|
|
49
54
|
'mysql' => [
|
|
50
55
|
'driver' => 'mysql',
|
|
51
56
|
'url' => env('DATABASE_URL'),
|
|
@@ -67,8 +72,8 @@
|
|
|
67
72
|
]) : [],
|
|
68
73
|
],
|
|
69
74
|
```
|
|
70
|
-
|
|
71
|
-
|
|
75
|
+
AppServiceProvider.php
|
|
76
|
+
```
|
|
72
77
|
<?php
|
|
73
78
|
|
|
74
79
|
namespace App\Providers;
|