/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 vote173 views1 answer
Postgresql delete multiple rows
SQL
1 vote183 views1 answer
Set statiscis on in ssms
SQL
0 vote174 views1 answer
Postgres list tables and row counts
SQL
3 votes180 views1 answer
Sql double index
SQL
1 vote172 views1 answer
Mamp mysql path mac
SQL
0 vote175 views1 answer
Sql developer connect to sql server
SQL
10 votes186 views6 answers
Between sql
SQL
0 vote168 views1 answer
Sql count null as 0
SQL
1 vote172 views1 answer
How to run sql script
SQL
0 vote177 views2 answers
2nd max salary query in sql
SQL