/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 vote235 views2 answers
Mysql password error create datbase
SQL
0 vote236 views1 answer
Plsql check for string in numeric
SQL
15 votes241 views2 answers
Select Options
SQL
1 vote237 views1 answer
Mysql stop password policy
SQL
0 vote258 views1 answer
Nvl2 syntax
SQL
0 vote252 views1 answer
Sql sum if
SQL
0 vote250 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
1 vote226 views1 answer
Real world example of nosql
SQL
-1 vote235 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
0 vote189 views1 answer
How to connect sql server using ip address in c#
SQL