<div>
Thanks, I should have thought of this myself but it was late and I was tired and under pressure to get it sorted. Along you come with the solution. Great
</div>


Thanks, I should have thought of this myself but it was late and I was tired and under pressure to get it sorted. Along you come with the solution. Great

<div>
<div class="content wysiwyg-content">
I have just set up a new Ubuntu 10.10 box and tonight installed MySQL. The IP address of the box is:-<br />
<br />
192.168.0.118<br />
<br />
In my.cnf I have:-<br />
<br />

<pre><code id="code-10-26835138-1">[mysqld]
bind-address = 192.168.0.118</code></pre>
<br />
Whenever I try to connect to MySQL I get a message like:-<br />
<br />
&quot;Host '192.169.0.105' is not allowed to connect to this server.&quot; (IP address depends on which box I'm trying from of course). From any of the other boxes telnet connects:-<br />
<br />
telnet &nbsp;192.168.0.118 3306 fine. &nbsp;I bet I'm missing something obvious but I could do with some help.
</div>
</div>


I have just set up a new Ubuntu 10.10 box and tonight installed MySQL. The IP address of the box is:-

192.168.0.118

In my.cnf I have:-

(CODE)

Whenever I try to connect to MySQL I get a message like:-

"Host '192.169.0.105' is not allowed to connect to this server." (IP address depends on which box I'm trying from of course). From any of the other boxes telnet connects:-

telnet  192.168.0.118 3306 fine.  I bet I'm missing something obvious but I could do with some help.

External Connections to MySQL Server

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.