Log file Viewer

[14:08:31] <f00lest> is there anyway to disable authentication when accessing the database from localhost

[14:08:43] <f00lest> and only enable authentication when connecting from a remote host?

[14:26:29] <f00lest> is what I've asked even possible

[14:26:46] <f00lest> is it impossible?

[14:27:49] <GothAlice> f00lest: Possibly a http://s.webcore.io/d41m/165595-your-scientists-were-so-preocc-K8Ym.jpeg item. "I want security!" Great! "Except not on anyone who claims to be originating from 127.0.0.1." Wait, so you don't want security?

[14:28:41] <f00lest> I want applications operating on the same server to be able to access the db without authentication

[14:29:08] <GothAlice> Only have it listen to 127.0.0.1 (no outside network connections) and turn off authentication. But then you have no authentication. And the arrangement you are suggesting is terribly insecure and a bad idea.

[14:29:28] <GothAlice> (Packet origins can be forged.)

[14:30:11] <f00lest> GothAlice understood

[14:30:58] <GothAlice> "Bypass authentication because we trust people who say they're 127.0.0.1" is a MySQL-level "good idea". http://grimoire.ca/mysql/choose-something-else

[14:31:50] <f00lest> I do not have any idea about mysql

[16:00:01] <ErikPel> Hello! I'm trying to figure out how to use indexes on aggregations for sort, but I can't quite figure out what explain output should look like if index is being used

[16:00:24] <ErikPel> it says "stage": "IXSCAN", "filter": { "name": { "$regex": "Pro" } },

[16:00:26] <ErikPel> for the search

[16:00:55] <ErikPel> but nothing about the sort except "$sort": { "sortKey": { "sku": 1 }, "limit": 11 }