/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

23 votes214 views4 answers
How to show all users in mysql
SQL
0 vote192 views1 answer
Rails sql query converstion
SQL
1 vote174 views2 answers
Into sql
SQL
1 vote207 views1 answer
Drop column if exists sql server
SQL
3 votes193 views2 answers
Postgres inner join vs join
SQL
0 vote191 views1 answer
Install sql server windows 10
SQL
0 vote212 views1 answer
Stored procedure function relation
SQL
0 vote187 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote222 views1 answer
SQLServerException.makeFromDatabaseError
SQL
4 votes198 views3 answers
Sql drop primary key
SQL