# # 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;