Laravel5.4 Unknown character set: 'utf8mb4'
原文:http://www.xiaoshu168.com/php/200.html
[PDOException]SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: 'utf8mb4'原因是因为mysql5.1之前没有utf8mb4编码,laravel5之后mysql编码默认设置成了utf8mb4,如果你的mysql版本低就不能支持utf8mb4。
解决方法:
config/database.php 'mysql' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => 'api_', 'strict' => true, 'engine' => null, ], 修改为 'mysql' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => 'api_', 'strict' => true, 'engine' => null, ],