/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 vote265 views2 answers
Get all index postgres
SQL
0 vote280 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
1 vote289 views3 answers
Mysql parse int
SQL
0 vote250 views1 answer
Is not null postgresql
SQL
10 votes292 views4 answers
Else if mysql
SQL
0 vote281 views4 answers
Mysql desactivar trigger
SQL
0 vote264 views1 answer
How to fix mysql stop unexpectedly
SQL
2 votes318 views3 answers
How to replace null values in sql
SQL
3 votes299 views2 answers
Mysql update row
SQL
0 vote246 views2 answers
Avg() sql
SQL