SHOW MASTER STATUS
This statement provides status information about the binary log
files of the master. It requires either the
SUPER
or
REPLICATION CLIENT
privilege.
Example:
mysql> SHOW MASTER STATUS;
+---------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| mysql-bin.003 | 73 | test | manual,mysql |
+---------------+----------+--------------+------------------+