/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 votes137 views2 answers
Postgre sql create table
SQL
14 votes135 views3 answers
Alter foreign key
SQL
4 votes141 views4 answers
Check constraint in ms sql
SQL
0 vote141 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote142 views1 answer
Flexible search query delete table
SQL
2 votes141 views1 answer
Q operator in sql
SQL
0 vote133 views1 answer
Kill a pid redshift
SQL
11 votes135 views2 answers
Docker create postgres db
SQL
0 vote205 views1 answer
Site:av.ru "files"
SQL
1 vote152 views1 answer
Mysql select for update ejemplo
SQL