?
Solved

External Connections to MySQL Server

Posted on 2011-02-20
3
Medium Priority
?
635 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 2000 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month13 days, 14 hours left to enroll

807 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