Score:0

force mysqld to use etc hosts for reverse lookup

cn flag

I have a server hosted by hetzner running mysqld. I already setup some "ddns for poor ones" to add my dial-on IP (Telekom) to the server's /etc/hosts. Now all Users in mysql are limited to localhost, but my development machine at home must also connect. When doing so, the mysql deamon does a reverse lookup in DNS, but my (existing and correctly working!) local bind ofcause does not contain (cheated) reverse zones for telekom networks :-/ to resolve my Telekom dialed home network's ip.

Final result: mysql does not let me in, because my DNS reverse name is something.dip0.t-ipconnect.de (and not the poor-DDNS'ed name) and will change from time to time. How can I force the mysqld to use the /etc/hosts for reverse lookup .. or does anyone have a better idea to allow my dial-on network to connect to mysql without opening to % (any)?

^5 & thx

Score:0
cn flag

well, the easy solution is: it DOES use the usual order for reverse lookup of the source IPs, I just stumbled across the host cache, that mysql server keeps and that still contained the orginal (dynamic) hostname resolved by my dial-on provider. After truncating that table, the actual resolution is taken, which includes local /etc/hosts.

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.