{"id":2149,"date":"2018-08-24T16:25:16","date_gmt":"2018-08-24T16:25:16","guid":{"rendered":"http:\/\/dbtut.com\/?p=2149"},"modified":"2018-11-18T20:53:30","modified_gmt":"2018-11-18T20:53:30","slug":"how-to-reset-to-mysql-root-password","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/","title":{"rendered":"How to reset to MySQL root password"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Some time we are facing issue like we forgot the MySQL root password. So here we are providing just some simple steps to reset the MySQL root password.<\/p>\n<p><strong>Stop the MySQL service<\/strong><\/p>\n<pre class=\"lang:default decode:true\"># service mysqld stop\r\n\r\nor\r\n\r\n# \/etc\/init.d\/mysqld stop<\/pre>\n<p style=\"text-align: left;\"><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/532.png\" width=\"356\" height=\"31\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000; font-size: 12pt;\"><strong>Note :-<\/strong><\/span><em><span style=\"font-size: 12pt;\"> In Redhat-7 or Centos-7 use below command to stop the service.<\/span><\/em><\/p>\n<pre class=\"lang:default decode:true\"># systemctl stop mysqld\\<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/603.png\" width=\"536\" height=\"102\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Start the mysql service with &#8211;skip-grant-tables option<\/strong><\/p>\n<pre class=\"lang:default decode:true\"># mysqld_safe --skip-grant-tables &amp;<\/pre>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>Note:-<\/strong>\u00a0<em><span style=\"color: #000000;\">I<\/span><\/em><\/span><em><span style=\"color: #000000;\">f a<\/span>bove command does not work in your environment then put <strong>skip-grant-tables<\/strong> into the <strong>my.cnf<\/strong>, because in some Linux platform <strong>mysqld_safe<\/strong> will not work.<\/em><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Login into the MySQL with blank password<\/strong><\/p>\n<pre class=\"lang:default decode:true\">mysql&gt; mysql -u root -p<\/pre>\n<p><img decoding=\"async\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/789-1.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Update the root password<\/strong><\/p>\n<pre class=\"lang:default decode:true\">mysql&gt; use mysql;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/935-1.png\" width=\"461\" height=\"68\" \/><\/p>\n<pre class=\"lang:default decode:true\">mysql&gt; update user set password=PASSWORD('new_root_password') where user='root' and host='localhost'; [Before: MySQL 5.7]\r\n\r\n<\/pre>\n<pre class=\"lang:default decode:true\">mysql&gt; update\u00a0user\u00a0set\u00a0authentication_string = PASSWORD('new_root_password'), password_expired = 'N' where\u00a0user = 'root' and\u00a0host = 'localhost';\u00a0\u00a0[ From: MySQL 5.7.+]<\/pre>\n<pre class=\"lang:default decode:true\">mysql&gt; flush privileges;<\/pre>\n<pre class=\"lang:default decode:true \">mysql&gt; \\q<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Stop the MySQL service<\/strong><\/p>\n<pre class=\"lang:default decode:true\"># service mysqld stop\r\n\r\nor\r\n\r\n# \/etc\/init.d\/mysqld stop<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/532.png\" width=\"356\" height=\"31\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>Note :-<\/strong><\/span><em><span style=\"color: #000000;\"> In redhat-7 or Centos-7 use below command to stop the service.<\/span><\/em><\/p>\n<pre class=\"lang:default decode:true\"># systemctl stop mysqld<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/603.png\" width=\"483\" height=\"92\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Start the service again.<\/strong><\/p>\n<p><span style=\"color: #ff0000;\"><strong>Note:-<\/strong><\/span> <em><span style=\"color: #000000;\">If you have put entry of skip-grant-tables into the my.cnf file then first remove this variable, before starting the MySQL service.<\/span><\/em><\/p>\n<pre class=\"lang:default decode:true\"># service mysqld start\r\n\r\nor\r\n\r\n# \/etc\/init.d\/mysqld start<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/396-1.png\" width=\"600\" height=\"98\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>Note :-<\/strong><\/span> <em><span style=\"color: #000000;\">In redhat-7 or Centos-7 use below command to start the service.<\/span><\/em><\/p>\n<pre class=\"lang:default decode:true\"># systemctl start mysqld<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/480.png\" width=\"588\" height=\"97\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Login with the updated password.<\/strong><\/p>\n<pre class=\"lang:default decode:true\"># mysql -u root -p 'new_root_password'<\/pre>\n<p><img decoding=\"async\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/789-1.png\" \/><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_2149\" class=\"pvc_stats all  \" data-element-id=\"2149\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Some time we are facing issue like we forgot the MySQL root password. So here we are providing just some simple steps to reset the MySQL root password. Stop the MySQL service # service mysqld stop or # \/etc\/init.d\/mysqld stop &nbsp; Note :- In Redhat-7 or Centos-7 use below command to stop the service. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_2149\" class=\"pvc_stats all  \" data-element-id=\"2149\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":114,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[7],"tags":[1301,1300,1361,940],"class_list":["post-2149","post","type-post","status-publish","format-standard","","category-mysql","tag-mysql","tag-mysql5-7","tag-mysqld_safe","tag-reset-account-lockout-counter-after"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to reset to MySQL root password - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How to reset to MySQL root password\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to reset to MySQL root password - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How to reset to MySQL root password\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-24T16:25:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-18T20:53:30+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/532.png\" \/>\n<meta name=\"author\" content=\"Rabikumar Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rabikumar Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/\"},\"author\":{\"name\":\"Rabikumar Singh\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/1524185631674ed9ab75aa8ae87bb0d7\"},\"headline\":\"How to reset to MySQL root password\",\"datePublished\":\"2018-08-24T16:25:16+00:00\",\"dateModified\":\"2018-11-18T20:53:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/\"},\"wordCount\":176,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/532.png\",\"keywords\":[\"MySQL\",\"MySQL5.7\",\"mysqld_safe\",\"Reset account lockout counter after\"],\"articleSection\":[\"MySQL-MariaDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/\",\"name\":\"How to reset to MySQL root password - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/532.png\",\"datePublished\":\"2018-08-24T16:25:16+00:00\",\"dateModified\":\"2018-11-18T20:53:30+00:00\",\"description\":\"How to reset to MySQL root password\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#primaryimage\",\"url\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/532.png\",\"contentUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/532.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to reset to MySQL root password\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/1524185631674ed9ab75aa8ae87bb0d7\",\"name\":\"Rabikumar Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/203d6c1d4643b73f5790920242c21a1567d955aee7c832203356242015ccd246?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/203d6c1d4643b73f5790920242c21a1567d955aee7c832203356242015ccd246?s=96&d=mm&r=g\",\"caption\":\"Rabikumar Singh\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/rabikumarsingh\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to reset to MySQL root password - Database Tutorials","description":"How to reset to MySQL root password","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:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/","og_locale":"en_US","og_type":"article","og_title":"How to reset to MySQL root password - Database Tutorials","og_description":"How to reset to MySQL root password","og_url":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/","og_site_name":"Database Tutorials","article_published_time":"2018-08-24T16:25:16+00:00","article_modified_time":"2018-11-18T20:53:30+00:00","og_image":[{"url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/532.png","type":"","width":"","height":""}],"author":"Rabikumar Singh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rabikumar Singh","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/"},"author":{"name":"Rabikumar Singh","@id":"https:\/\/dbtut.com\/#\/schema\/person\/1524185631674ed9ab75aa8ae87bb0d7"},"headline":"How to reset to MySQL root password","datePublished":"2018-08-24T16:25:16+00:00","dateModified":"2018-11-18T20:53:30+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/"},"wordCount":176,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/532.png","keywords":["MySQL","MySQL5.7","mysqld_safe","Reset account lockout counter after"],"articleSection":["MySQL-MariaDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/","url":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/","name":"How to reset to MySQL root password - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/532.png","datePublished":"2018-08-24T16:25:16+00:00","dateModified":"2018-11-18T20:53:30+00:00","description":"How to reset to MySQL root password","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#primaryimage","url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/532.png","contentUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/532.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/24\/how-to-reset-to-mysql-root-password\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How to reset to MySQL root password"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/1524185631674ed9ab75aa8ae87bb0d7","name":"Rabikumar Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/203d6c1d4643b73f5790920242c21a1567d955aee7c832203356242015ccd246?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/203d6c1d4643b73f5790920242c21a1567d955aee7c832203356242015ccd246?s=96&d=mm&r=g","caption":"Rabikumar Singh"},"url":"https:\/\/dbtut.com\/index.php\/author\/rabikumarsingh\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/114"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=2149"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2149\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=2149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=2149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=2149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}