Debian Codegraph @

mysql-test/suite/auth_sec/r/mysql_no_login.result

raw
1 INSTALL PLUGIN mysql_no_login SONAME 'mysql_no_login.so';
2 SELECT PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE, PLUGIN_DESCRIPTION
3 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'mysql_no_login';
4 PLUGIN_NAME mysql_no_login
5 PLUGIN_STATUS ACTIVE
6 PLUGIN_TYPE AUTHENTICATION
7 PLUGIN_DESCRIPTION No login authentication plugin
8 Creating users noauth, otheruser
9 Creating view, procedure, function
10 # Connect as otheruser - should succeed.
11 user() current_user() @@proxy_user
12 otheruser@localhost otheruser@localhost NULL
13 a
14 2
15 noauthdb.f1()
16 5
17 # Attempt to access underlying tables directly using otheruser - should fail.
18 # Connect as noauth - should fail.
19 #try to expire password of this plugin user - should warn
20 alter user noauth@localhost password expire;
21 ERROR HY000: Operation ALTER USER failed for 'noauth'@'localhost'
22 #uninstall plugin and try to login with this plugin user - should return error
23 uninstall plugin mysql_no_login;
24 # Connect as noauth - should fail.
25 INSTALL PLUGIN mysql_no_login SONAME 'mysql_no_login.so';
26 Creating users noauth, otheruser
27 Creating view, procedure, function
28 # Connect as otheruser - should succeed.
29 user() current_user() @@proxy_user
30 otheruser@localhost otheruser@localhost NULL
31 a
32 2
33 noauthdb.f1()
34 5
35 # Attempt to access underlying tables directly using otheruser - should fail.