/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 vote168 views1 answer
Mysql offset from bottom
SQL
2 votes210 views2 answers
Insert all in sql
SQL
0 vote207 views1 answer
Mysql add root password
SQL
0 vote206 views1 answer
Json not contains mysql
SQL
0 vote220 views2 answers
List all constraints in postgres
SQL
0 vote269 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote206 views1 answer
How to import sqlite driver class in java using maven
SQL
3 votes161 views4 answers
Mysql delete duplicate rows
SQL
0 vote236 views1 answer
Mysql wait_timeout
SQL
2 votes271 views1 answer
Mysql now format
SQL