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

Error connecting to database in Laravel

  • 772

Hello, I have a problem when trying to connect to the mysql database from angular when doing a migration

php artisan migrate

I get the following error

Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')

I already gave it access with grant on *.*from mysql but the error persists

.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

    I solved it by modifying the key by means of

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