Link to home
Start Free TrialLog in
Avatar of zcd
zcd

asked on

Cannot connect to MySQL using Navicat from remote client/host machine

When i try to connect to the MySQL server using navicat i get the error:

1130 - Host '10.0.0.4' is not allowed to connect to this MySQL server.

How do I allow access for all hosts?
ASKER CERTIFIED SOLUTION
Avatar of Cedric Obinna A.
Cedric Obinna A.
Flag of Nigeria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
GRANT ALL ON *.* TO YourUserName@"%" IDENTIFIED BY 'some_pass' WITH GRANT OPTION

replace YourUserName with a valid mysql username. This is a more complete form of the command to add a password for the username.
Avatar of zcd
zcd

ASKER

Ahh... there's another slight problem.

My VMWare image diddn't come with the MYsql username and password. Is there a way to reset it?

you can go to
phpmyadmin page and from privilage there you need to add new username with privilage of from any host not only localhost