/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

0 vote362 views3 answers
Create and attach user to a postgresql database
SQL
3 votes359 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote339 views1 answer
Install package for sqlserver in asp.net core
SQL
7 votes341 views3 answers
How to check table name in current database sql
SQL
5 votes364 views1 answer
How to get all table names in sql query
SQL
0 vote310 views1 answer
Create duplicate table in postgresql
SQL
0 vote362 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote324 views1 answer
Get duplicate entry sql
SQL
4 votes329 views1 answer
Wilayah indonesia sql
SQL
-1 vote374 views3 answers
Error: mysql shutdown unexpectedly.
SQL