/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

1 vote330 views1 answer
Mysql server does not start mac
SQL
0 vote365 views1 answer
Sql today at midnight
SQL
0 vote341 views1 answer
If exist column in table drop sql query mysql
SQL
44 votes403 views6 answers
Rename command in sql
SQL
0 vote360 views1 answer
T sql dynamic top n query
SQL
2 votes345 views1 answer
Oracle current date without time
SQL
-1 vote362 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote370 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote380 views2 answers
Temp tables in sql server
SQL
0 vote340 views1 answer
Dapper run sql script with parameters
SQL