{"id":2592,"date":"2013-04-08T17:31:18","date_gmt":"2013-04-08T17:31:18","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2013\/04\/08\/333-add-admin-via-mysql\/"},"modified":"2026-01-22T09:39:03","modified_gmt":"2026-01-22T14:39:03","slug":"add-admin-via-mysql","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/","title":{"rendered":"How to Create an Admin Account in WordPress via MySQL"},"content":{"rendered":"<div class=\"imh-youtube-embed\">\n\t\t\t<iframe src=\"https:\/\/www.youtube.com\/embed\/nTy5EEDV6ys\" title=\"How to Create an Admin Account in WordPress via MySQL\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n\t\t\t<script type=\"application\/ld+json\">{\"@context\":\"https:\/\/schema.org\",\"@type\":\"VideoObject\",\"name\":\"How to Create an Admin Account in WordPress via MySQL\",\"description\":\"Learn how to add an Admin account to your WordPress site with MySQL.\",\"uploadDate\":\"2016-04-06\",\"thumbnailUrl\":\"https:\/\/img.youtube.com\/vi\/nTy5EEDV6ys\/hqdefault.jpg\"}<\/script>\n\t\t<\/div>\n\n\n<p>When working with programs that require you to log in, such as <strong>WordPress<\/strong>, there can be times when you seem to be locked out of your account. This can happen via a code error, a hack, accidental admin <strong>account<\/strong> deletion, or a malicious site partner changing information on you.<\/p>\n<p>If this happens, you will need to <strong>create<\/strong> a new admin account in order to regain access to the administration interface. You will need to do this by interacting directly with the database. Below is a step by step guide for doing just that in your WordPress installation. We also have a helpful guide on <a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-user-role-editor\/\" target=\"_blank\" rel=\"noopener\">How to Create a WordPress User in the Dashboard<\/a>.<\/p>\n<p>Did you know? Not all hosting companies provide free access to cPanel. InMotion does and it\u2019s just one of the many features of our various {web hosting plans}.<\/p>\n<h2>Creating a new admin account via MySQL<\/h2>\n<p class=\"alert alert-info\">The following instructions assume that your database table prefix is set to \u201cwp_\u201d. If you are using something different, then make sure to adjust your code accordingly. <i>For example, if you are using \u201cwptables_\u201d instead of \u201cwp_\u201d, then the code \u201cINSERT INTO `wp_users`\u201d would be \u201cINSERT INTO `wptables_users`\u201d<\/i>.<\/p>\n<ol class=\"article_list\">\n<li>To begin, <a href=\"\/support\/edu\/cpanel\/how-to-log-into-cpanel\/\">log into your cPanel interface<\/a>.\n<div style=\"clear: both;\">\u00a0<\/div>\n<\/li>\n<li><a href=\"\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin.png\" rel=\"lightbox-0\"><img decoding=\"async\" width=\"1024\" height=\"178\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin-1024x178.png\" class=\"optimized-lcp-image\" alt=\"click the phpmyadmin icon\" loading=\"eager\" fetchpriority=\"high\" sizes=\"(max-width: 768px) 100vw, 768px\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin-1024x178.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin-300x52.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin-768x134.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin.png 1131w\"><\/a>From the main cPanel screen, find the <em>Databases<\/em> category and click on the icon entitled <strong>phpMyAdmin<\/strong>.\n<div style=\"clear: both;\">\u00a0<\/div>\n<\/li>\n<li>Once the first screen appears, look to the left-hand sidebar and click on the database for your specific WordPress installation. If you do not know which database is the correct one, you can find out by using <a href=\"\/support\/edu\/wordpress\/find-db-name-2\/\">these instructions<\/a>.\n<div style=\"clear: both;\">\u00a0<\/div>\n<\/li>\n<li><a href=\"\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_sql-tab.png\" rel=\"lightbox-0\"><img decoding=\"async\" class=\"std_ss\" style=\"float: right; margin: 0px 0px 15px 15px;\" title=\"Click here to view the larger image\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_sql-tab.png\" alt=\"click on the SQL tab\" width=\"200\"><\/a>After the database information loads, you will need to find the tab named <strong>SQL<\/strong> and click on it.\n<div style=\"clear: both;\">\u00a0<\/div>\n<\/li>\n<li>This leads you to an SQL editor where you will enter some code that will create a new admin account for you. Below is the code to create a new admin account named <strong>newadmin<\/strong> with the password <strong>pass123<\/strong>. You may change any of the content in red to fit your needs, but leave all other data as is.\n<div class=\"code_block\">INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`)<br>VALUES (\u2018<span style=\"color: red;\">newadmin<\/span>\u2018, MD5(\u2018<span style=\"color: red;\">pass123<\/span>\u2018), \u2018<span style=\"color: red;\">firstname lastname<\/span>\u2018, \u2018<span style=\"color: red;\">email@example.com<\/span>\u2018, \u20180\u2019);\n<p>INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)<br>VALUES (NULL, (Select max(id) FROM wp_users), \u2018wp_capabilities\u2019, \u2018a:1:{s:13:\u201dadministrator\u201d;s:1:\u201d1\u2033;}\u2019);<\/p>\n<p>INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)<br>VALUES (NULL, (Select max(id) FROM wp_users), \u2018wp_user_level\u2019, \u201910\u2019);<\/p>\n<\/div>\n<div style=\"clear: both;\">\u00a0<\/div>\n<\/li>\n<li><a href=\"\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_query-click-go.png\" rel=\"lightbox-0\"><img decoding=\"async\" class=\"std_ss\" style=\"float: right; margin: 0px 0px 15px 15px;\" title=\"Click here to view the larger image\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_query-click-go.png\" alt=\"click go button\" width=\"200\"><\/a>After replacing any data fields you need, click the <strong>Go<\/strong> button to perform the insertion.\n<div style=\"clear: both;\">\u00a0<\/div>\n<\/li>\n<li>This should simply refresh the screen and you should see the messsage \u2018<em>1 row affected<\/em>\u2018 after each of the three SQL statements. This means the insertion ran smoothly. From here, visit your wordpress admin login area as normal and use the new admin login information. You should get to the admin interface without issue.\n<div style=\"clear: both;\">\u00a0<\/div>\n<\/li>\n<\/ol>\n\n<div class=\"jumbotron\">\r\n<p>If you need a new home for your WordPress site, look no further than InMotion\u2019s <a href=\"https:\/\/www.inmotionhosting.com\/wordpress-hosting\">WordPress Hosting<\/a> solutions for secure, optimized, budget-friendly servers.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/design.inmotionhosting.com\/assets\/icons\/standard\/check-blue.svg\" alt=\"check mark\" width=\"24\" height=\"24\" \/>Fast &amp; Easy Transfers    <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/design.inmotionhosting.com\/assets\/icons\/standard\/check-blue.svg\" alt=\"check mark\" width=\"24\" height=\"24\" \/>Free SSLs    <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/design.inmotionhosting.com\/assets\/icons\/standard\/check-blue.svg\" alt=\"check mark\" width=\"24\" height=\"24\" \/>Hack Protection    <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/design.inmotionhosting.com\/assets\/icons\/standard\/check-blue.svg\" alt=\"check mark\" width=\"24\" height=\"24\" \/>Affordable<\/p>\r\n<p><a class=\"btn btn-primary btn-lg\" href=\"https:\/\/www.inmotionhosting.com\/wordpress-hosting\">View WordPress Hosting Plans<\/a><\/p>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>When working with programs that require you to log in, such as WordPress, there can be times when you seem to be locked out of your account. This can happen via a code error, a hack, accidental admin account deletion, or a malicious site partner changing information on you. If this happens, you will need<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/\"> Read More ><\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4325,56,4305],"tags":[],"class_list":["post-2592","post","type-post","status-publish","format-standard","hentry","category-wordpress-hosting","category-wordpress","category-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Create an Admin User in the MySQL database | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Learn how to create an admin account in your WordPress database using MySQL.\" \/>\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.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create an Admin User in the MySQL database | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Learn how to create an admin account in your WordPress database using MySQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-04-08T17:31:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-22T14:39:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin.png\" \/>\n<meta name=\"author\" content=\"Scott Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Scott Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"How to Create an Admin Account in WordPress via MySQL\",\"datePublished\":\"2013-04-08T17:31:18+00:00\",\"dateModified\":\"2026-01-22T14:39:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/\"},\"wordCount\":526,\"commentCount\":63,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin.png\",\"articleSection\":[\"WordPress Hosting\",\"WordPress Tutorials\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/\",\"name\":\"How to Create an Admin User in the MySQL database | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin.png\",\"datePublished\":\"2013-04-08T17:31:18+00:00\",\"dateModified\":\"2026-01-22T14:39:03+00:00\",\"description\":\"Learn how to create an admin account in your WordPress database using MySQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin.png\",\"width\":1131,\"height\":197,\"caption\":\"Click here to view the larger image\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create an Admin Account in WordPress via MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\",\"name\":\"Scott Mitchell\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create an Admin User in the MySQL database | InMotion Hosting","description":"Learn how to create an admin account in your WordPress database using MySQL.","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.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/","og_locale":"en_US","og_type":"article","og_title":"How to Create an Admin User in the MySQL database | InMotion Hosting","og_description":"Learn how to create an admin account in your WordPress database using MySQL.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2013-04-08T17:31:18+00:00","article_modified_time":"2026-01-22T14:39:03+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin.png","type":"","width":"","height":""}],"author":"Scott Mitchell","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Scott Mitchell","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"How to Create an Admin Account in WordPress via MySQL","datePublished":"2013-04-08T17:31:18+00:00","dateModified":"2026-01-22T14:39:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/"},"wordCount":526,"commentCount":63,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin.png","articleSection":["WordPress Hosting","WordPress Tutorials","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/","name":"How to Create an Admin User in the MySQL database | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin.png","datePublished":"2013-04-08T17:31:18+00:00","dateModified":"2026-01-22T14:39:03+00:00","description":"Learn how to create an admin account in your WordPress database using MySQL.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_wordpress_add-admin-mysql_01-phpmyadmin.png","width":1131,"height":197,"caption":"Click here to view the larger image"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/add-admin-via-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Create an Admin Account in WordPress via MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed","name":"Scott Mitchell","url":"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":{"id":56,"name":"WordPress Tutorials","slug":"wordpress","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2592","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=2592"}],"version-history":[{"count":10,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2592\/revisions"}],"predecessor-version":[{"id":131468,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2592\/revisions\/131468"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=2592"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=2592"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=2592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}