# scope
SELECT @@session.wsrep_sst_auth; ERROR HY000: Variable 'wsrep_sst_auth' is a GLOBAL variable SET @@global.wsrep_sst_auth='user:pass';
SELECT @@global.wsrep_sst_auth;
@@global.wsrep_sst_auth
********
# valid values SET @@global.wsrep_sst_auth=user;
SELECT @@global.wsrep_sst_auth;
@@global.wsrep_sst_auth
******** SET @@global.wsrep_sst_auth='user:1234';
SELECT @@global.wsrep_sst_auth;
@@global.wsrep_sst_auth
******** SET @@global.wsrep_sst_auth='hyphenated-user-name:';
SELECT @@global.wsrep_sst_auth;
@@global.wsrep_sst_auth
******** SET @@global.wsrep_sst_auth=default;
SELECT @@global.wsrep_sst_auth;
@@global.wsrep_sst_auth
NULL SET @@global.wsrep_sst_auth=NULL;
SELECT @@global.wsrep_sst_auth;
@@global.wsrep_sst_auth
NULL
# invalid values SET @@global.wsrep_sst_auth=1; ERROR42000: Incorrect argument type to variable 'wsrep_sst_auth'
SELECT @@global.wsrep_sst_auth;
@@global.wsrep_sst_auth
NULL SET @@global.wsrep_sst_auth=user:pass; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':pass' at line 1 SET @@global.wsrep_sst_auth='user new:pass'; ERROR42000: Variable 'wsrep_sst_auth' can't be set to the value of 'user new:pass' SET @@global.wsrep_sst_auth='user$new:pass'; ERROR42000: Variable 'wsrep_sst_auth' can't be set to the value of 'user$new:pass' SET @@global.wsrep_sst_auth="user'new:pass"; ERROR42000: Variable 'wsrep_sst_auth' can't be set to the value of 'user'new:pass' SET @@global.wsrep_sst_auth="user;new:pass"; ERROR42000: Variable 'wsrep_sst_auth' can't be set to the value of 'user;new:pass' SET @@global.wsrep_sst_auth="user|new:pass"; ERROR42000: Variable 'wsrep_sst_auth' can't be set to the value of 'user|new:pass' SET @@global.wsrep_sst_auth="user&new:pass"; ERROR42000: Variable 'wsrep_sst_auth' can't be set to the value of 'user&new:pass' SET @@global.wsrep_sst_auth="user\\new:pass"; ERROR42000: Variable 'wsrep_sst_auth' can't be set to the value of 'user\new:pass' SET @@global.wsrep_sst_auth="user\"new:pass"; ERROR42000: Variable 'wsrep_sst_auth' can't be set to the value of 'user"new:pass' SET @@global.wsrep_sst_auth="user\nnew:pass"; ERROR42000: Variable 'wsrep_sst_auth' can't be set to the value of 'user
new:pass' SET @@global.wsrep_sst_auth="user\tnew:pass"; ERROR42000: Variable 'wsrep_sst_auth' can't be set to the value of 'user new:pass'
# restore the initial value SET @@global.wsrep_sst_auth = @wsrep_sst_auth_global_saved;
call mtr.add_suppression("WSREP: Illegal character in variable:");
# End of test
Die Informationen auf dieser Webseite wurden
nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit,
noch Qualität der bereit gestellten Informationen zugesichert.
Bemerkung:
Die farbliche Syntaxdarstellung und die Messung sind noch experimentell.