I have a VPS instance, spi-tools-host-1 https://horizon.wikimedia.org/project/instances/43d3e9f2-b7d5-4a51-92b6-6a636839d66f/, from which I want to query the database replicas. Following the instructions at https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database, I copied my replica.my.cnf file from my toolforge account and ran:
mysql --defaults-file=$HOME/replica.my.cnf -h enwiki.analytics.db.svc.wikimedia.cloud enwiki_p
which gives:
ERROR 1045 (28000): Access denied for user 's54269'@'10.64.37.27' (using password: YES)
Never mind. PEBKAC.
On Oct 7, 2021, at 4:19 PM, Roy Smith roy@panix.com wrote:
I have a VPS instance, spi-tools-host-1 https://horizon.wikimedia.org/project/instances/43d3e9f2-b7d5-4a51-92b6-6a636839d66f/, from which I want to query the database replicas. Following the instructions at https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database, I copied my replica.my.cnf file from my toolforge account and ran:
mysql --defaults-file=$HOME/replica.my.cnf -h enwiki.analytics.db.svc.wikimedia.cloud enwiki_p
which gives:
ERROR 1045 (28000): Access denied for user 's54269'@'10.64.37.27' (using password: YES) _______________________________________________ Cloud mailing list -- cloud@lists.wikimedia.org List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/