SHOW:
|
|
- or go back to the newest paste.
1 | <?php | |
2 | ||
3 | // config/app.php részlet | |
4 | ||
5 | 'Datasources' => [ | |
6 | 'default' => [ | |
7 | 'className' => 'Cake\Database\Connection', | |
8 | 'driver' => 'Cake\Database\Driver\Mysql', | |
9 | 'persistent' => true, | |
10 | 'host' => 'localhost', | |
11 | /* | |
12 | * CakePHP will use the default DB port based on the driver selected | |
13 | * MySQL on MAMP uses port 8889, MAMP users will want to uncomment | |
14 | * the following line and set the port accordingly | |
15 | */ | |
16 | //'port' => 'non_standard_port_number', | |
17 | 'username' => 'user', | |
18 | 'password' => '123', | |
19 | 'database' => 'laksmi', | |
20 | /* | |
21 | * You do not need to set this flag to use full utf-8 encoding (internal default since CakePHP 3.6). | |
22 | */ | |
23 | //'encoding' => 'utf8mb4', | |
24 | 'timezone' => 'UTC', | |
25 | 'flags' => [], | |
26 | 'cacheMetadata' => true, | |
27 | 'log' => false, | |
28 | ||
29 | /** | |
30 | * Set identifier quoting to true if you are using reserved words or | |
31 | * special characters in your table or column names. Enabling this | |
32 | * setting will result in queries built using the Query Builder having | |
33 | * identifiers quoted when creating SQL. It should be noted that this | |
34 | * decreases performance because each query needs to be traversed and | |
35 | * manipulated before being executed. | |
36 | */ | |
37 | 'quoteIdentifiers' => true, | |
38 | ||
39 | /** | |
40 | * During development, if using MySQL < 5.6, uncommenting the | |
41 | * following line could boost the speed at which schema metadata is | |
42 | * fetched from the database. It can also be set directly with the | |
43 | * mysql configuration directive 'innodb_stats_on_metadata = 0' | |
44 | * which is the recommended value in production environments | |
45 | */ | |
46 | //'init' => ['SET GLOBAL innodb_stats_on_metadata = 0'], | |
47 | ||
48 | 'url' => env('DATABASE_URL', null), | |
49 | ], | |
50 | ||
51 | /** | |
52 | * The test connection is used during the test suite. | |
53 | */ | |
54 | 'test' => [ | |
55 | 'className' => 'Cake\Database\Connection', | |
56 | 'driver' => 'Cake\Database\Driver\Mysql', | |
57 | 'persistent' => false, | |
58 | 'host' => 'localhost', | |
59 | //'port' => 'non_standard_port_number', | |
60 | 'username' => 'user', | |
61 | 'password' => '123', | |
62 | 'database' => 'cakephp_test', | |
63 | //'encoding' => 'utf8mb4', | |
64 | 'timezone' => 'UTC', | |
65 | 'cacheMetadata' => true, | |
66 | 'quoteIdentifiers' => false, | |
67 | 'log' => false, | |
68 | //'init' => ['SET GLOBAL innodb_stats_on_metadata = 0'], | |
69 | 'url' => env('DATABASE_TEST_URL', null), | |
70 | ], | |
71 | ||
72 | 'rrd' => [ | |
73 | 'className' => 'Cake\Database\Connection', | |
74 | 'driver' => 'Cake\Database\Driver\Mysql', | |
75 | 'persistent' => false, | |
76 | 'host' => 'localhost', | |
77 | //'port' => 'non_standard_port_number', | |
78 | 'username' => 'user', | |
79 | 'password' => '123', | |
80 | 'database' => 'woo', | |
81 | //'encoding' => 'utf8mb4', | |
82 | 'timezone' => 'UTC', | |
83 | 'cacheMetadata' => true, | |
84 | 'quoteIdentifiers' => false, | |
85 | 'log' => false, | |
86 | //'init' => ['SET GLOBAL innodb_stats_on_metadata = 0'], | |
87 | 'url' => env('DATABASE_URL', null), | |
88 | ], | |
89 | ], |