企业优惠唯一官方(www.qyyh.com)- 实用的企业优惠信息大全

手机版 网站地图 txt地图 html地图

域名ssl分类
热门标签:
最新标签:

mysql创建用户出现错误

日期:2022/10/02 06:48作者:人气:

导读:...

不能这样简单的插入数据库创建用户,因为'ssl_cipher'字段不能为空,必需指定数值,应该使用GRANT命令创建用户,格式: 13.5.1.3. GRANT和REVOKE语法 GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ... ON [object_type] {tbl_name | * | *.* | db_name.*} TO user [IDENTIFIED BY [PASSWORD] 'password'] [, user [IDENTIFIED BY [PASSWORD] 'password']] ... [REQUIRE NONE | [{SSL| X509}] [CIPHER 'cipher' [AND]] [ISSUER 'issuer' [AND]] [SUBJECT 'subject']] [WITH with_option [with_option] ...] object_type = TABLE | FUNCTION | PROCEDURE with_option = GRANT OPTION | MAX_QUERIES_PER_HOUR count | MAX_UPDATES_PER_HOUR count | MAX_CONNECTIONS_PER_HOUR count | MAX_USER_CONNECTIONS count REVOKE priv_type [(column_list)] [, priv_type [(column_list)]] ... ON [object_type] {tbl_name | * | *.* | db_name.*} FROM user [, user] ... REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ... GRANT和REVOKE语句允许系统管理员创建MySQL用户&n

网站地图

Copyright © 2022-2023 qyyh.com 企业优惠网 版权所有 工信部备案号:蜀ICP备19014027号-8

声明: 企业优惠