Solved

External Connections to MySQL Server

Posted on 2011-02-20
3
620 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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

Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

730 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