Solved

ERROR 1130 (00000): Host '192.168.0.6' is not allowed to connect to this MySQL server

Posted on 2006-06-15
2
9,360 Views
Last Modified: 2008-03-04
Hi all!
I installed MySQL on debian sarge every thing is ok  when i use it localy. but when i try to connect  to  the server from a other machine in the lan (running sarge also ) A have the following error:
ERROR 1130 (00000): Host 'exemple.domaine.com' is not allowed to connect to this MySQL server

i have verified the /etc/mysql/my.cnf and bind-adress is commented...
I did a : netsat  -l -t -p  i can see that  mysql is listening to all adresses. but i can't connect  using the Ip adress.
is there any default security configuration (else than binb-adress) that stop tcp connections on debian?

Thanks in advance!
0
Comment
Question by:nexco
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
db2inst1 earned 250 total points
ID: 16911782
logon to local machine and try granting access to the user you are connecting as

grant all privileges on dbname.* to 'user'@'192.168.0.6' identified by 'passwd';
flush privileges;
0
 

Author Comment

by:nexco
ID: 16912376
thank you very much db2inst1 !
Now a can connect to my server from the lan!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Suggested Solutions

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

763 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