yii2连接mysql_yii2连接数据库失败

yii2连接数据库失败,代码,相关内容,中文网,看一下,解决方法

yii2连接数据库失败

易采站长站，站长之家为您整理了yii2连接数据库失败的相关内容。

首先，先来看一下问题代码：

1、控制器代码如下：public function actionIndex() { $query = Country::find(); $pagination = new Pagination([ &＃39;defaultPageSize&＃39; => 5, &＃39;totalCount&＃39; => $query->count() ]); $countries = $query->orderBy(&＃39;name&＃39;) ->offset($pagination->offset) ->limit($pagination->limit) ->all(); return $this->render(&＃39;index&＃39;, [ &＃39;countries&＃39; => $countries, &＃39;pagination&＃39; => $pagination, ]); }

(推荐教程：yii框架)

2、数据库配置文件db.php代码如下： &＃39;yii\db\Connection&＃39;, &＃39;dsn&＃39; => &＃39;mysql:host=localhost;dbname=yii2basic&＃39;, &＃39;username&＃39; => &＃39;root&＃39;, &＃39;password&＃39; => &＃39;&＃39;, &＃39;charset&＃39; => &＃39;utf8&＃39;, // Schema cache options (for production environment) //&＃39;enableSchemaCache&＃39; => true, //&＃39;schemaCacheDuration&＃39; => 60, //&＃39;schemaCache&＃39; => &＃39;cache&＃39;,];

解决方法：

将PDO连接中的dsn的host由“localhost”改为“127.0.0.1”即可，打开文件DB.PHP，修改如下： &＃39;yii\db\Connection&＃39;, &＃39;dsn&＃39; => &＃39;mysql:host=127.0.0.1;dbname=yii2basic&＃39;, &＃39;username&＃39; => &＃39;root&＃39;, &＃39;password&＃39; => &＃39;&＃39;, &＃39;charset&＃39; => &＃39;utf8&＃39;, // Schema cache options (for production environment) //&＃39;enableSchemaCache&＃39; => true, //&＃39;schemaCacheDuration&＃39; => 60, //&＃39;schemaCache&＃39; => &＃39;cache&＃39;,];

更多编程相关内容，请关注php中文网编程入门栏目！以上就是关于对yii2连接数据库失败的详细介绍。欢迎大家对yii2连接数据库失败内容提出宝贵意见