Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2006-06-15
2
Medium Priority
?
9,404 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
2 Comments
 
LVL 7

Accepted Solution

by:
db2inst1 earned 1000 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
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

886 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