######################################### # Author: Serge Kozlov skozlov@mysql.com # Date: 07/10/2006 # Purpose: Showing user info on master and on slave # Requirements: ######################################### --echo ==========MASTER========== SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%'; sync_slave_with_master; --echo ==========SLAVE=========== USE test_rpl; SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%'; connection master;
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| rpl_mixed_check_db.inc | File | 396 B | 0644 |
|
| rpl_mixed_check_event.inc | File | 430 B | 0644 |
|
| rpl_mixed_check_select.inc | File | 568 B | 0644 |
|
| rpl_mixed_check_table.inc | File | 446 B | 0644 |
|
| rpl_mixed_check_user.inc | File | 522 B | 0644 |
|
| rpl_mixed_check_view.inc | File | 452 B | 0644 |
|
| rpl_mixed_clear_tables.inc | File | 257 B | 0644 |
|
| rpl_mixed_ddl.inc | File | 2.92 KB | 0644 |
|
| rpl_mixed_dml.inc | File | 10.61 KB | 0644 |
|
| rpl_mixed_show_binlog_format.inc | File | 388 B | 0644 |
|
| rpl_partition.inc | File | 3.82 KB | 0644 |
|