SHOW MASTER LOGS;
To see the master log files and their size
SHOW MASTER STATUS\G
To see the information about the current binary log
SHOW SLAVE STATUS
To see the information about the replication status
Master_Log_File :
Name of the current binary log the slave I/O thread is currently reading from
Read_Master_Log_Pos :
Position of the log file
Relay_Log_File :
Current log file the slave sql thread is reading from
Relay_Log_Pos :
Position of the log file
Relay_Master_Log_File :
Binary log file where the most recently executed event by the sql thread resides
To see the users and their permissions :
mysql> select user,host from mysql.user;
mysql> show grants for ‘root’@’localhost’;
Advertisements
