{"id":8442,"date":"2020-10-13T10:36:59","date_gmt":"2020-10-13T10:36:59","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=8442"},"modified":"2024-04-24T07:59:08","modified_gmt":"2024-04-24T06:59:08","slug":"how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/","title":{"rendered":"How to Add an Admin User to the WordPress Database from phpMyAdmin?"},"content":{"rendered":"<p><strong>Steps to add an Admin user to the WordPress database from phpMyAdmin:<\/strong><\/p>\n<ul>\n<li>Log in to <strong>cPanel<\/strong>.<\/li>\n<li>Navigate to the <strong>Databases<\/strong> section and click on <strong>phpMyAdmin<\/strong>.<\/li>\n<li>Choose your <strong>database<\/strong>. It might be possible that you have multiple databases in your phpMyadmin.<\/li>\n<\/ul>\n<p><strong>So to find the appropriate database name just follow these steps:<\/strong><\/p>\n<ul>\n<li>On the <strong>cPanel<\/strong> dashboard, click on <strong>File Manager<\/strong>.<\/li>\n<li>Go to the <strong>public_html<\/strong> folder and click on <strong>wp<\/strong>.<\/li>\n<li>On the right side, you will get files and folders in that, right-click on the <strong>wp-config.php<\/strong> file and click on the <strong>view<\/strong> option.<\/li>\n<li>In this section, you will see the <strong>database name<\/strong>.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-56.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10494 size-full\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-56.png\" alt=\"\" width=\"1366\" height=\"768\" \/><\/a><\/p>\n<ul>\n<li>Now, go back to <strong>phpMyAdmin<\/strong> and click on the <strong>databasename_users<\/strong> table. In our case, the database table name is this.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-65.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10497 size-full\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-65.png\" alt=\"\" width=\"1366\" height=\"768\" \/><\/a><\/p>\n<ul>\n<li>Click on <strong>Insert<\/strong>.<\/li>\n<li>Fill the required information in the mentioned fields.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-62.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10498 size-full\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-62.png\" alt=\"\" width=\"1366\" height=\"768\" \/><\/a><\/p>\n<ul>\n<li>In the <strong>user_pass<\/strong> dropdown, select <strong>MD5<\/strong>.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-66-Pass.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10500 size-full\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-66-Pass.png\" alt=\"\" width=\"1366\" height=\"768\" \/><\/a><\/p>\n<ul>\n<li>Click on <strong>Go<\/strong>.<\/li>\n<li>Click on the <strong>databasename_users<\/strong> table.<\/li>\n<li>As you can see the recently added record with <strong>ID<\/strong>. In the next step, we will use this <strong>id<\/strong> in the <strong>user_id<\/strong> field.<\/li>\n<li>Select the <strong>databasename_usermeta<\/strong> table and click on <strong>Insert<\/strong>.<\/li>\n<li>Enter the id of the user which we have created in the previous query.<\/li>\n<li>In the <strong>meta_key<\/strong> textbox, enter the <strong>databasename_capabilities<\/strong>. In our case, <strong>meta_key<\/strong> is this.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-71.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10502 size-full\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-71.png\" alt=\"\" width=\"1366\" height=\"768\" \/><\/a><\/p>\n<ul>\n<li>In the <strong>meta_value<\/strong> textbox add this code: <strong>a:1:{s:13:&#8221;administrator&#8221;;s:1:&#8221;1&#8243;;}<\/strong><\/li>\n<li>Again in this section, enter the <strong>user_id<\/strong>.<\/li>\n<li>In the <strong>meta_key<\/strong> textbox, enter the <strong>databasename_user_level<\/strong>. In our case, <strong>meta_key<\/strong> is this.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-72.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10504 size-full\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-72.png\" alt=\"\" width=\"1366\" height=\"768\" \/><\/a><\/p>\n<ul>\n<li>In the <strong>meta_value<\/strong> textbox, enter the value as <strong>10<\/strong>.<\/li>\n<li>Click on <strong>Go<\/strong>.<\/li>\n<\/ul>\n<p><strong>Now, follow the steps to check the newly added admin user in WordPress:<\/strong><\/p>\n<ul>\n<li>Log in to <strong>WordPress<\/strong> with a newly created <strong>username and password<\/strong>.<\/li>\n<li>Click on <strong>Users<\/strong>.<\/li>\n<li>As you can see the newly created <strong>username <\/strong>with<strong> Administrator<\/strong> role.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-73.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10505 size-full\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-73.png\" alt=\"\" width=\"1366\" height=\"768\" \/><\/a><\/p>\n<p>That&#8217;s how you can add an admin user to the WordPress Database from phpMyAdmin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Steps to add an Admin user to the WordPress database from phpMyAdmin: Log in to cPanel. Navigate to the Databases section and click on phpMyAdmin. Choose your database. It might be possible that you have multiple databases in your phpMyadmin. So to find the appropriate database name just follow these steps: On the cPanel dashboard, [&hellip;]<\/p>\n","protected":false},"author":23,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-8442","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-wordpress-faq"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Add an Admin User to the WordPress Database from phpMyAdmin?<\/title>\n<meta name=\"description\" content=\"To add an Admin user to the WordPress database using phpMyAdmin, follow these steps.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Add an Admin User to the WordPress Database from phpMyAdmin?\" \/>\n<meta property=\"og:description\" content=\"To add an Admin user to the WordPress database using phpMyAdmin, follow these steps.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-13T10:36:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-24T06:59:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-56.png\" \/>\n<meta name=\"author\" content=\"Gandhar Kulkarni\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gandhar Kulkarni\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/\",\"name\":\"How to Add an Admin User to the WordPress Database from phpMyAdmin?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-56.png\",\"datePublished\":\"2020-10-13T10:36:59+00:00\",\"dateModified\":\"2024-04-24T06:59:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/88ac09123c3123e4375c7f7ea6fb0a22\"},\"description\":\"To add an Admin user to the WordPress database using phpMyAdmin, follow these steps.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-56.png\",\"contentUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-56.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Add an Admin User to the WordPress Database from phpMyAdmin?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/88ac09123c3123e4375c7f7ea6fb0a22\",\"name\":\"Gandhar Kulkarni\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b73c712f8d261f04bab6b0d466a2164e?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b73c712f8d261f04bab6b0d466a2164e?s=96&d=blank&r=g\",\"caption\":\"Gandhar Kulkarni\"},\"description\":\"Gandhar is a marketing professional at MilesWeb. He is passionate about exploring and writing technical articles related to web hosting and digital marketing. Also, he has over four years of experience in digital marketing. Besides content writing, he tries to engage an online audience through YouTube video tutorials and social media activities.\",\"sameAs\":[\"https:\/\/www.milesweb.co.uk\"],\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/gandhar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Add an Admin User to the WordPress Database from phpMyAdmin?","description":"To add an Admin user to the WordPress database using phpMyAdmin, follow these steps.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/","og_locale":"en_GB","og_type":"article","og_title":"How to Add an Admin User to the WordPress Database from phpMyAdmin?","og_description":"To add an Admin user to the WordPress database using phpMyAdmin, follow these steps.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2020-10-13T10:36:59+00:00","article_modified_time":"2024-04-24T06:59:08+00:00","og_image":[{"url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-56.png","type":"","width":"","height":""}],"author":"Gandhar Kulkarni","twitter_misc":{"Written by":"Gandhar Kulkarni","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/","name":"How to Add an Admin User to the WordPress Database from phpMyAdmin?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-56.png","datePublished":"2020-10-13T10:36:59+00:00","dateModified":"2024-04-24T06:59:08+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/88ac09123c3123e4375c7f7ea6fb0a22"},"description":"To add an Admin user to the WordPress database using phpMyAdmin, follow these steps.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/#primaryimage","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-56.png","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Screenshot-56.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-add-an-admin-user-to-the-wordpress-database-from-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Add an Admin User to the WordPress Database from phpMyAdmin?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/88ac09123c3123e4375c7f7ea6fb0a22","name":"Gandhar Kulkarni","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b73c712f8d261f04bab6b0d466a2164e?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b73c712f8d261f04bab6b0d466a2164e?s=96&d=blank&r=g","caption":"Gandhar Kulkarni"},"description":"Gandhar is a marketing professional at MilesWeb. He is passionate about exploring and writing technical articles related to web hosting and digital marketing. Also, he has over four years of experience in digital marketing. Besides content writing, he tries to engage an online audience through YouTube video tutorials and social media activities.","sameAs":["https:\/\/www.milesweb.co.uk"],"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/gandhar\/"}]}},"views":379,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8442","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=8442"}],"version-history":[{"count":5,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8442\/revisions"}],"predecessor-version":[{"id":15629,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8442\/revisions\/15629"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=8442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=8442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=8442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}