mirror of
https://github.com/MariaDB/server.git
synced 2025-02-15 18:05:32 +01:00
31 lines
630 B
Text
31 lines
630 B
Text
install plugin unix_socket soname 'auth_socket.so';
|
|
#
|
|
# with named user
|
|
#
|
|
create user USER identified via unix_socket;
|
|
#
|
|
# name match = ok
|
|
#
|
|
select user(), current_user(), database();
|
|
user() current_user() database()
|
|
USER@localhost USER@% test
|
|
#
|
|
# name does not match = failure
|
|
#
|
|
drop user USER;
|
|
#
|
|
# and now with anonymous user
|
|
#
|
|
grant SELECT ON test.* TO '' identified via unix_socket;
|
|
#
|
|
# name match = ok
|
|
#
|
|
select user(), current_user(), database();
|
|
user() current_user() database()
|
|
USER@localhost @% test
|
|
#
|
|
# name does not match = failure
|
|
#
|
|
delete from mysql.user where user='';
|
|
FLUSH PRIVILEGES;
|
|
uninstall plugin unix_socket;
|