[MDEV-19483] ALTER USER ... REQUIRE SSL is not replicated to slave Created: 2019-05-15  Updated: 2019-06-17  Resolved: 2019-06-17

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Replication
Affects Version/s: 10.3.12
Fix Version/s: 10.2.22, 10.3.13

Type: Bug Priority: Minor
Reporter: Silver Asu Assignee: Elena Stepanova
Resolution: Duplicate Votes: 0
Labels: need_feedback

Issue Links:
Duplicate
is duplicated by MDEV-17753 ALTER USER fail to replicate Closed

 Description   

On MASTER:
CREATE USER 'xxx'@'1.2.3.4' IDENTIFIED BY 'xxx';
ALTER USER 'xxx'@'1.2.3.4' REQUIRE SSL;

select ssl_type from mysql.user where user like 'xxx';
 
+----------+
 
| ssl_type |
 
+----------+
 
| ANY      |
 
+----------+

On SLAVE:

select ssl_type from mysql.user where user like 'xxx';
 
+----------+
 
| ssl_type |
 
+----------+
 
|          |
 
+----------+



 Comments   
Comment by Elena Stepanova [ 2019-05-16 ]

Please try a newer version of 10.3. The problem appears to be fixed in 10.3.13, most likely in the scope of MDEV-17753.

Generated at Thu Feb 08 08:52:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.