summaryrefslogtreecommitdiff
path: root/mysql-test/main/sp-security.result
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-17658 change the structure of mysql.user tableSergei Golubchik2018-12-121-11/+13
| | | | | | Implement User_table_json. Fix scripts to use mysql.global_priv. Fix tests.
* MDEV-12321 authentication plugin: SET PASSWORD supportSergei Golubchik2018-10-311-3/+1
| | | | | | | | | | | | | | | | | | | | | | | Support SET PASSWORD for authentication plugins. Authentication plugin API is extended with two optional methods: * hash_password() is used to compute a password hash (or digest) from the plain-text password. This digest will be stored in mysql.user table * preprocess_hash() is used to convert this digest into some memory representation that can be later used to authenticate a user. Build-in plugins convert the hash from hexadecimal or base64 to binary, to avoid doing it on every authentication attempt. Note a change in behavior: when loading privileges (on startup or on FLUSH PRIVILEGES) an account with an unknown plugin was loaded with a warning (e.g. "Plugin 'foo' is not loaded"). But such an account could not be used for authentication until the plugin is installed. Now an account like that will not be loaded at all (with a warning, still). Indeed, without plugin's preprocess_hash() method the server cannot know how to load an account. Thus, if a new authentication plugin is installed run-time, one might need FLUSH PRIVILEGES to activate all existing accounts that were using this new plugin.
* Use mysql.user.authentication_string for passwordSergei Golubchik2018-10-311-6/+6
| | | | | | | | | | | | Don't distinguish between a "password hash" and "authentication string" anymore. Now both are stored in mysql.user.authentication_string, both are handled identically internally. A "password hash" is just how some particular plugins interpret authentication string. Set mysql.user.plugin even if there is no password. The server will use mysql_native_password plugin in these cases, let's make it expicit. Remove LEX_USER::pwhash.
* Merge branch '10.2' into 10.3Sergei Golubchik2018-09-281-0/+26
|
* Merge branch '10.2' into 10.3Sergei Golubchik2018-06-301-0/+1
|
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-0/+775