/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

1 vote442 views1 answer
Postgresql can you have null foreign key
SQL
0 vote440 views1 answer
How to add auto increment primary key
SQL
0 vote378 views1 answer
Set Mamp mysql globally
SQL
0 vote398 views2 answers
Postgres isnull
SQL
7 votes381 views4 answers
Mysql delete older duplicates
SQL
0 vote393 views1 answer
Sql injection payload list github
SQL
0 vote359 views1 answer
What is the difference between now() and current_date()?
SQL
2 votes376 views1 answer
Search query in mysql
SQL
0 vote360 views1 answer
Insert output identity
SQL
0 vote368 views1 answer
Python list from sql
SQL