Access Control and Account Management

最新推荐文章于 2024-10-31 23:41:03 发布

Erato Rabbit

最新推荐文章于 2024-10-31 23:41:03 发布

阅读量183

点赞数

分类专栏： DATA BASE 文章标签： mysql 数据库 database

本文链接：https://blog.csdn.net/Enchanter06/article/details/125335250

版权

DATA BASE 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

MySQL5.7的用户账户存储在mysql系统的usertable中，定义包括用户名和允许连接的主机。账户可能包含密码等认证凭证，这些由账户认证插件处理。MySQL支持多种认证插件，包括内置和外部认证方法。了解详细的权限控制和账户管理，参考相应章节。

摘要由CSDN通过智能技术生成

MySQL 5.7 Reference Manual / Security / Access Control and Account Management

在这里插入图片描述

1 Account User Names and Passwords

MySQL stores accounts in the user table of the mysql system database. An account is defined in terms of a user name and the client host or hosts from which the user can connect to the server. For information about account representation in the user table, see Section 6.2.3, “Grant Tables”.

An account may also have authentication credentials such as a password. The credentials are handled by the account authentication plugin. MySQL supports multiple authentication plugins. Some of them use built-in authentication methods, whereas others enable authentication using external authentication methods. See Section 6.2.13, “Pluggable Authentication”.