Access Hosts not working

N

nservices

Verified User
Joined
Dec 11, 2008
Messages
300
Hi, i try to work with Access Hosts but it not working for me
i just add some host and try to access with the db user to the database from remote server
but i still get the error: mysqldump: Got error: 1130: Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server when trying to connect

any idea?
 
go to mysql administrator in directadmin, select the database you wanna make accessible from external and add % or the IP you wanna able to access (% is EVERYONE) and you will be able to access to THAT database from who you choose
 
it what i did, but its not working

i try to add% for access from any ip / address

i believe that this solution need to work via db user / not only db name...
 
mmmh i just need to edit that on single database, the user linked to that db will be able to log from everyhost using %
 
it not working

i did it, but its not work when i try to dump this db from remote mysql server
there is something else that i need to do ?

Best Regards,
nservices.
 
that is strange, maybe u have to open port 3306 into your firewall cause when i set % to a database i can edit and see that db with mysql maestro or whatever mysql dump/report program i want from any host
 
the port is open

i also try to stop iptables (my firewall)
and i got the same error message
mysqldump: Got error: 1130: Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server when trying to connect
 
i try run the next command on the remote server

mysqldump -hxxx.xxx.xxx.xxx -udbusername -pdbpassword --opt --compress dbname

error message: mysqldump: Got error: 1130: Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server when trying to connect
 
You must log in or register to reply here.
Back
Top