[MariaDB] Problem setting up new user

#11

In article <frbkc8-p1s.ln1 (AT) xl (DOT) homelinux.org>, axel.schwenke (AT) gmx (DOT) de wrote:

Quote:

Oh, now I guess I understand. Well, if you connect through the tunnel,
then from the MySQL servers point of view the connection will be
established by the sshd process (or ssh, depending which side opened
the tunnel). And this process is running on the same host than MySQL
itself and will thus connect from either 127.0.0.1 (preferred) or from
a public IP interface of your machine. Still you can configure how SSH
builds the tunnel.

Yeah. The tunnel is being created with a Windoze client versus
openssh so I'm not sure exactly what's going on there.

Quote:

There is http://dev.mysql.com/doc/refman/5.1/en/dns.html
it mentions a (small) performance penalty from having MySQL use DNS to
reverse-lookup incoming connections.

Yes, the reverse lookup is really unnecessary and is sure
to cause problems one day sometime in the future. I'm
going to nuke those lookups and live with the minor ambiguity
over the loopback versus public IP's.

At least I can forget about having to do the GRANTs for the
hostnames. Just 127.0.0.1 and my public IP.

--

Quote:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~|
Malcolm Hoar "The more I practice, the luckier I get". |
malch (AT) malch (DOT) com Gary Player. |
http://www.malch.com/ |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[MariaDB] Problem setting up new user

comp.databases.mysql comp.databases.mysql

Re: [MariaDB] Problem setting up new user - 06-14-2011 , 04:07 PM