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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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
phpmyadmin page and from privilage there you need to add new username with privilage of from any host not only localhost
replace YourUserName with a valid mysql username. This is a more complete form of the command to add a password for the username.