/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

0 vote102 views1 answer
First mysql
SQL
0 vote116 views1 answer
Count number of entires by months sql
SQL
1 vote107 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
4 votes96 views3 answers
Copy table postgres
SQL
0 vote102 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote127 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote109 views1 answer
What is the use of index in mysql table
SQL
1 vote107 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote101 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote110 views1 answer
Mysql sql.gz
SQL