/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

4 votes293 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote248 views1 answer
How to convert DateTime to VarChar SQL
SQL
1 vote288 views1 answer
Liquibase alter column type / length
SQL
0 vote259 views1 answer
Mysql locate
SQL
5 votes243 views1 answer
Sql asynchronous stored procedure call
SQL
28 votes264 views6 answers
Mysql change user password
SQL
0 vote346 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
1 vote240 views1 answer
Sql group by error
SQL
0 vote286 views1 answer
SQLServerException.makeFromDatabaseError
SQL
5 votes287 views2 answers
Add days in oracle sql
SQL