{"id":845,"date":"2020-08-10T18:10:47","date_gmt":"2020-08-10T10:10:47","guid":{"rendered":"http:\/\/www.gbase8.cn\/?p=845"},"modified":"2021-03-19T11:22:30","modified_gmt":"2021-03-19T03:22:30","slug":"gbase-8a%e6%95%b0%e6%8d%ae%e5%ba%93%e7%94%a8%e6%88%b7%e6%9f%a5%e7%9c%8b","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/845","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u6570\u636e\u5e93\u7528\u6237\u5143\u6570\u636e\u8868gbase.user\u67e5\u770b"},"content":{"rendered":"<p>GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\uff0c\u652f\u6301\u7528\u6237\u540d\u5bc6\u7801\u65b9\u5f0f\u767b\u9646\uff0c\u540c\u65f6\u63d0\u4f9b\u4e86\u767b\u9646\u7528\u6237\u4fe1\u606f\u5143\u6570\u636e\u8868gbase.user\uff0c\u4ee5\u4fbf\u7ba1\u7406\u5458\u4f7f\u7528\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u53c2\u8003<\/h2>\n\n\n\n<p><a href=\"https:\/\/www.gbase8.cn\/en\/471\/\">GBase 8a\u96c6\u7fa4\u6570\u636e\u5e93\u7528\u6237\u5bc6\u7801\u7b56\u7565\u529f\u80fd<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.gbase8.cn\/en\/4698\/\">GBase 8a\u7528\u6237\u5b89\u5168\u7b56\u7565\u5143\u6570\u636e\u8868user_check\u4ecb\u7ecd<\/a><\/p>\n\n\n\n<p>\u4ece\u7cfb\u7edf\u5143\u6570\u636e\u8868 gbase.user\u67e5\u770b\u3002\u5176\u5b57\u6bb5\u8bf4\u660e\u5982\u4e0b<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Field<\/td><td>Type<\/td><td>Null<\/td><td>Key<\/td><td>Default<\/td><td>&nbsp;<\/td><\/tr><tr><td>Host<\/td><td>char(60)<\/td><td>NO<\/td><td>PRI<\/td><td>&nbsp;<\/td><td>\u4e3b\u673a<\/td><\/tr><tr><td>User<\/td><td>char(16)<\/td><td>NO<\/td><td>PRI<\/td><td>&nbsp;<\/td><td>\u7528\u6237<\/td><\/tr><tr><td>Password<\/td><td>char(41)<\/td><td>NO<\/td><td>&nbsp;<\/td><td>&nbsp;<\/td><td>Password<\/td><\/tr><tr><td>Select_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>Select\u6743\u9650<\/td><\/tr><tr><td>Insert_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>Insert\u6743\u9650<\/td><\/tr><tr><td>Update_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>Update\u6743\u9650<\/td><\/tr><tr><td>Delete_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>Delete\u6743\u9650<\/td><\/tr><tr><td>Create_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>Create\u6743\u9650<\/td><\/tr><tr><td>Drop_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>Drop\u6743\u9650<\/td><\/tr><tr><td>Reload_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>Flush\u6743\u9650<\/td><\/tr><tr><td>Shutdown_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>&nbsp;<\/td><\/tr><tr><td>Process_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>Showprocesslist\u6743\u9650<\/td><\/tr><tr><td>File_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>Selectintooutfile\u6743\u9650\uff0c\u52a0\u8f7d\u7528\u6237\u5199\u6743\u9650<\/td><\/tr><tr><td>Grant_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>\u7ba1\u7406\u6743\u9650\u7684\u6743\u9650<\/td><\/tr><tr><td>References_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>&nbsp;<\/td><\/tr><tr><td>Index_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>\u521b\u5efa\u548c\u5220\u9664\u7d22\u5f15\u6743\u9650<\/td><\/tr><tr><td>Alter_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>Alter\u6743\u9650<\/td><\/tr><tr><td>Show_db_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>Showdatabase\u6743\u9650<\/td><\/tr><tr><td>Super_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>&nbsp;<\/td><\/tr><tr><td>Create_tmp_table_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>\u521b\u5efa\u4e34\u65f6\u8868\u6743\u9650<\/td><\/tr><tr><td>Lock_tables_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>\u9501\u8868\u6743\u9650<\/td><\/tr><tr><td>Execute_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>\u6267\u884c\u5b58\u50a8\u8fc7\u7a0b\u548c\u51fd\u6570\u6743\u9650<\/td><\/tr><tr><td>Repl_slave_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>&nbsp;<\/td><\/tr><tr><td>Repl_client_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>&nbsp;<\/td><\/tr><tr><td>Create_view_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>\u521b\u5efa\u89c6\u56fe<\/td><\/tr><tr><td>Show_view_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>Showcreateview<\/td><\/tr><tr><td>Create_routine_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>\u521b\u5efa\u5b58\u50a8\u8fc7\u7a0b\u548c\u51fd\u6570<\/td><\/tr><tr><td>Alter_routine_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>\u4fee\u6539\u5b58\u50a8\u8fc7\u7a0b\u548c\u51fd\u6570<\/td><\/tr><tr><td>Create_user_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>\u521b\u5efa\u7528\u6237<\/td><\/tr><tr><td>Event_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>&nbsp;<\/td><\/tr><tr><td>Trigger_priv<\/td><td>enum('N','Y')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>N<\/td><td>&nbsp;<\/td><\/tr><tr><td>ssl_type<\/td><td>enum('','ANY','X509','SPECIFIED')<\/td><td>NO<\/td><td>&nbsp;<\/td><td>&nbsp;<\/td><td>&nbsp;<\/td><\/tr><tr><td>ssl_cipher<\/td><td>blob<\/td><td>NO<\/td><td>&nbsp;<\/td><td>NULL<\/td><td>&nbsp;<\/td><\/tr><tr><td>x509_issuer<\/td><td>blob<\/td><td>NO<\/td><td>&nbsp;<\/td><td>NULL<\/td><td>&nbsp;<\/td><\/tr><tr><td>x509_subject<\/td><td>blob<\/td><td>NO<\/td><td>&nbsp;<\/td><td>NULL<\/td><td>&nbsp;<\/td><\/tr><tr><td>max_questions<\/td><td>int(11)unsigned<\/td><td>NO<\/td><td>&nbsp;<\/td><td>0<\/td><td>&nbsp;<\/td><\/tr><tr><td>max_updates<\/td><td>int(11)unsigned<\/td><td>NO<\/td><td>&nbsp;<\/td><td>0<\/td><td>&nbsp;<\/td><\/tr><tr><td>max_connections<\/td><td>int(11)unsigned<\/td><td>NO<\/td><td>&nbsp;<\/td><td>0<\/td><td>&nbsp;<\/td><\/tr><tr><td>max_user_connections<\/td><td>int(11)unsigned<\/td><td>NO<\/td><td>&nbsp;<\/td><td>0<\/td><td>\u540c\u65f6\u8fde\u63a5\u7684session\u6570<\/td><\/tr><tr><td>max_cpus<\/td><td>int(11)unsigned<\/td><td>NO<\/td><td>&nbsp;<\/td><td>0<\/td><td>&nbsp;<\/td><\/tr><tr><td>max_memories<\/td><td>int(11)unsigned<\/td><td>NO<\/td><td>&nbsp;<\/td><td>0<\/td><td>&nbsp;<\/td><\/tr><tr><td>max_tmp_space<\/td><td>int(11)unsigned<\/td><td>NO<\/td><td>&nbsp;<\/td><td>0<\/td><td>&nbsp;<\/td><\/tr><tr><td>resource_group<\/td><td>int(11)unsigned<\/td><td>NO<\/td><td>&nbsp;<\/td><td>0<\/td><td>&nbsp;<\/td><\/tr><tr><td>task_priority<\/td><td>int(11)unsigned<\/td><td>NO<\/td><td>&nbsp;<\/td><td>2<\/td><td>&nbsp;<\/td><\/tr><tr><td>user_limit_storage_size<\/td><td>char(15)<\/td><td>NO<\/td><td>&nbsp;<\/td><td>&nbsp;<\/td><td>&nbsp;<\/td><\/tr><tr><td>user_storage_size<\/td><td>int(11)unsigned<\/td><td>NO<\/td><td>&nbsp;<\/td><td>0<\/td><td>&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>","protected":false},"excerpt":{"rendered":"<p>\u5357\u5927\u901a\u7528GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\uff0c\u652f\u6301\u7528\u6237\u540d\u5bc6\u7801\u65b9\u5f0f\u767b\u9646\uff0c\u540c\u65f6\u63d0\u4f9b\u4e86\u767b\u9646\u7528\u6237\u4fe1\u606f\u5143\u6570\u636e\u8868gbase.user\uff0c\u4ee5\u4fbf\u7ba1\u7406\u5458\u4f7f\u7528\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[69],"class_list":["post-845","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-69"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/845","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=845"}],"version-history":[{"count":6,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/845\/revisions"}],"predecessor-version":[{"id":5158,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/845\/revisions\/5158"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}