質問編集履歴
4
database.php追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -82,3 +82,153 @@
|
|
82
82
|
"options" => [],
|
83
83
|
]
|
84
84
|
```
|
85
|
+
```database.php
|
86
|
+
<?php
|
87
|
+
|
88
|
+
use Illuminate\Support\Str;
|
89
|
+
|
90
|
+
return [
|
91
|
+
|
92
|
+
/*
|
93
|
+
|--------------------------------------------------------------------------
|
94
|
+
| Default Database Connection Name
|
95
|
+
|--------------------------------------------------------------------------
|
96
|
+
|
|
97
|
+
| Here you may specify which of the database connections below you wish
|
98
|
+
| to use as your default connection for all database work. Of course
|
99
|
+
| you may use many connections at once using the Database library.
|
100
|
+
|
|
101
|
+
*/
|
102
|
+
|
103
|
+
'default' => env('DB_CONNECTION', 'mysql'),
|
104
|
+
|
105
|
+
/*
|
106
|
+
|--------------------------------------------------------------------------
|
107
|
+
| Database Connections
|
108
|
+
|--------------------------------------------------------------------------
|
109
|
+
|
|
110
|
+
| Here are each of the database connections setup for your application.
|
111
|
+
| Of course, examples of configuring each database platform that is
|
112
|
+
| supported by Laravel is shown below to make development simple.
|
113
|
+
|
|
114
|
+
|
|
115
|
+
| All database work in Laravel is done through the PHP PDO facilities
|
116
|
+
| so make sure you have the driver for your particular database of
|
117
|
+
| choice installed on your machine before you begin development.
|
118
|
+
|
|
119
|
+
*/
|
120
|
+
|
121
|
+
'connections' => [
|
122
|
+
|
123
|
+
'sqlite' => [
|
124
|
+
'driver' => 'sqlite',
|
125
|
+
'url' => env('DATABASE_URL'),
|
126
|
+
'database' => env('DB_DATABASE', database_path('database.sqlite')),
|
127
|
+
'prefix' => '',
|
128
|
+
'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
|
129
|
+
],
|
130
|
+
|
131
|
+
'mysql' => [
|
132
|
+
'driver' => 'mysql',
|
133
|
+
'url' => env('DATABASE_URL'),
|
134
|
+
'host' => env('DB_HOST', '127.0.0.1'),
|
135
|
+
'port' => env('DB_PORT', '3306'),
|
136
|
+
'database' => env('DB_DATABASE', 'forge'),
|
137
|
+
'username' => env('DB_USERNAME', 'forge'),
|
138
|
+
'password' => env('DB_PASSWORD', ''),
|
139
|
+
'unix_socket' => env('DB_SOCKET', ''),
|
140
|
+
'charset' => 'utf8mb4',
|
141
|
+
'collation' => 'utf8mb4_unicode_ci',
|
142
|
+
'prefix' => '',
|
143
|
+
'prefix_indexes' => true,
|
144
|
+
'strict' => true,
|
145
|
+
'engine' => null,
|
146
|
+
'options' => extension_loaded('pdo_mysql') ? array_filter([
|
147
|
+
PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
|
148
|
+
]) : [],
|
149
|
+
],
|
150
|
+
|
151
|
+
'pgsql' => [
|
152
|
+
'driver' => 'pgsql',
|
153
|
+
'url' => env('DATABASE_URL'),
|
154
|
+
'host' => env('DB_HOST', '127.0.0.1'),
|
155
|
+
'port' => env('DB_PORT', '5432'),
|
156
|
+
'database' => env('DB_DATABASE', 'forge'),
|
157
|
+
'username' => env('DB_USERNAME', 'forge'),
|
158
|
+
'password' => env('DB_PASSWORD', ''),
|
159
|
+
'charset' => 'utf8',
|
160
|
+
'prefix' => '',
|
161
|
+
'prefix_indexes' => true,
|
162
|
+
'schema' => 'public',
|
163
|
+
'sslmode' => 'prefer',
|
164
|
+
],
|
165
|
+
|
166
|
+
'sqlsrv' => [
|
167
|
+
'driver' => 'sqlsrv',
|
168
|
+
'url' => env('DATABASE_URL'),
|
169
|
+
'host' => env('DB_HOST', 'localhost'),
|
170
|
+
'port' => env('DB_PORT', '1433'),
|
171
|
+
'database' => env('DB_DATABASE', 'forge'),
|
172
|
+
'username' => env('DB_USERNAME', 'forge'),
|
173
|
+
'password' => env('DB_PASSWORD', ''),
|
174
|
+
'charset' => 'utf8',
|
175
|
+
'prefix' => '',
|
176
|
+
'prefix_indexes' => true,
|
177
|
+
],
|
178
|
+
|
179
|
+
],
|
180
|
+
|
181
|
+
/*
|
182
|
+
|--------------------------------------------------------------------------
|
183
|
+
| Migration Repository Table
|
184
|
+
|--------------------------------------------------------------------------
|
185
|
+
|
|
186
|
+
| This table keeps track of all the migrations that have already run for
|
187
|
+
| your application. Using this information, we can determine which of
|
188
|
+
| the migrations on disk haven't actually been run in the database.
|
189
|
+
|
|
190
|
+
*/
|
191
|
+
|
192
|
+
'migrations' => 'migrations',
|
193
|
+
|
194
|
+
/*
|
195
|
+
|--------------------------------------------------------------------------
|
196
|
+
| Redis Databases
|
197
|
+
|--------------------------------------------------------------------------
|
198
|
+
|
|
199
|
+
| Redis is an open source, fast, and advanced key-value store that also
|
200
|
+
| provides a richer body of commands than a typical key-value system
|
201
|
+
| such as APC or Memcached. Laravel makes it easy to dig right in.
|
202
|
+
|
|
203
|
+
*/
|
204
|
+
|
205
|
+
'redis' => [
|
206
|
+
|
207
|
+
'client' => env('REDIS_CLIENT', 'phpredis'),
|
208
|
+
|
209
|
+
'options' => [
|
210
|
+
'cluster' => env('REDIS_CLUSTER', 'redis'),
|
211
|
+
'prefix' => env('REDIS_PREFIX', Str::slug(env('APP_NAME', 'laravel'), '_').'_database_'),
|
212
|
+
],
|
213
|
+
|
214
|
+
'default' => [
|
215
|
+
'url' => env('REDIS_URL'),
|
216
|
+
'host' => env('REDIS_HOST', '127.0.0.1'),
|
217
|
+
'password' => env('REDIS_PASSWORD', null),
|
218
|
+
'port' => env('REDIS_PORT', '6379'),
|
219
|
+
'database' => env('REDIS_DB', '0'),
|
220
|
+
],
|
221
|
+
|
222
|
+
'cache' => [
|
223
|
+
'url' => env('REDIS_URL'),
|
224
|
+
'host' => env('REDIS_HOST', '127.0.0.1'),
|
225
|
+
'password' => env('REDIS_PASSWORD', null),
|
226
|
+
'port' => env('REDIS_PORT', '6379'),
|
227
|
+
'database' => env('REDIS_CACHE_DB', '1'),
|
228
|
+
],
|
229
|
+
|
230
|
+
],
|
231
|
+
|
232
|
+
];
|
233
|
+
|
234
|
+
```
|
3
configを追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -61,13 +61,24 @@
|
|
61
61
|
MIX_PUSHER_APP_KEY="${PUSHER_APP_KEY}"
|
62
62
|
MIX_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"
|
63
63
|
```
|
64
|
-
|
64
|
+
|
65
|
-
envの下記を消してマイグレしなおしても同じエラーが出ています。env以外でDBの接続を変更するところはありますか?
|
66
65
|
```ここに言語を入力
|
66
|
+
>>> config('database.connections.mysql')
|
67
|
+
=> [
|
68
|
+
"driver" => "mysql",
|
67
|
-
|
69
|
+
"url" => null,
|
68
|
-
|
70
|
+
"host" => "127.0.0.1",
|
69
|
-
|
71
|
+
"port" => "3306",
|
72
|
+
"database" => "laravel",
|
73
|
+
"username" => "root",
|
74
|
+
"password" => "",
|
75
|
+
"unix_socket" => "",
|
76
|
+
"charset" => "utf8mb4",
|
77
|
+
"collation" => "utf8mb4_unicode_ci",
|
78
|
+
"prefix" => "",
|
79
|
+
"prefix_indexes" => true,
|
70
|
-
|
80
|
+
"strict" => true,
|
81
|
+
"engine" => null,
|
71
|
-
|
82
|
+
"options" => [],
|
72
|
-
|
83
|
+
]
|
73
84
|
```
|
2
追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -2,17 +2,6 @@
|
|
2
2
|
mysqlでtimeのデータベースを作成しました。
|
3
3
|
laravelのenvを変更しマイグレーションしようとしたのですが下記のエラーが出てしまいました。
|
4
4
|
mysqlのDBでtimeは作成されていること確認済みです。
|
5
|
-
|
6
|
-
追記
|
7
|
-
envの下記を消してマイグレしなおしても同じエラーが出ています。env以外でDBの接続を変更するところはありますか?
|
8
|
-
```ここに言語を入力
|
9
|
-
DB_CONNECTION=mysql
|
10
|
-
DB_HOST=127.0.0.1
|
11
|
-
DB_PORT=3306
|
12
|
-
DB_DATABASE=time
|
13
|
-
DB_USERNAME=root
|
14
|
-
DB_PASSWORD=
|
15
|
-
```
|
16
5
|
|
17
6
|
|
18
7
|
SQLSTATE[HY000] [1049] Unknown database 'laravel' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
|
@@ -72,4 +61,13 @@
|
|
72
61
|
MIX_PUSHER_APP_KEY="${PUSHER_APP_KEY}"
|
73
62
|
MIX_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"
|
74
63
|
```
|
75
|
-
|
64
|
+
追記
|
65
|
+
envの下記を消してマイグレしなおしても同じエラーが出ています。env以外でDBの接続を変更するところはありますか?
|
66
|
+
```ここに言語を入力
|
67
|
+
DB_CONNECTION=mysql
|
68
|
+
DB_HOST=127.0.0.1
|
69
|
+
DB_PORT=3306
|
70
|
+
DB_DATABASE=time
|
71
|
+
DB_USERNAME=root
|
72
|
+
DB_PASSWORD=
|
73
|
+
```
|
1
追記しました
test
CHANGED
File without changes
|
test
CHANGED
@@ -1,7 +1,18 @@
|
|
1
1
|
windowsでxampp
|
2
2
|
mysqlでtimeのデータベースを作成しました。
|
3
|
-
laravelのenvを変更しマイグレーションしようとしたのですが下記のエラーが出てしまいました。
|
3
|
+
laravelのenvを変更しマイグレーションしようとしたのですが下記のエラーが出てしまいました。
|
4
4
|
mysqlのDBでtimeは作成されていること確認済みです。
|
5
|
+
|
6
|
+
追記
|
7
|
+
envの下記を消してマイグレしなおしても同じエラーが出ています。env以外でDBの接続を変更するところはありますか?
|
8
|
+
```ここに言語を入力
|
9
|
+
DB_CONNECTION=mysql
|
10
|
+
DB_HOST=127.0.0.1
|
11
|
+
DB_PORT=3306
|
12
|
+
DB_DATABASE=time
|
13
|
+
DB_USERNAME=root
|
14
|
+
DB_PASSWORD=
|
15
|
+
```
|
5
16
|
|
6
17
|
|
7
18
|
SQLSTATE[HY000] [1049] Unknown database 'laravel' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
|