In addition to ':' ipv6 addresses could be link local (e.g. contain %eth0 )
root@9e8221561c7d:/# ./pt-table-sync --user=root --password=123456 --execute localhost --replicate filter._checksums --verbose --noversion-check --lock=0
Cannot connect to h=fe80,p=...,u=root
root@9e8221561c7d:/# mysql -p123456 -e 'show processlist'
Warning: Using a password on the command line interface can be insecure.
+----+------+---------------------------------+------+-------------+------+-----------------------------------------------------------------------+------------------+-----------+---------------+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+----+------+---------------------------------+------+-------------+------+-----------------------------------------------------------------------+------------------+-----------+---------------+
| 5 | root | fe80::42:acff:fe11:7%eth0:42542 | NULL | Binlog Dump | 435 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0 | 0 |
| 11 | root | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 |
+----+------+---------------------------------+------+-------------+------+-----------------------------------------------------------------------+------------------+-----------+---------------+
root@9e8221561c7d:/# mysql --host='fe80::42:acff:fe11:7%eth0' -p123456 -e 'select 1'
Warning: Using a password on the command line interface can be insecure.
+---+
| 1 |
+---+
| 1 |
In addition to ':' ipv6 addresses could be link local (e.g. contain %eth0 )
root@9e8221561c 7d:/# ./pt-table-sync --user=root --password=123456 --execute localhost --replicate filter._checksums --verbose --noversion-check --lock=0 7d:/# mysql -p123456 -e 'show processlist' -----+- ------- ------- ------- ------- ----+-- ----+-- ------- ----+-- ----+-- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------+ ------- ------- ----+-- ------- --+---- ------- ----+ -----+- ------- ------- ------- ------- ----+-- ----+-- ------- ----+-- ----+-- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------+ ------- ------- ----+-- ------- --+---- ------- ----+ acff:fe11: 7%eth0: 42542 | NULL | Binlog Dump | 435 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0 | 0 | -----+- ------- ------- ------- ------- ----+-- ----+-- ------- ----+-- ----+-- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------+ ------- ------- ----+-- ------- --+---- ------- ----+ 7d:/# mysql --host= 'fe80:: 42:acff: fe11:7% eth0' -p123456 -e 'select 1'
Cannot connect to h=fe80,p=...,u=root
root@9e8221561c
Warning: Using a password on the command line interface can be insecure.
+----+-
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+----+-
| 5 | root | fe80::42:
| 11 | root | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 |
+----+-
root@9e8221561c
Warning: Using a password on the command line interface can be insecure.
+---+
| 1 |
+---+
| 1 |