/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 vote220 views1 answer
Mysql get longest string in column
SQL
7 votes290 views2 answers
Sql empty table
SQL
0 vote218 views1 answer
Sql count total by foreign key
SQL
12 votes208 views4 answers
How to check mysql version ubuntu
SQL
1 vote196 views1 answer
Postgresql define pk sequence next number
SQL
5 votes224 views1 answer
Mysql count newlines in field
SQL
3 votes204 views2 answers
Postgres alter table owner
SQL
3 votes195 views1 answer
How to find names includes in sql
SQL
1 vote191 views2 answers
Find a column in all tables mysql
SQL
0 vote182 views1 answer
Mysql cdn link
SQL