[MDEV-16959] KB page on mysql.user table misses info on authentication plugin used by default Created: 2018-08-13  Updated: 2020-08-25  Resolved: 2018-08-18

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System, Documentation
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Valerii Kravchuk Assignee: Kenneth Dyer (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

This KB page, https://mariadb.com/kb/en/library/mysqluser-table/, says that if plugin column is empty, default authentication plugin is used: "If empty, use the default."

But it says nothing on what this plugin is and what it depends on. Compare to https://dev.mysql.com/doc/refman/5.6/en/grant-tables.html that presents a lot of details:

"If the plugin column for an account row is empty, the server authenticates the account using the mysql_native_password or mysql_old_password plugin implicitly, depending on the format of the password hash in the Password column. If the Password value is empty or a 4.1 password hash (41 characters), the server uses mysql_native_password. If the password value is a pre-4.1 password hash (16 characters), the server uses mysql_old_password."



 Comments   
Comment by Kenneth Dyer (Inactive) [ 2018-08-18 ]

Fixed the issue by adding a new section to the mysql.user table page explaining the Authentication Plugin.

Generated at Thu Feb 08 08:32:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.