External Connections to MySQL Server

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:-

[mysqld]
bind-address = 192.168.0.118

Open in new window


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.
LVL 1
cescentmanAsked:
Who is Participating?
 
APNFSSCCommented:
if you can connect to the database from the local host then open up the mysql database and view the records in the user table. you look like you have a privileges problem.

http://kb.mediatemple.net/questions/788/HOWTO%3A+GRANT+privileges+in+MySQL

Where access is not granted to the host 192.169.0.105

0
 
cescentmanAuthor Commented:
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
0
 
cescentmanAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.