On Tue, 10 Jul 2012 20:18:07 +0200, Zdenek Herman wrote:

> On 10/07/12 17:29, Camaleón wrote:

(...)

>>> Ah, how curious... It seems to be documented here:
>>>
>>> 4.2.2. Connecting to the MySQL Server
>>> http://dev.mysql.com/doc/refman/5.6/en/connecting.html

(...)

>>>
>> Camaleón is correct.
>>
>> When you are logged into mysql, you can enter the "status" command and
>> it will show how you are connected.
>>
>> Connect via "-h localhost":

(...)

>> Connect via "-h 127.0.0.1":

(...)

>> Connection: 127.0.0.1 via TCP/IP ...
>> TCP port: 3306
>> ...
>>
>> Hope that clears it up a bit.
>>
>> It might be possible to disable the socket connection in the MySQL
>> config, but I haven't looked into that.
>>
>>
> Ok - many thanks guys for reply
> This explain first part of problem - my fault sorry. I tried set in my
> hosts.allow
> mysqld: 127.0.0.1
> : spawn ( echo $(date '+%%d.%%m.%%y %%T') access ALLOWED from %u@%h [%a] >> /var/log/tcp_wrapper/%d.log ) &
> This allow connect from localhost - its ok. But why when connect from
> remote machine or 127.0.0.1 nothing in log ? With sshd work same command great.

I would rather use the IP of the machine where MySQL runs (192.168.1.1)
instead the loopback device (127.0.0.1) and not only for hosts.allow/
deny but also for the running MySQL daemon if you want to be accessible
from clients in your local network.

Greetings,

--
Camaleón


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: http://lists.debian.org/jtjv97$4fh$4@dough.gmane.org