/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

3 votes319 views1 answer
Export postgres database linux
SQL
16 votes306 views4 answers
Sort by sql
SQL
1 vote311 views1 answer
Drop table if exists oracle
SQL
1 vote314 views1 answer
Sql pick random row
SQL
0 vote315 views1 answer
Postgres sequence name
SQL
-1 vote308 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote316 views2 answers
Imageview setimageresource null
SQL
0 vote348 views2 answers
Check if sql temp table exists
SQL
2 votes319 views1 answer
Sql server check for value in multiple columns
SQL
0 vote305 views1 answer
Oracle job class
SQL