{"id":13523,"date":"2019-11-12T07:09:18","date_gmt":"2019-11-12T07:09:18","guid":{"rendered":"https:\/\/dbtut.com\/?p=13523"},"modified":"2019-11-12T07:09:19","modified_gmt":"2019-11-12T07:09:19","slug":"how-to-reset-mysql-root-password","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/","title":{"rendered":"How To Reset MySQL root Password"},"content":{"rendered":"<p>The MySQL root password allows the root user full access to the MySQL database. If you do not remember the root password of the mysql database, you can reset it as follows.<\/p>\n<p>It is necessary to connect with root in Linux environments and with administrator in windows environments to perform these operations.<\/p>\n<h1>Reset MySQL root Password<\/h1>\n<h2>Step 1: Stop MySQL Service<\/h2>\n<h3>Stop MySQL Server in Ubuntu or Debian:<\/h3>\n<pre class=\"lang:default decode:true \">\/etc\/init.d\/mysql stop<\/pre>\n<h3>Stop MySQL Server in CentOS, Fedora, Red Hat Enterprise Linux or Oracle&nbsp;&nbsp;Enterprise Linux:<\/h3>\n<pre class=\"lang:default decode:true \">\/etc\/init.d\/mysqld stop<\/pre>\n<h2>Step 2:Start MySQL Without Password<\/h2>\n<pre class=\"lang:default decode:true\">mysqld_safe --skip-grant-tables &amp;<\/pre>\n<pre class=\"lang:default decode:true \">mysql -uroot<\/pre>\n<h2>Step 3: Create New MySQL root Password<\/h2>\n<h3>From mysql cli:<\/h3>\n<pre class=\"lang:default decode:true \">use mysql;<\/pre>\n<pre class=\"lang:default decode:true\">update user set password=PASSWORD(\"newpassword\") where User='root';<\/pre>\n<pre class=\"lang:default decode:true \">flush privileges;<\/pre>\n<pre class=\"lang:default decode:true \">quit<\/pre>\n<h2>Step 4: Restart MySQL Service<\/h2>\n<pre class=\"lang:default decode:true \">\/etc\/init.d\/mysql stop<\/pre>\n<pre class=\"lang:default decode:true \">\/etc\/init.d\/mysql start<\/pre>\n<h2>Step 5: Connect To MySQL With New Password<\/h2>\n<pre class=\"lang:default decode:true \">mysql -u root -p<\/pre>\n<p>The sample outputs will be as follows:<\/p>\n<pre class=\"lang:default decode:true \">root@debian:~# \/etc\/init.d\/mysql stop\n[ ok ] Stopping mysql (via systemctl): mysql.service.\nroot@debian:~# mysqld_safe --skip-grant-tables &amp;\n[1] 30091\nroot@debian:~# 180922 22:50:31 mysqld_safe Can't log to error log and syslog at the same time.  Remove all --log-error configuration options for --syslog to take effect.\n180922 22:50:31 mysqld_safe Logging to '\/var\/log\/mysql\/error.log'.\n180922 22:50:31 mysqld_safe Starting mysqld daemon with databases from \/var\/lib\/mysql\n\nroot@debian:~# mysql -uroot\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\nYour MySQL connection id is 1\nServer version: 5.5.55-0+deb8u1 (Debian)\n\nCopyright (c) 2000, 2017, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql&gt; use mysql;\nReading table information for completion of table and column names\nYou can turn off this feature to get a quicker startup with -A\n\nDatabase changed\nmysql&gt; update user set password=PASSWORD(\"yenisifre\") where User='root';\nQuery OK, 0 rows affected (0.00 sec)\nRows matched: 4  Changed: 0  Warnings: 0\n\nmysql&gt; flush privileges;\nQuery OK, 0 rows affected (0.00 sec)\n\nmysql&gt; quit\nBye\nroot@debian:~# \/etc\/init.d\/mysql stop\n[ ok ] Stopping mysql (via systemctl): mysql.service.\nroot@debian:~#  \/etc\/init.d\/mysql start\n[ ok ] Starting mysql (via systemctl): mysql.service.\nroot@debian:~# mysql -u root -p\nEnter password: \nWelcome to the MySQL monitor.  Commands end with ; or \\g.\nYour MySQL connection id is 3\nServer version: 5.5.55-0+deb8u1 (Debian)\n\nCopyright (c) 2000, 2017, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql&gt;<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13523\" class=\"pvc_stats all  \" data-element-id=\"13523\" 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>The MySQL root password allows the root user full access to the MySQL database. If you do not remember the root password of the mysql database, you can reset it as follows. It is necessary to connect with root in Linux environments and with administrator in windows environments to perform these operations. Reset MySQL root &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13523\" class=\"pvc_stats all  \" data-element-id=\"13523\" 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":1,"featured_media":13524,"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":[5444,5460,5458,5452,5455,5450,5437,5438,5445,5441,5443,5439,5449,5447,5448,5446,5435,5456,5436,5451,5459,5453,5454,5457,5440,5442],"class_list":["post-13523","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mysql","tag-can-sudo-change-root-password","tag-connect-to-mysql-with-new-password","tag-connect-to-mysql-with-root-password","tag-create-new-mysql-root-password","tag-fedora","tag-how-can-i-change-mysql-root-password-without-knowing","tag-how-can-i-recover-my-mysql-password","tag-how-do-i-change-the-root-password-in-mysql","tag-how-do-i-find-my-root-password","tag-how-do-i-find-mysql-username-and-password","tag-how-do-i-know-my-mysql-password","tag-how-do-i-reset-my-root-password","tag-how-to-change-mysql-root-password-in-centos","tag-how-to-change-mysql-root-password-in-debian","tag-how-to-change-mysql-root-password-in-ubuntu","tag-how-to-change-root-password-in-ubuntu","tag-how-to-reset-mysql-root-password","tag-red-hat-enterprise-linux-or-oracle-enterprise-linux","tag-reset-a-mysql-root-password","tag-reset-mysql-root-password","tag-restart-mysql-service","tag-start-mysql-without-password","tag-stop-mysql-server-in-centos","tag-stop-mysql-server-in-ubuntu-or-debian","tag-what-do-i-do-if-i-forgot-my-mysql-root-password","tag-what-is-root-password"],"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 MySQL root Password - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Reset 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\/2019\/11\/12\/how-to-reset-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 MySQL root Password - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Reset MySQL root Password\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-12T07:09:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-12T07:09:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-15.png\" \/>\n\t<meta property=\"og:image:width\" content=\"552\" \/>\n\t<meta property=\"og:image:height\" content=\"302\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Reset MySQL root Password\",\"datePublished\":\"2019-11-12T07:09:18+00:00\",\"dateModified\":\"2019-11-12T07:09:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/\"},\"wordCount\":124,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-15.png\",\"keywords\":[\"Can Sudo change root password?\",\"Connect To MySQL With New Password\",\"Connect To MySQL with root password\",\"Create New MySQL root Password\",\"Fedora\",\"How can I change mysql root password without knowing?\",\"How can I recover my MySQL password?\",\"How do I change the root password in MySQL?\",\"How do I find my root password?\",\"How do I find MySQL username and password?\",\"How do I know my MySQL password?\",\"How do I reset my root password?\",\"How to change mysql root password in centos\",\"How to change mysql root password in Debian\",\"How to change mysql root password in ubuntu\",\"How to change root password in Ubuntu\",\"How To Reset MySQL root Password\",\"Red Hat Enterprise Linux or Oracle\u00a0\u00a0Enterprise Linux\",\"Reset a MySQL root Password\",\"Reset MySQL Root Password\",\"Restart MySQL Service\",\"Start MySQL Without Password\",\"Stop MySQL Server in CentOS\",\"Stop MySQL Server in Ubuntu or Debian\",\"What do I do if I forgot my MySQL root password?\",\"What is root password?\"],\"articleSection\":[\"MySQL-MariaDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/\",\"name\":\"How To Reset MySQL root Password - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-15.png\",\"datePublished\":\"2019-11-12T07:09:18+00:00\",\"dateModified\":\"2019-11-12T07:09:19+00:00\",\"description\":\"How To Reset MySQL root Password\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-15.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-15.png\",\"width\":552,\"height\":302},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Reset 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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Reset MySQL root Password - Database Tutorials","description":"How To Reset 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\/2019\/11\/12\/how-to-reset-mysql-root-password\/","og_locale":"en_US","og_type":"article","og_title":"How To Reset MySQL root Password - Database Tutorials","og_description":"How To Reset MySQL root Password","og_url":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/","og_site_name":"Database Tutorials","article_published_time":"2019-11-12T07:09:18+00:00","article_modified_time":"2019-11-12T07:09:19+00:00","og_image":[{"width":552,"height":302,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-15.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Reset MySQL root Password","datePublished":"2019-11-12T07:09:18+00:00","dateModified":"2019-11-12T07:09:19+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/"},"wordCount":124,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-15.png","keywords":["Can Sudo change root password?","Connect To MySQL With New Password","Connect To MySQL with root password","Create New MySQL root Password","Fedora","How can I change mysql root password without knowing?","How can I recover my MySQL password?","How do I change the root password in MySQL?","How do I find my root password?","How do I find MySQL username and password?","How do I know my MySQL password?","How do I reset my root password?","How to change mysql root password in centos","How to change mysql root password in Debian","How to change mysql root password in ubuntu","How to change root password in Ubuntu","How To Reset MySQL root Password","Red Hat Enterprise Linux or Oracle\u00a0\u00a0Enterprise Linux","Reset a MySQL root Password","Reset MySQL Root Password","Restart MySQL Service","Start MySQL Without Password","Stop MySQL Server in CentOS","Stop MySQL Server in Ubuntu or Debian","What do I do if I forgot my MySQL root password?","What is root password?"],"articleSection":["MySQL-MariaDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/","url":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/","name":"How To Reset MySQL root Password - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-15.png","datePublished":"2019-11-12T07:09:18+00:00","dateModified":"2019-11-12T07:09:19+00:00","description":"How To Reset MySQL root Password","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-15.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-15.png","width":552,"height":302},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-reset-mysql-root-password\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Reset 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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13523","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=13523"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13523\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13524"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}