• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 637
  • Last Modified:

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

In my.cnf I have:-

bind-address =

Open in new window

Whenever I try to connect to MySQL I get a message like:-

"Host '' 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 3306 fine.  I bet I'm missing something obvious but I could do with some help.
  • 2
1 Solution
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.


Where access is not granted to the host

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
cescentmanAuthor Commented:
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now