/SQL/SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')

SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')

$ 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 vote234 views1 answer
Time in sql server
SQL
0 vote160 views1 answer
Prevent duplicate rows in postgres
SQL
3 votes168 views1 answer
Oracle failed login attempts
SQL
0 vote229 views2 answers
Postgres having
SQL
12 votes187 views2 answers
Delete all data in neo4j
SQL
22 votes179 views2 answers
Mysql show all tables
SQL
13 votes205 views5 answers
Sql default
SQL
0 vote267 views1 answer
Example of sql querry result sepapreted by comma
SQL
1 vote192 views1 answer
Delete row mssql
SQL
0 vote194 views1 answer
How to insert a uniqueidentifier in sql
SQL