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,340 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 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now