| 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. |