提问人:Arafat Rahman 提问时间:1/9/2020 更新时间:1/9/2020 访问量:1885
“SQLSTATE[HY000] [1130] Host '127.0.0.1' is not allowed to connect to this MariaDB server” in Laravel
"SQLSTATE[HY000] [1130] Host '127.0.0.1' is not allowed to connect to this MariaDB server" in Laravel
问:
我想用 CPanel 实时运行一个项目。
但是在浏览网站时出现错误
“SQLSTATE[HY000] [1130] 主机'127.0.0.1'不允许连接到此 MariaDB 服务器”
我已经在phpMyAdmin中创建了数据库,用户名和密码,并在文件中使用它们。.env
.env 文件
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=shirinc1_sencare
DB_USERNAME=shirinc1_sencare
DB_PASSWORD=shirinc1_sencare
也改变config/database.php
'mysql' => [
'driver' => 'mysql',
'url' => env('DATABASE_URL'),
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'shirinc1_sencare'),
'username' => env('DB_USERNAME', 'shirinc1_sencare'),
'password' => env('DB_PASSWORD', 'shirinc1_sencare'),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'prefix_indexes' => true,
'strict' => true,
'engine' => null,
'options' => extension_loaded('pdo_mysql') ? array_filter([
PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
]) : [],
],
但仍然收到此错误。目前还找不到解决方案。
有人帮忙吗?提前致谢。
答: 暂无答案
评论
laravel