Home / Questions / 312957
Accepted
qwerty
Asked: 2020-12-02 09:56:16 +0800 CST 2020-12-02 09:56:16 +0800 CST

在 Laravel 中连接数据库时出错

  • 772

您好，我在进行迁移时尝试从 Angular 连接到 mysql 数据库时遇到问题

php artisan migrate

我收到以下错误

Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] 用户 'root'@'localhost' 的访问被拒绝（SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE'）

我已经从 mysql 授予它访问权限，grant on *.*但错误仍然存​​在

.env

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=pass
mysql

1 Answers

  1. Best Answer

    我通过修改密钥来解决它

    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new-password';
    • 2