我正在嘗試在數據庫中創建新的遷移，但是在切換終端中編寫 php yii migrate 后，命令中發生了此錯誤Abdul-fattahs-MacBook-Pro:cust abdul-fattah$ php yii migrateYii Migration Tool (based on Yii v2.0.36)Exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [2006] MySQL server has gone away'in /Applications/MAMP/htdocs/cust/vendor/yiisoft/yii2/db/Connection.php:637Stack trace:#0 /Applications/MAMP/htdocs/cust/vendor/yiisoft/yii2/db/Connection.php(1025): yii\db\Connection->open()#1 /Applications/MAMP/htdocs/cust/vendor/yiisoft/yii2/db/Connection.php(1012): yii\db\Connection->getMasterPdo()#2 /Applications/MAMP/htdocs/cust/vendor/yiisoft/yii2/db/Command.php(255): yii\db\Connection->getSlavePdo()#3 /Applications/MAMP/htdocs/cust/vendor/yiisoft/yii2/db/Command.php(1154): yii\db\Command->prepare(true)#4 /Applications/MAMP/htdocs/cust/vendor/yiisoft/yii2/db/Command.php(401): yii\db\Command->queryInternal('fetchAll', NULL)#5 /Applications/MAMP/htdocs/cust/vendor/yiisoft/yii2/db/mysql/Schema.php(319): yii\db\Command->queryAll()#6 /Applications/MAMP/htdocs/cust/vendor/yiisoft/yii2/db/mysql/Schema.php(125): yii\db\mysql\Schema->findColumns(Object(yii\db\TableSchema))#7 /Applications/MAMP/htdocs/cust/vendor/yiisoft/yii2/db/Schema.php(757): yii\db\mysql\Schema->loadTableSchema('migration')#8 /Applications/MAMP/htdocs/cust/vendor/yiisoft/yii2/db/Schema.php(193): yii\db\Schema->getTableMetadata('{{%migration}}', 'schema', true)#21 {main}這是我在 config/db.php 中的代碼，我無法解決我的問題.......<?phpreturn [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=127.0.0.1;dbname=cust', 'username' => 'root', 'password' => 'root', 'charset' => 'utf8',];
1 回答
繁花不似錦
TA貢獻1851條經驗 獲得超4個贊
這解決了我的問題我添加了端口：8889
<?php
return [
'class' => 'yii\db\Connection',
'dsn' => 'mysql:host=localhost:8889;dbname=cust',
'username' => 'root',
'password' => 'root',
'charset' => 'utf8',
];
- 1 回答
- 0 關注
- 140 瀏覽
添加回答
舉報
0/150
提交
取消