/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 vote382 views1 answer
Mysql add fields
SQL
0 vote360 views1 answer
Mysql join same table multiple times group by
SQL
1 vote364 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
1 vote359 views1 answer
Mysql month name extract
SQL
0 vote381 views1 answer
Sqlite3_open_v2
SQL
0 vote352 views2 answers
Oracle create chain rule
SQL
0 vote393 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote390 views1 answer
Python sql last insertend
SQL
0 vote395 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote376 views4 answers
Rownum in sql
SQL