<div>
GRANT ALL ON *.* TO YourUserName@&quot;%&quot; IDENTIFIED BY 'some_pass' WITH GRANT OPTION<br />
<br />
replace YourUserName with a valid mysql username. This is a more complete form of the command to add a password for the username.
</div>


<div>
Ahh... there's another slight problem.<br />
<br />
My VMWare image diddn't come with the MYsql username and password. Is there a way to reset it?<br />
<br />

</div>


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

</div>


<div>
<div class="content wysiwyg-content">
When i try to connect to the MySQL server using navicat i get the error:<br />
<br />
1130 - Host '10.0.0.4' is not allowed to connect to this MySQL server.<br />
<br />
How do I allow access for all hosts?
</div>
</div>


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?

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

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.