Gecko [ www.jdcpatala.org ]

Name	Size	Permission
ndb_dist_priv_common.result	2.33 KB	-rw-r--r--
ndb_rpl_2innodb.result	41.34 KB	-rw-r--r--
ndb_rpl_2myisam.result	41.34 KB	-rw-r--r--
ndb_rpl_2ndb.result	16.17 KB	-rw-r--r--
ndb_rpl_2other.result	32.71 KB	-rw-r--r--
ndb_rpl_add_column.result	5.99 KB	-rw-r--r--
ndb_rpl_apply_status.result	907 B	-rw-r--r--
ndb_rpl_auto_inc.result	3.72 KB	-rw-r--r--
ndb_rpl_bank.result	10.82 KB	-rw-r--r--
ndb_rpl_basic.result	13.52 KB	-rw-r--r--
ndb_rpl_batch.result	2.48 KB	-rw-r--r--
ndb_rpl_batch_handling.result	1.91 KB	-rw-r--r--
ndb_rpl_binlog_format_errors.r...	1.27 KB	-rw-r--r--
ndb_rpl_bitfield.result	14.48 KB	-rw-r--r--
ndb_rpl_blob.result	7.29 KB	-rw-r--r--
ndb_rpl_break_3_chain.result	3.17 KB	-rw-r--r--
ndb_rpl_bug22045.result	2.56 KB	-rw-r--r--
ndb_rpl_bug_13440282.result	2.3 KB	-rw-r--r--
ndb_rpl_check_for_mixed.result	483 B	-rw-r--r--
ndb_rpl_checksum.result	6.31 KB	-rw-r--r--
ndb_rpl_circular.result	5.13 KB	-rw-r--r--
ndb_rpl_circular_2ch.result	2.27 KB	-rw-r--r--
ndb_rpl_circular_2ch_rep_statu...	7.47 KB	-rw-r--r--
ndb_rpl_circular_simplex.resul...	1.28 KB	-rw-r--r--
ndb_rpl_conflict_basic.result	18.2 KB	-rw-r--r--
ndb_rpl_conflict_epoch.result	71.03 KB	-rw-r--r--
ndb_rpl_conflict_epoch2.result	143.62 KB	-rw-r--r--
ndb_rpl_conflict_epoch2_extra....	63.18 KB	-rw-r--r--
ndb_rpl_conflict_epoch2_trans....	47.12 KB	-rw-r--r--
ndb_rpl_conflict_epoch_ext.res...	106.6 KB	-rw-r--r--
ndb_rpl_conflict_epoch_extende...	13.51 KB	-rw-r--r--
ndb_rpl_conflict_epoch_trans.r...	23.13 KB	-rw-r--r--
ndb_rpl_conflict_epoch_trans_e...	23.62 KB	-rw-r--r--
ndb_rpl_conflict_max.result	36.46 KB	-rw-r--r--
ndb_rpl_conflict_max_delete_wi...	35.68 KB	-rw-r--r--
ndb_rpl_conflict_old.result	36.65 KB	-rw-r--r--
ndb_rpl_conflict_read_tracking...	29.94 KB	-rw-r--r--
ndb_rpl_ctype_ucs2_def.result	703 B	-rw-r--r--
ndb_rpl_dd_advance.result	8.9 KB	-rw-r--r--
ndb_rpl_dd_basic.result	2.4 KB	-rw-r--r--
ndb_rpl_dd_partitions.result	35.75 KB	-rw-r--r--
ndb_rpl_ddl_open_trans.result	1.87 KB	-rw-r--r--
ndb_rpl_dist_priv.result	11.31 KB	-rw-r--r--
ndb_rpl_do_db.result	1.44 KB	-rw-r--r--
ndb_rpl_do_table.result	1.13 KB	-rw-r--r--
ndb_rpl_empty_epoch.result	1.17 KB	-rw-r--r--
ndb_rpl_gap_event.result	1.38 KB	-rw-r--r--
ndb_rpl_idempotent.result	3.06 KB	-rw-r--r--
ndb_rpl_ignore_db.result	1.08 KB	-rw-r--r--
ndb_rpl_init_rep_status.result	2.17 KB	-rw-r--r--
ndb_rpl_innodb2ndb.result	41 KB	-rw-r--r--
ndb_rpl_innodb_trans.result	3.08 KB	-rw-r--r--
ndb_rpl_last_conflict_epoch_va...	2.06 KB	-rw-r--r--
ndb_rpl_load.result	1.27 KB	-rw-r--r--
ndb_rpl_logging.result	2.66 KB	-rw-r--r--
ndb_rpl_mix_eng_trans.result	10.51 KB	-rw-r--r--
ndb_rpl_mix_innodb.result	4.35 KB	-rw-r--r--
ndb_rpl_mixed_tables.result	7.28 KB	-rw-r--r--
ndb_rpl_multi.result	2.33 KB	-rw-r--r--
ndb_rpl_myisam2ndb.result	41 KB	-rw-r--r--
ndb_rpl_ndbapi-examples.result	522 B	-rw-r--r--
ndb_rpl_rep_error.result	16.79 KB	-rw-r--r--
ndb_rpl_rep_ignore.result	1.4 KB	-rw-r--r--
ndb_rpl_skip_gap_event.result	1.27 KB	-rw-r--r--
ndb_rpl_slave_binlog_index.res...	1.83 KB	-rw-r--r--
ndb_rpl_slave_conflict_role_va...	9.63 KB	-rw-r--r--
ndb_rpl_slave_lsu.result	53.8 KB	-rw-r--r--
ndb_rpl_slave_lsu_anyval.resul...	54.73 KB	-rw-r--r--
ndb_rpl_slave_replay.result	6.42 KB	-rw-r--r--
ndb_rpl_slave_restart.result	1.93 KB	-rw-r--r--
ndb_rpl_stm_innodb.result	4.38 KB	-rw-r--r--
ndb_rpl_sync.result	2.38 KB	-rw-r--r--
ndb_rpl_ui.result	1.86 KB	-rw-r--r--
ndb_rpl_ui2.result	813 B	-rw-r--r--
ndb_rpl_ui3.result	1.22 KB	-rw-r--r--
rpl_truncate_7ndb.result	3.27 KB	-rw-r--r--
rpl_truncate_7ndb_2.result	3.27 KB	-rw-r--r--

