teratail
回答率
85.48%
質問するログイン新規登録
トップに関する質問SQLSTATE[HY000][1049]

編集履歴

質問編集履歴

2

\.envのところにdatabase\.phpを貼り付けていたので修正

2017/08/18 10:50

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -52,6 +52,84 @@
52
52
 
53
53
 
54
54
 
55
+ .env
56
+
57
+ ```
58
+
59
+ APP_NAME=Laravel
60
+
61
+ APP_ENV=local
62
+
63
+ APP_KEY=base64:eqUQ0WTmJWsutQBJhYPQ7CqxsY6pukKXmLMQ0U+oYIo=
64
+
65
+ APP_DEBUG=true
66
+
67
+ APP_LOG_LEVEL=debug
68
+
69
+ APP_URL=http://localhost
70
+
71
+
72
+
73
+ DB_CONNECTION=sqlite
74
+
75
+ DB_HOST=localhost
76
+
77
+ DB_PORT=3306
78
+
79
+ DB_DATABASE=mysql
80
+
81
+ DB_USERNAME=pma
82
+
83
+ DB_PASSWORD=
84
+
85
+ DB_SOCKET=/Applications/XAMMP/xammpfiles/var/mysql/mysql.sock
86
+
87
+
88
+
89
+ BROADCAST_DRIVER=log
90
+
91
+ CACHE_DRIVER=file
92
+
93
+ SESSION_DRIVER=file
94
+
95
+ QUEUE_DRIVER=sync
96
+
97
+
98
+
99
+ REDIS_HOST=127.0.0.1
100
+
101
+ REDIS_PASSWORD=null
102
+
103
+ REDIS_PORT=6379
104
+
105
+
106
+
107
+ MAIL_DRIVER=smtp
108
+
109
+ MAIL_HOST=smtp.mailtrap.io
110
+
111
+ MAIL_PORT=2525
112
+
113
+ MAIL_USERNAME=null
114
+
115
+ MAIL_PASSWORD=null
116
+
117
+ MAIL_ENCRYPTION=null
118
+
119
+
120
+
121
+ PUSHER_APP_ID=
122
+
123
+ PUSHER_APP_KEY=
124
+
125
+ PUSHER_APP_SECRET=
126
+
127
+
128
+
129
+ ```
130
+
131
+
132
+
55
133
  database.php
56
134
 
57
135
  ```
@@ -217,171 +295,3 @@
217
295
  'migrations' => 'migrations',
218
296
 
219
297
  ```
220
-
221
-
222
-
223
- .env
224
-
225
- ```
226
-
227
- 'default' => env('DB_CONNECTION', 'mysql'),
228
-
229
-
230
-
231
- /*
232
-
233
- |--------------------------------------------------------------------------
234
-
235
- | Database Connections
236
-
237
- |--------------------------------------------------------------------------
238
-
239
- |
240
-
241
- | Here are each of the database connections setup for your application.
242
-
243
- | Of course, examples of configuring each database platform that is
244
-
245
- | supported by Laravel is shown below to make development simple.
246
-
247
- |
248
-
249
- |
250
-
251
- | All database work in Laravel is done through the PHP PDO facilities
252
-
253
- | so make sure you have the driver for your particular database of
254
-
255
- | choice installed on your machine before you begin development.
256
-
257
- |
258
-
259
- */
260
-
261
-
262
-
263
- 'connections' => [
264
-
265
-
266
-
267
- 'sqlite' => [
268
-
269
- 'driver' => 'sqlite',
270
-
271
- 'database' => storage_path('database.sqlite'),
272
-
273
- 'prefix' => '',
274
-
275
- ],
276
-
277
-
278
-
279
- 'mysql' => [
280
-
281
- 'driver' => 'mysql',
282
-
283
-
284
-
285
- 'host' => env('DB_HOST', 'localhost'),
286
-
287
- 'port' => env('DB_PORT', '3306'),
288
-
289
- 'database' => env('DB_DATABASE', 'mysql'),
290
-
291
- 'username' => env('DB_USERNAME', 'pma'),
292
-
293
- 'password' => env('DB_PASSWORD', ''),
294
-
295
- 'unix_socket' => env('DB_SOCKET', null),
296
-
297
- 'charset' => 'utf8mb4',
298
-
299
- 'collation' => 'utf8mb4_unicode_ci',
300
-
301
- 'prefix' => '',
302
-
303
- 'strict' => false,
304
-
305
- 'engine' => null,
306
-
307
- ],
308
-
309
-
310
-
311
- 'pgsql' => [
312
-
313
- 'driver' => 'pgsql',
314
-
315
- 'host' => env('DB_HOST', 'localhost'),
316
-
317
- 'port' => env('DB_PORT', '5432'),
318
-
319
- 'database' => env('DB_DATABASE', 'mysql'),
320
-
321
- 'username' => env('DB_USERNAME', 'pma'),
322
-
323
- 'password' => env('DB_PASSWORD', ''),
324
-
325
- 'charset' => 'utf8',
326
-
327
- 'prefix' => '',
328
-
329
- 'schema' => 'public',
330
-
331
- 'sslmode' => 'prefer',
332
-
333
- ],
334
-
335
-
336
-
337
- 'sqlsrv' => [
338
-
339
- 'driver' => 'sqlsrv',
340
-
341
- 'host' => env('DB_HOST', 'localhost'),
342
-
343
- 'port' => env('DB_PORT', '1433'),
344
-
345
- 'database' => env('DB_DATABASE', 'forge'),
346
-
347
- 'username' => env('DB_USERNAME', 'forge'),
348
-
349
- 'password' => env('DB_PASSWORD', ''),
350
-
351
- 'charset' => 'utf8',
352
-
353
- 'prefix' => '',
354
-
355
- ],
356
-
357
-
358
-
359
- ],
360
-
361
-
362
-
363
- /*
364
-
365
- |--------------------------------------------------------------------------
366
-
367
- | Migration Repository Table
368
-
369
- |--------------------------------------------------------------------------
370
-
371
- |
372
-
373
- | This table keeps track of all the migrations that have already run for
374
-
375
- | your application. Using this information, we can determine which of
376
-
377
- | the migrations on disk haven't actually been run in the database.
378
-
379
- |
380
-
381
- */
382
-
383
-
384
-
385
- 'migrations' => 'migrations',
386
-
387
- ```

1

参考サイトURL追記

2017/08/18 10:50

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -1,3 +1,7 @@
1
+ https://laravel10.wordpress.com/2015/02/25/%E5%88%9D%E3%82%81%E3%81%A6%E3%81%AElaravel-5-6-%E3%83%9E%E3%82%A4%E3%82%B0%E3%83%AC%E3%83%BC%E3%82%B7%E3%83%A7%E3%83%B3%E3%81%A7db%E3%81%AE%E3%83%90%E3%83%BC%E3%82%B8%E3%83%A7%E3%83%B3%E7%AE%A1/
2
+
3
+ こちらのサイトを参考にLaravelの学習をしています。
4
+
1
5
  前回の質問に関することは自己解決できました。
2
6
 
3
7
  ですが今度は下記のmigrateを実行した際にタイトルのエラーが出ました。