mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 00:04:31 +03:00
32 lines
608 B
Plaintext
32 lines
608 B
Plaintext
#
|
|
# with named user
|
|
#
|
|
create user 'USER' identified via unix_socket;
|
|
grant select on test.* to 'USER';
|
|
#
|
|
# 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;
|
|
delete from mysql.db;
|