mysql创建用户并授权语句_MySQL创建用户与授权

论坛 期权论坛 编程之家     
选择匿名的用户   2021-6-2 17:00   1187   0

查看当前用户

SELECT CURRENT_USER();

38e8258ac4d9a4f90df9a000a6922d33.png

CREATE USER 语法

CREATE USER [IF NOT EXISTS]

user [auth_option] [, user [auth_option]] ...DEFAULT ROLE role [, role]...[REQUIRE {NONE | tls_option [[AND]tls_option] ...}][WITH resource_option [resource_option]...][password_option | lock_option]...user:

(see Section6.2.4, “Specifying Account Names”)

auth_option: {

IDENTIFIEDBY 'auth_string'

| IDENTIFIED WITHauth_plugin| IDENTIFIED WITH auth_plugin BY 'auth_string'

| IDENTIFIED WITH auth_plugin AS 'hash_string'}

tls_option: {

SSL|X509| CIPHER 'cipher'

| ISSUER 'issuer'

| SUBJECT 'subject'}

resource_option: {

MAX_QUERIES_PER_HOURcount<

分享到 :
0 人收藏
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

积分:3875789
帖子:775174
精华:0
期权论坛 期权论坛
发布
内容

下载期权论坛手机APP