Solved

External Connections to MySQL Server

Posted on 2011-02-20
3
617 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:cescentman
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
APNFSSC earned 500 total points
ID: 34940629
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
 
LVL 1

Author Comment

by:cescentman
ID: 34940936
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
 
LVL 1

Author Closing Comment

by:cescentman
ID: 34940937
Thanks
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question