{"id":4297,"date":"2023-12-29T12:28:17","date_gmt":"2023-12-29T05:28:17","guid":{"rendered":"https:\/\/dev.artru.net\/?p=4297"},"modified":"2023-12-29T12:36:44","modified_gmt":"2023-12-29T05:36:44","slug":"huong-dan-tao-tai-khoan-trong-phpmyadmin","status":"publish","type":"post","link":"https:\/\/artru.net\/zh\/huong-dan-tao-tai-khoan-trong-phpmyadmin\/","title":{"rendered":"\u5728 phpMyAdmin \u4e2d\u521b\u5efa\u5e10\u6237\u7684\u8bf4\u660e"},"content":{"rendered":"<p class=\"wp-block-paragraph\">\u770b\u4f3c\u8fd9\u4e2a\u5de5\u4f5c\u5f88\u7b80\u5355\uff0c\u4f46\u662f\u5f53\u6211\u9047\u5230\u5b83\u7684\u65f6\u5019\uff0c\u5374\u82b1\u4e86\u6211\u4e0d\u5c11\u7684\u65f6\u95f4\u6765\u5904\u7406\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u63a5\u6536\u5ba2\u6237\u9879\u76ee\u7684\u60c5\u51b5\u4e0b\uff0c\u6211\u4eec\u9650\u5236\u8be2\u95ee\u7ba1\u7406\u5458\u767b\u5f55\u5e10\u6237\u548c\u5bc6\u7801\u3002\u6211\u4e5f\u4e0d\u8981\u6c42\u5ba2\u6237\u521b\u5efa\u65b0\u7684\u7528\u6237\u5e10\u6237\uff0c\u800c\u662f\u81ea\u5df1\u5c06\u5176\u6dfb\u52a0\u5230 phpMyAdmin \u4e2d\u3002\u9879\u76ee\u5b8c\u6210\u540e\uff0c\u6211\u4f1a\u5220\u9664\u8fd9\u4e2a\u8d26\u6237\uff0c\u4ea4\u7ed9\u5ba2\u6237\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">B\u01b0\u1edbc 1: T\u1ea1o user m\u1edbi trong b\u1ea3ng &#8220;wp_users&#8221;<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u8fdb\u5165<strong> phpMyAdmin \u2192 <\/strong>\u5230\u684c\u8fb9\u53bb<strong> <\/strong><code data-no-translation=\"\" data-no-auto-translation=\"\">wp_users<\/code><\/li>\n\n\n\n<li>\u8981\u521b\u5efa\u65b0\u5e10\u6237\uff0c\u8bf7\u5355\u51fb <code data-no-translation=\"\" data-no-auto-translation=\"\">Insert<\/code> \u5728\u9876\u90e8\u680f\u4e2d\u3002<\/li>\n\n\n\n<li><strong>\u7528\u6237\u767b\u5f55\uff1a<\/strong> \u8f93\u5165\u60a8\u7684\u767b\u5f55\u540d\u3002<\/li>\n\n\n\n<li><strong>\u7528\u6237\u5bc6\u7801\uff1a<\/strong> \u9009\u62e9 <code data-no-translation=\"\" data-no-auto-translation=\"\">MD5<\/code> \u2192 \u7136\u540e\u8f93\u5165\u8be5\u65b0\u5e10\u6237\u7684\u5bc6\u7801\u3002<\/li>\n\n\n\n<li>\u5411\u4e0b\u6eda\u52a8\u5e76\u6309\u4e0b\u6309\u94ae <code data-no-translation=\"\" data-no-auto-translation=\"\">Go<\/code> \u521b\u9020\u3002<\/li>\n\n\n\n<li>\u5b8c\u6210\u4e0a\u8ff0\u6b65\u9aa4\u540e\uff0c\u60a8\u5c06\u770b\u5230\u4e00\u4e2a\u521a\u521a\u521b\u5efa\u7684\u65b0\u7528\u6237 <strong>ID<\/strong>\u3002\u60a8\u9700\u8981\u590d\u5236\u4ee3\u7801 <strong>ID <\/strong>\u8fd9\u3002<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1005\" height=\"392\" src=\"https:\/\/cdn.artru.eu.org\/wp-content\/uploads\/2023\/12\/Tao-user-trong-bang-wp_users-phpMyAdmin.png\" alt=\"\u5728 wp_users phpMyAdmin \u8868\u4e2d\u521b\u5efa\u7528\u6237\" class=\"wp-image-4306\"\/><figcaption class=\"wp-element-caption\">\u5728 wp_users phpMyAdmin \u8868\u4e2d\u521b\u5efa\u7528\u6237<\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\">B\u01b0\u1edbc 2: Ph\u00e2n quy\u1ec1n user trong b\u1ea3ng &#8220;wp_usermeta&#8221;<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u8fdb\u5165\u8463\u4e8b\u4f1a<strong> <code data-no-translation=\"\" data-no-auto-translation=\"\">wp_usermeta<\/code><\/strong><\/li>\n\n\n\n<li>\u6309 <code data-no-translation=\"\" data-no-auto-translation=\"\">Insert<\/code> \u5728\u8868\u683c\u7684\u9876\u90e8\u680f\u4e2d <code data-no-translation=\"\" data-no-auto-translation=\"\">wp_usermeta<\/code><\/li>\n\n\n\n<li><strong>\u7528\u6237\u8eab\u4efd\uff1a<\/strong> \u586b\u5199\u4ee3\u7801 <strong>ID <\/strong>\u60a8\u5728\u6b65\u9aa4 1 \u4e2d\u521b\u5efa\u7684 ID\u3002\u4f8b\u5982\uff0c\u6211\u7684 ID \u662f 5\u3002<\/li>\n\n\n\n<li><strong>\u5143\u952e\uff1a<\/strong> g\u00f5 &#8220;<code data-no-translation=\"\" data-no-auto-translation=\"\">wp_capabilities<\/code>&#8220;.<\/li>\n\n\n\n<li><strong>\u5143\u503c\uff1a<\/strong> g\u00f5 &#8220;<code data-no-translation=\"\" data-no-auto-translation=\"\">a:1:{s:13:\"administrator\";b:1;}<\/code>&#8220;.<\/li>\n\n\n\n<li>\u5411\u4e0b\u6eda\u52a8\u5e76\u6309\u4e0b\u6309\u94ae <code data-no-translation=\"\" data-no-auto-translation=\"\">Go<\/code>.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1502\" height=\"823\" src=\"https:\/\/cdn.artru.eu.org\/wp-content\/uploads\/2023\/12\/Phan-quyen-user-trong-bang-wp_usermeta-phpMyAdmin.png\" alt=\"\u5728 wp_usermeta \u8868 phpMyAdmin \u4e2d\u5206\u914d\u7528\u6237\u6743\u9650\" class=\"wp-image-4313\"\/><figcaption class=\"wp-element-caption\">\u5728 wp_usermeta \u8868 phpMyAdmin \u4e2d\u5206\u914d\u7528\u6237\u6743\u9650<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">\u8fd9\u6837\u60a8\u5c31\u5df2\u7ecf\u5728 phpMyAdmin \u4e2d\u5b8c\u6210\u4e86\u65b0\u5e10\u6237\u7684\u521b\u5efa\u3002\u795d\u4f60\u597d\u8fd0\u3002<\/p>","protected":false},"excerpt":{"rendered":"<p>T\u01b0\u1edfng ch\u1eebng c\u00f4ng vi\u1ec7c n\u00e0y \u0111\u01a1n gi\u1ea3n, nh\u01b0ng \u0111\u1ebfn khi g\u1eb7p ph\u1ea3i th\u00ec m\u00ecnh c\u0169ng \u0111\u00e3 m\u1ea5t kha kh\u00e1 th\u1eddi gian \u0111\u1ec3 x\u1eed l\u00fd. Trong tr\u01b0\u1eddng h\u1ee3p ti\u1ebfp nh\u1eadn d\u1ef1 \u00e1n c\u1ee7a kh\u00e1ch h\u00e0ng, m\u00ecnh h\u1ea1n ch\u1ebf h\u1ecfi t\u00e0i kho\u1ea3n, m\u1eadt kh\u1ea9u \u0111\u0103ng nh\u1eadp Admin. M\u00ecnh c\u0169ng kh\u00f4ng y\u00eau c\u1ea7u kh\u00e1ch h\u00e0ng t\u1ea1o t\u00e0i kho\u1ea3n [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-4297","post","type-post","status-publish","format-standard","hentry","category-website"],"_links":{"self":[{"href":"https:\/\/artru.net\/zh\/wp-json\/wp\/v2\/posts\/4297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/artru.net\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/artru.net\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/artru.net\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/artru.net\/zh\/wp-json\/wp\/v2\/comments?post=4297"}],"version-history":[{"count":0,"href":"https:\/\/artru.net\/zh\/wp-json\/wp\/v2\/posts\/4297\/revisions"}],"wp:attachment":[{"href":"https:\/\/artru.net\/zh\/wp-json\/wp\/v2\/media?parent=4297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/artru.net\/zh\/wp-json\/wp\/v2\/categories?post=4297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/artru.net\/zh\/wp-json\/wp\/v2\/tags?post=4297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}