{"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\/en\/huong-dan-tao-tai-khoan-trong-phpmyadmin\/","title":{"rendered":"Instructions for creating an account in phpMyAdmin"},"content":{"rendered":"<p>It seemed like this job was simple, but when I encountered it, it took me quite a bit of time to handle it.<\/p>\n\n\n\n<p>In the case of receiving customer projects, we limit asking for Admin login accounts and passwords. I also do not ask customers to create new user accounts, but add them themselves in phpMyAdmin. After completing the project, I will delete this account and hand it over to the customer.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 1: Create a new user in the &quot;wp_users&quot; table<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Access to<strong> phpMyAdmin \u2192 <\/strong>go to the table<strong> <\/strong><code data-no-translation=\"\" data-no-auto-translation=\"\">wp_users<\/code><\/li>\n\n\n\n<li>To create a new account, click <code data-no-translation=\"\" data-no-auto-translation=\"\">Insert<\/code> in the top bar.<\/li>\n\n\n\n<li><strong>user_login:<\/strong> Enter your login name.<\/li>\n\n\n\n<li><strong>user_pass:<\/strong> select <code data-no-translation=\"\" data-no-auto-translation=\"\">MD5<\/code> \u2192 then enter the password for this new account.<\/li>\n\n\n\n<li>Scroll down and press the button <code data-no-translation=\"\" data-no-auto-translation=\"\">Go<\/code> to create.<\/li>\n\n\n\n<li>After the step above, you will see a new user just created <strong>ID<\/strong>. You need to copy the code <strong>ID <\/strong>This.<\/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=\"Create users in the wp_users phpMyAdmin table\" class=\"wp-image-4306\"\/><figcaption class=\"wp-element-caption\">Create users in the wp_users phpMyAdmin table<\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\">Step 2: Assign user rights in the &quot;wp_usermeta&quot; table<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the board<strong> <code data-no-translation=\"\" data-no-auto-translation=\"\">wp_usermeta<\/code><\/strong><\/li>\n\n\n\n<li>Press <code data-no-translation=\"\" data-no-auto-translation=\"\">Insert<\/code> in the top bar of the table <code data-no-translation=\"\" data-no-auto-translation=\"\">wp_usermeta<\/code><\/li>\n\n\n\n<li><strong>user_id:<\/strong> fill in the code <strong>ID <\/strong>that you created in step 1. For example my ID is 5.<\/li>\n\n\n\n<li><strong>meta_key:<\/strong> type &quot;<code data-no-translation=\"\" data-no-auto-translation=\"\">wp_capabilities<\/code>\".<\/li>\n\n\n\n<li><strong>meta_value:<\/strong> type &quot;<code data-no-translation=\"\" data-no-auto-translation=\"\">a:1:{s:13:\"administrator\";b:1;}<\/code>\".<\/li>\n\n\n\n<li>Scroll down and press the button <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=\"Assign user rights in wp_usermeta phpMyAdmin table\" class=\"wp-image-4313\"\/><figcaption class=\"wp-element-caption\">Assign user rights in wp_usermeta phpMyAdmin table<\/figcaption><\/figure>\n<\/div>\n\n\n<p>So you have completed creating a new account in phpMyAdmin. Good luck.<\/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 [&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\/en\/wp-json\/wp\/v2\/posts\/4297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/artru.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/artru.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/artru.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/artru.net\/en\/wp-json\/wp\/v2\/comments?post=4297"}],"version-history":[{"count":0,"href":"https:\/\/artru.net\/en\/wp-json\/wp\/v2\/posts\/4297\/revisions"}],"wp:attachment":[{"href":"https:\/\/artru.net\/en\/wp-json\/wp\/v2\/media?parent=4297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/artru.net\/en\/wp-json\/wp\/v2\/categories?post=4297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/artru.net\/en\/wp-json\/wp\/v2\/tags?post=4297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}