MySQL

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’;

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s