/SQL/SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel 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 = laravel 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

SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')

There is two reasons for this , wrong root password or no root password
with this option disabled in the mysql settings , this is a workaround
for the second issue : 

sudo mysql -u root -p

Now you can alter root user password using the following cmd

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'

Remeber to change 'password' with your password 

and update it in the .env file of your application

Similar codes

17 votes125 views2 answers
Mysql date to string
SQL
0 vote117 views1 answer
Get date ISO in psql
SQL
0 vote120 views2 answers
Which MySQL statement is used to delete data from a database
SQL
1 vote124 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
7 votes105 views1 answer
Postgres base size
SQL
7 votes110 views1 answer
Set sequence value oracle
SQL
0 vote108 views2 answers
Create sequence if not exists postgres
SQL
2 votes114 views1 answer
Date conversion in mysql column
SQL
0 vote73 views1 answer
Expose db in virtualbox
SQL
0 vote111 views1 answer
Show create table in postgresql
SQL