mirror of
https://github.com/MariaDB/server.git
synced 2025-08-25 11:51:36 +02:00
212fad1b7e
MTR .result files currently do not contain output to indicate if a change_user command has been executed in the corresponding .test files. Record change_user command in the following format in MTR output only if disable_query_log is set to false: change_user <user>,<password>,<db>; All new code of the whole pull request, including one or several files that are either new files or modified ones, are contributed under the BSD-new license. I am contributing on behalf of my employer Amazon Web Services, Inc.
19 lines
798 B
Text
19 lines
798 B
Text
create table global_priv_backup select * from mysql.global_priv;
|
|
update mysql.global_priv set priv=json_insert(priv, '$.plugin', 'unix_socket');
|
|
delete from mysql.global_priv where user != 'root';
|
|
flush privileges;
|
|
connect(localhost,USER,,test,MASTER_PORT,MASTER_SOCKET);
|
|
ERROR 28000: Access denied for user 'USER'@'localhost'
|
|
change_user buildbot,,;
|
|
ERROR 28000: Access denied for user 'USER'@'localhost'
|
|
replace mysql.global_priv select * from global_priv_backup;
|
|
flush privileges;
|
|
drop table global_priv_backup;
|
|
#
|
|
# MDEV-18151: Skipped error returning for GRANT/SET PASSWORD
|
|
#
|
|
CREATE USER foo;
|
|
GRANT EXECUTE ON * TO foo IDENTIFIED WITH unix_socket AS PASSWORD('bar');
|
|
ERROR HY000: SET PASSWORD is not applicable for users authenticating via unix_socket plugin
|
|
DROP USER foo;
|
|
# End of 10.5 tests
|