/SQL/Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

$ sudo mysql -u root -p
Now you can add a new MySQL user with the username of your choice.

mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
And finally grant superuser privileges to the user you just created.

mysql> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

after that go and edit .env DB_USERNAME=newuser
DB_PASSWORD=password

Source: stackoverflow.com

Similar codes

10 votes351 views1 answer
Oracle dependencies table
SQL
4 votes338 views1 answer
Mysql timestamp in laravel migration
SQL
6 votes320 views1 answer
Sqlite foreign key
SQL
0 vote354 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote297 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote308 views1 answer
Sql requete number pair
SQL
8 votes434 views1 answer
Mysql dump restore
SQL
0 vote349 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
1 vote337 views2 answers
List tables sqlalchemy
SQL
0 vote346 views1 answer
Call function sql oracle with output put line
SQL