no access to connect with mysql

April 12, 2015 1.4k views
CentOS MySQL Networking

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.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!