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

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!
nexcoAsked:
Who is Participating?
 
db2inst1Commented:
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
 
nexcoAuthor Commented:
thank you very much db2inst1 !
Now a can connect to my server from the lan!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.