Yes, it is because MySQL requires you to have permission to SELECT on the
underlying tables, which are sensitive and can't be exposed to labs.

See https://phabricator.wikimedia.org/T50875

On 31 August 2015 at 02:04, Golden Ring <[email protected]> wrote:

> Is the reason that ordinary users can't EXPLAIN most queries in the
> replicas that it requires the SELECT privilege on the underlying tables,
> and this is withheld for privacy reasons (the view NULLs out the password,
> email, options, token etc)?
>
> GoldenRing
>
> On 30 August 2015 at 23:48, Platonides <[email protected]> wrote:
>
>> On 31/08/15 00:17, Huji Lee wrote:
>>
>>> Oh that is smart!
>>>
>>> By the way, after some exploration I figured out I really don't know how
>>> to connect to a specific labsdb instance. What is the host name I should
>>> be using on command line? fawiki.labsdb001 is not the answer.
>>>
>>
>>
>> mysql -h labsdb1001.eqiad.wmnet  fawiki_p
>>
>>
>>
>> _______________________________________________
>> Labs-l mailing list
>> [email protected]
>> https://lists.wikimedia.org/mailman/listinfo/labs-l
>>
>
>
> _______________________________________________
> Labs-l mailing list
> [email protected]
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
>
_______________________________________________
Labs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/labs-l

Reply via email to