跟着教程到这一步报错。

php artisan migrate

Illuminate\Database\QueryException : SQLSTATE[HY000] [1130] Host 'learn.test' is not allowed to connect to this MySQL server (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations)

at /var/www/html/learn_laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664

660| // If an exception occurs when attempting to run a query, we'll format the error

661| // message to include the bindings with SQL, which will make this exception a

662| // lot more helpful to the developer instead of just the database's errors.

663| catch (Exception $e) {

> 664| throw new QueryException(

665| $query, $this->prepareBindings($bindings), $e

666| );

667| }

668|

Exception trace:

1 Doctrine\DBAL\Driver\PDOException::("SQLSTATE[HY000] [1130] Host 'learn.test' is not allowed to connect to this MySQL server")

/var/www/html/learn_laravel/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:50

2 PDOException::("SQLSTATE[HY000] [1130] Host 'learn.test' is not allowed to connect to this MySQL server")

/var/www/html/learn_laravel/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:46

Please use the argument -v to see more details.

这是我的数据库配置

陈莺莺呀 2019-12-12

源自：Laravel视图及数据库迁移 2-2 使用 Migrate 创建第一张表

收起

2回答

guly 回答被采纳获得+3积分 2019-12-14 10:39:36

你好，报错原因是因为1071指定密钥太长，最大密钥长度为767字节，

解决办法：

在app/Providers/AppServiceProvider.php文件并在boot方法内设置默认字符串长度：

注：异常中明确指明最大长度是767字节，utf8mb4编码每字符使用4字节，所以 767 / 4 = 191.75，所以将string的默认长度设置为191字符即可，如果解决您的问题请采纳，祝学习愉快！

收起回答

guly 2019-12-13 10:29:20

你好，建议尝试执行以下步骤进行：

1、修改数据库中DB_HOST

DB_CONNECTION=mysql 
DB_HOST=127.0.0.1 
DB_PORT=3306 
DB_DATABASE=laravel
DB_USERNAME= root
DB_PASSWORD= 123456

2、

php artisan config:cache
php artisan cache:clear 
php artisan migrate

注意：（第二步也可以手动删除数据库，然后在执行 php artisan migrate
）

如果解决您的问题请采纳，祝学习愉快！

收起回答

提问者陈莺莺呀 #1

1、将localhost改为了127.0.0.1 2、php artisan config:cache，提示：Configuration cache cleared! Configuration cached successfully! 3、php artisan cache:clear，提示：Cache cleared successfully. 4、php artisan migrate，提示：Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table `test` add index `test_title_index`(`title`))

2019-12-14 10:29:32