Code Editor : ndb_rpl_dist_priv.result

include/master-slave.inc
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
call mysql.mysql_cluster_move_privileges();
select mysql.mysql_cluster_privileges_are_distributed();
mysql.mysql_cluster_privileges_are_distributed()
1
CREATE TABLE t1 (pk INT PRIMARY KEY, a INT) engine = ndb;
CREATE USER 'user'@'localhost' IDENTIFIED by 'mypass';
GRANT UPDATE ON t1 TO 'user'@'localhost';
SET PASSWORD FOR 'user'@'localhost'= 'newpass';
RENAME USER 'user'@'localhost' TO 'newuser'@'localhost';
GRANT SELECT ON test.* TO 'newuser'@'localhost' IDENTIFIED by 'mypass2';
Warnings:
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
CREATE USER 'user2'@'localhost' IDENTIFIED by 'mypass';
GRANT SELECT ON test.t1 TO 'user2'@'localhost';
select distinct User,Authentication_string from mysql.user order by User;
User	Authentication_string
newuser	*1E9649BB3F345563008E37641B407AFF50E5835C
root	
user2	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
select User,Table_priv from mysql.tables_priv ORDER BY User;
User	Table_priv
newuser	Update
user2	Select
CREATE USER 'user'@'localhost';
grant ALL PRIVILEGES on test.* to user@localhost with GRANT OPTION;
select User,Table_priv from mysql.tables_priv ORDER BY User;
User	Table_priv
newuser	Update
user2	Select
GRANT SELECT ON test.t1 TO 'user'@'localhost';
select User,Table_priv from mysql.tables_priv ORDER BY User;
User	Table_priv
newuser	Update
user	Select
user2	Select
FLUSH PRIVILEGES;
select User,Table_priv from mysql.tables_priv ORDER BY User;
User	Table_priv
newuser	Update
user	Select
user2	Select
REVOKE SELECT ON test.t1 FROM 'user'@'localhost';
select User,Table_priv from mysql.tables_priv ORDER BY User;
User	Table_priv
newuser	Update
user2	Select
CREATE USER 'user3'@'localhost' IDENTIFIED by 'mypass';
select distinct User,Authentication_string from mysql.user order by User;
User	Authentication_string
newuser	*1E9649BB3F345563008E37641B407AFF50E5835C
root	
user	
user2	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
user3	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
select User,Table_priv from mysql.tables_priv ORDER BY User;
User	Table_priv
newuser	Update
user2	Select
select distinct User,Authentication_string from mysql.user order by User;
User	Authentication_string
newuser	*1E9649BB3F345563008E37641B407AFF50E5835C
root	
user	
user2	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
user3	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
select User,Table_priv from mysql.tables_priv ORDER BY User;
User	Table_priv
newuser	Update
user2	Select
FLUSH PRIVILEGES;
REVOKE UPDATE ON t1 FROM 'newuser'@'localhost';
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user2'@'localhost';
select User,Table_priv from mysql.tables_priv ORDER BY User;
User	Table_priv
GRANT SELECT (a) ON test.t1 TO 'user'@'localhost';
select User, Table_name, Column_name from mysql.columns_priv ORDER BY User;
User	Table_name	Column_name
user	t1	a
FLUSH PRIVILEGES;
select distinct User,Authentication_string from mysql.user order by User;
User	Authentication_string
newuser	*1E9649BB3F345563008E37641B407AFF50E5835C
root	
user	
user2	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
user3	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
select User,Table_priv from mysql.tables_priv ORDER BY User;
User	Table_priv
user	
select User, Table_name, Column_name from mysql.columns_priv ORDER BY User;
User	Table_name	Column_name
user	t1	a
select distinct User,Authentication_string from mysql.user order by User;
User	Authentication_string
newuser	*1E9649BB3F345563008E37641B407AFF50E5835C
root	
user	
user2	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
user3	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
select User,Table_priv from mysql.tables_priv ORDER BY User;
User	Table_priv
user	
select User, Table_name, Column_name from mysql.columns_priv ORDER BY User;
User	Table_name	Column_name
user	t1	a
DROP USER 'newuser'@'localhost';
== Showing binlog server1 ==
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'user'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4' PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK
master-bin.000001	#	Query	#	#	use `test`; GRANT UPDATE ON `test`.`t1` TO 'user'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; ALTER USER 'user'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*D8DECEC305209EEFEC43008E1D420E1AA06B19E0'
master-bin.000001	#	Query	#	#	use `test`; RENAME USER 'user'@'localhost' TO 'newuser'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; GRANT SELECT ON `test`.* TO 'newuser'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*1E9649BB3F345563008E37641B407AFF50E5835C'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4' PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK
master-bin.000001	#	Query	#	#	use `test`; GRANT SELECT ON `test`.`t1` TO 'user2'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'user'@'localhost' IDENTIFIED WITH 'mysql_native_password' PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK
master-bin.000001	#	Query	#	#	use `test`; GRANT ALL PRIVILEGES ON `test`.* TO 'user'@'localhost' WITH GRANT OPTION
master-bin.000001	#	Query	#	#	use `test`; GRANT SELECT ON `test`.`t1` TO 'user'@'localhost'
master-bin.000001	#	Query	#	#	REVOKE SELECT ON test.t1 FROM 'user'@'localhost'
master-bin.000001	#	Query	#	#	CREATE USER 'user3'@'localhost' IDENTIFIED by 'mypass'
master-bin.000001	#	Query	#	#	REVOKE UPDATE ON t1 FROM 'newuser'@'localhost'
master-bin.000001	#	Query	#	#	REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user2'@'localhost'
master-bin.000001	#	Query	#	#	GRANT SELECT (a) ON test.t1 TO 'user'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; FLUSH PRIVILEGES
master-bin.000001	#	Query	#	#	DROP USER 'newuser'@'localhost'
== Showing binlog server2 ==
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	CREATE USER 'user'@'localhost' IDENTIFIED by 'mypass'
master-bin.000001	#	Query	#	#	GRANT UPDATE ON t1 TO 'user'@'localhost'
master-bin.000001	#	Query	#	#	ALTER USER 'user'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*D8DECEC305209EEFEC43008E1D420E1AA06B19E0'
master-bin.000001	#	Query	#	#	RENAME USER 'user'@'localhost' TO 'newuser'@'localhost'
master-bin.000001	#	Query	#	#	GRANT SELECT ON test.* TO 'newuser'@'localhost' IDENTIFIED by 'mypass2'
master-bin.000001	#	Query	#	#	CREATE USER 'user2'@'localhost' IDENTIFIED by 'mypass'
master-bin.000001	#	Query	#	#	GRANT SELECT ON test.t1 TO 'user2'@'localhost'
master-bin.000001	#	Query	#	#	CREATE USER 'user'@'localhost'
master-bin.000001	#	Query	#	#	grant ALL PRIVILEGES on test.* to user@localhost with GRANT OPTION
master-bin.000001	#	Query	#	#	GRANT SELECT ON test.t1 TO 'user'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; FLUSH PRIVILEGES
master-bin.000001	#	Query	#	#	use `test`; REVOKE SELECT ON test.t1 FROM 'user'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'user3'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4' PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK
master-bin.000001	#	Query	#	#	use `test`; FLUSH PRIVILEGES
master-bin.000001	#	Query	#	#	use `test`; REVOKE UPDATE ON t1 FROM 'newuser'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user2'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; GRANT SELECT (a) ON `test`.`t1` TO 'user'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; DROP USER 'newuser'@'localhost'
select distinct User,Authentication_string from mysql.user order by User;
User	Authentication_string
root	
user	
user2	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
user3	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
select User,Table_priv from mysql.tables_priv ORDER BY User;
User	Table_priv
user	
select distinct User,Authentication_string from mysql.user order by User;
User	Authentication_string
root	
user	
user2	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
user3	*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
select User,Table_priv from mysql.tables_priv ORDER BY User;
User	Table_priv
user	
BEGIN;
UPDATE mysql.user SET Authentication_string = ''
WHERE User = 'user2';
SET PASSWORD FOR 'user2'@'localhost' = 'newpass';
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
SHOW WARNINGS;
Level	Code	Message
Warning	1297	Got temporary error 266 'Time-out in NDB, probably caused by deadlock' from NDB
Error	1205	Lock wait timeout exceeded; try restarting transaction
Warning	1297	Got temporary error 274 'Time-out in NDB, probably caused by deadlock' from NDB
Warning	1297	Got temporary error 274 'Time-out in NDB, probably caused by deadlock' from NDB
Error	1205	Lock wait timeout exceeded; try restarting transaction
== Showing binlog server2 ==
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	CREATE USER 'user'@'localhost' IDENTIFIED by 'mypass'
master-bin.000001	#	Query	#	#	GRANT UPDATE ON t1 TO 'user'@'localhost'
master-bin.000001	#	Query	#	#	ALTER USER 'user'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*D8DECEC305209EEFEC43008E1D420E1AA06B19E0'
master-bin.000001	#	Query	#	#	RENAME USER 'user'@'localhost' TO 'newuser'@'localhost'
master-bin.000001	#	Query	#	#	GRANT SELECT ON test.* TO 'newuser'@'localhost' IDENTIFIED by 'mypass2'
master-bin.000001	#	Query	#	#	CREATE USER 'user2'@'localhost' IDENTIFIED by 'mypass'
master-bin.000001	#	Query	#	#	GRANT SELECT ON test.t1 TO 'user2'@'localhost'
master-bin.000001	#	Query	#	#	CREATE USER 'user'@'localhost'
master-bin.000001	#	Query	#	#	grant ALL PRIVILEGES on test.* to user@localhost with GRANT OPTION
master-bin.000001	#	Query	#	#	GRANT SELECT ON test.t1 TO 'user'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; FLUSH PRIVILEGES
master-bin.000001	#	Query	#	#	use `test`; REVOKE SELECT ON test.t1 FROM 'user'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'user3'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4' PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK
master-bin.000001	#	Query	#	#	use `test`; FLUSH PRIVILEGES
master-bin.000001	#	Query	#	#	use `test`; REVOKE UPDATE ON t1 FROM 'newuser'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user2'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; GRANT SELECT (a) ON `test`.`t1` TO 'user'@'localhost'
master-bin.000001	#	Query	#	#	use `test`; DROP USER 'newuser'@'localhost'
ROLLBACK;
=== making backup of new users ===
call mysql.mysql_cluster_backup_privileges();
==== clean up ====
DROP USER 'user2'@'localhost';
DROP USER 'user3'@'localhost';
DROP TABLE t1;
STOP SLAVE;
call mysql.mysql_cluster_backup_privileges();
call mysql.mysql_cluster_backup_privileges();
call mysql.mysql_cluster_backup_privileges();
call mysql.mysql_cluster_restore_local_privileges();
call mysql.mysql_cluster_restore_local_privileges();
call mysql.mysql_cluster_restore_local_privileges();

${this.title}

Code Editor : ndb_rpl_dist_priv.result