Solved

External Connections to MySQL Server

Posted on 2011-02-20
3
613 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikipedia.org/wiki/PHP  Very powerful.  But a…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

832 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