/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 vote102 views1 answer
Psql datetime grather than
SQL
0 vote118 views2 answers
Oracle ora-00054 how to unlock
SQL
1 vote103 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
1 vote107 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote136 views1 answer
Sql create and grant user access to database
SQL
4 votes138 views2 answers
Postgresql float data type
SQL
1 vote100 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote98 views2 answers
Functions with parameters SQL
SQL
1 vote97 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote126 views10 answers
John the ripper mysql
SQL