no access to connect with mysql

April 12, 2015 1.3k views
MySQL Networking CentOS

Hi i am trying to connect with my mysql server running on centos 7

But its saying: Acces denied for user data@myip. and i can't connect to root either.

please help me?

1 Answer

I fixed it using a query:

update user set host='%' where host='localhost';

Have another answer? Share your knowledge.