Page MenuHomePhabricator

Labtestwiki database not reachable from deploy1001 using the standard `sql` helper script
Closed, ResolvedPublic

Description

reedy@deploy1001:/srv/mediawiki-staging$ sql labtestwiki
ERROR 1045 (28000): Access denied for user 'wikiadmin'@'10.64.32.16' (using password: YES)

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
bd808 renamed this task from Cannot sql to labtestwiki to Labtestwiki database not reachable from deploy1001 using the standard `sql` helper script.Apr 11 2020, 8:39 PM
Marostegui claimed this task.
Marostegui added subscribers: Andrew, Marostegui.

labtestwiki lives on clouddb2001-dev.codfw.wmnet which is owned by cloud-services-team but I have taken the liberty to add this grant.

[05:38:02] marostegui@deploy1001:~$ sql labtestwiki
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 75473
Server version: 10.1.44-MariaDB-0+deb9u1 Debian 9.11

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [labtestwiki]>

labtestwiki lives on clouddb2001-dev.codfw.wmnet which is owned by cloud-services-team but I have taken the liberty to add this grant.

Thank you @Marostegui! You saved me from googling yet again for the "right" way to add grants on a MySQL/MariaDB instance. :)