User:KBach-WMF~labswiki/Sandbox/Mobile readability

Buttons

Toolforge quickstart

Create and manage tool accounts

Images

bast1003.wikimedia.org in the eqiad data center in Virginia, United States
bast2003.wikimedia.org in the codfw data center in Texas, United States
bast3007.wikimedia.org in the esams data center in Amsterdam, The Netherlands
bast4005.wikimedia.org in the ulsfo data center in San Francisco, United States
bast5004.wikimedia.org in the eqsin data center in Singapore
bast6003.wikimedia.org in the drmrs data center in Marseille, France
bast7002.wikimedia.org in the magru data center in São Paulo, Brazil

Map of bastion hosts

codfw

eqiad

esams

ulsfo

eqsin

drmrs

magru

Code snippets

<?php
$ts_pw = posix_getpwuid(posix_getuid());
$ts_mycnf = parse_ini_file($ts_pw['dir'] . "/replica.my.cnf");
$db = new PDO("mysql:host=enwiki.analytics.db.svc.wikimedia.cloud;dbname=enwiki_p", $ts_mycnf['user'], $ts_mycnf['password']);
unset($ts_mycnf, $ts_pw);

$q = $db->prepare('select * from page where page_id = :id');
$q->execute(array(':id' => 843020));
print_r($q->fetchAll());
?>

This will delete the user password, but will indicate it does not uses the mysql native password authentication, but unix socket.

MariaDB [(none)]> SELECT user,host,password,plugin FROM mysql.user WHERE user='root';
+------+--------------+-------------------------------------------+-------------+
| user | host         | password                                  | plugin      |
+------+--------------+-------------------------------------------+-------------+
| root | localhost    |                                           | unix_socket |

This will delete the user password, but will indicate it does not uses the mysql native password authentication, but unix socket.

MariaDB [(none)]> SELECT user,host,password,plugin FROM mysql.user WHERE user='root';
+------+--------------+-------------------------------------------+-------------+
| user | host         | password                                  | plugin      |
+------+--------------+-------------------------------------------+-------------+
| root | localhost    |                                           | unix_socket |