SQLSTATE[HY000] [1045] Access denied for user 'root'@'114.xxx.xxx.xxx' (using password: YES)

Question

My connection in env file is like this :

DB_CONNECTION=mysql
DB_HOST=31.220.56.75
DB_PORT=3306
DB_DATABASE=chelsea
DB_USERNAME=root
DB_PASSWORD=terry

When I access my localhost with database server, there is exist error like this :

SQLSTATE[HY000] [1045] Access denied for user 'root'@'114.xxx.xxx.xxx' (using password: YES) 

In database server, I try run this : GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'terry' WITH GRANT OPTION;, there is exist message like this : Query OK, 0 rows affected, 1 warning (0.00 sec)

It looks like it does not work

Is there any people who can help me?

Answer 1

Verify in your my.cnf to comment this line

bind-address = 127.0.0.1

and in mysql console

flush privileges;

Finally restart the mysql server.