improve display output

1 files changed, 6 insertions, 4 deletions

diff --git a/mariadb/mariadb-push-databases-to-empty-replica b/mariadb/mariadb-push-databases-to-empty-replica
index dc5bfa0..5d9590b 100755
--- a/mariadb/mariadb-push-databases-to-empty-replica
+++ b/mariadb/mariadb-push-databases-to-empty-replica
@@ -168,8 +168,6 @@ to
 ;
 select
         @@hostname
-        as
-                'primary host'
 ,       concat (user, '@', host)
         as
                 login
@@ -179,7 +177,9 @@ select
 from
         mysql.user
 where
-        repl_slave_priv = 'Y'
+        user = '$2'
+and
+        host = '$1'
 ;
 .
 }
@@ -499,7 +499,9 @@ start
         echo "trying primary_gtid_wait()... " >&2
         mariadb -t --skip-reconnect <<.
 select
-        master_gtid_wait('$gtid')
+        @@hostname
+,       @@gtid_slave_pos as 'replica gtid'
+,       master_gtid_wait('$gtid')
         as \`primary_gtid_wait('$gtid')\`
 ;
 .