{"id":6092,"date":"2023-02-19T12:50:20","date_gmt":"2023-02-19T07:20:20","guid":{"rendered":"https:\/\/trysiteprice.com\/blog\/?p=6092"},"modified":"2024-08-27T16:50:59","modified_gmt":"2024-08-27T11:20:59","slug":"lost-mysql-admin-password","status":"publish","type":"post","link":"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/","title":{"rendered":"Lost MySQL Admin Password"},"content":{"rendered":"

If you’ve lost the MySQL admin password, you can reset it by following these steps:<\/p>\n

    \n
  1. Stop the MySQL server:\n
    \n
    sudo systemctl stop<\/span> mysql
    \n<\/code><\/div>\n<\/div>\n<\/li>\n
  2. Start the MySQL server with the --skip-grant-tables<\/code> option to skip the permission check:\n
    \n
    sudo mysqld_safe --skip-grant-tables<\/span> &
    \n<\/code><\/div>\n<\/div>\n<\/li>\n
  3. Connect to the MySQL server as the root user without a password:\n
    \n
    mysql -u root
    \n<\/code><\/div>\n<\/div>\n<\/li>\n
  4. Set a new password for the root user by running the following SQL command:\n
    \n
    FLUSH PRIVILEGES;
    \nALTER<\/span> USER<\/span> 'root'<\/span>@'localhost'<\/span> IDENTIFIED BY<\/span> 'new_password'<\/span>;
    \n<\/code><\/div>\n<\/div>\n

    Replace “new_password” with your new desired password.<\/li>\n

  5. Exit the MySQL client and stop the MySQL server:\n
    \n
    exit<\/span>
    \nsudo systemctl stop<\/span> mysql
    \n<\/code><\/div>\n<\/div>\n<\/li>\n
  6. Start the MySQL server normally:\n
    \n
    sudo systemctl start<\/span> mysql
    \n<\/code><\/div>\n<\/div>\n<\/li>\n<\/ol>\n

    You should now be able to connect to the MySQL server using the new password. Keep in mind that this process can be slightly different depending on your version of MySQL and your operating system.<\/p>\n

    By ottomax<\/a> taking on healthy behaviors, you can properly decrease your cholesterol as well as decrease your risk of heart disease.<\/p>\n","protected":false},"excerpt":{"rendered":"

    If you’ve lost the MySQL admin password, you can reset it by following these steps: Stop the MySQL server: sudo systemctl stop mysql Start the MySQL server with the –skip-grant-tables option to skip the permission check: sudo mysqld_safe –skip-grant-tables & Connect to the MySQL server as the root user without a password: mysql -u root … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6092","post","type-post","status-publish","format-standard","hentry","category-best-tutorial"],"yoast_head":"\nLost MySQL Admin Password - TrySitePrice<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Lost MySQL Admin Password - TrySitePrice\" \/>\n<meta property=\"og:description\" content=\"If you’ve lost the MySQL admin password, you can reset it by following these steps: Stop the MySQL server: sudo systemctl stop mysql Start the MySQL server with the --skip-grant-tables option to skip the permission check: sudo mysqld_safe --skip-grant-tables & Connect to the MySQL server as the root user without a password: mysql -u root ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/\" \/>\n<meta property=\"og:site_name\" content=\"TrySitePrice\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-19T07:20:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-27T11:20:59+00:00\" \/>\n<meta name=\"author\" content=\"Rahul Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/\"},\"author\":{\"name\":\"Rahul Sahu\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4\"},\"headline\":\"Lost MySQL Admin Password\",\"datePublished\":\"2023-02-19T07:20:20+00:00\",\"dateModified\":\"2024-08-27T11:20:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/\"},\"wordCount\":139,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\"},\"articleSection\":[\"Best\/Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/\",\"url\":\"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/\",\"name\":\"Lost MySQL Admin Password - TrySitePrice\",\"isPartOf\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#website\"},\"datePublished\":\"2023-02-19T07:20:20+00:00\",\"dateModified\":\"2024-08-27T11:20:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/trysiteprice.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Lost MySQL Admin Password\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#website\",\"url\":\"https:\/\/trysiteprice.com\/blog\/\",\"name\":\"TrySitePrice\",\"description\":\"Free Website Value Calculator Tool\",\"publisher\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/trysiteprice.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\",\"name\":\"TrySitePrice\",\"url\":\"https:\/\/trysiteprice.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png\",\"contentUrl\":\"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png\",\"width\":395,\"height\":268,\"caption\":\"TrySitePrice\"},\"image\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4\",\"name\":\"Rahul Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g\",\"caption\":\"Rahul Sahu\"},\"sameAs\":[\"https:\/\/trysiteprice.com\/blog\"],\"url\":\"https:\/\/trysiteprice.com\/blog\/author\/rsahu4242_trysiteprice\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Lost MySQL Admin Password - TrySitePrice","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:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/","og_locale":"en_US","og_type":"article","og_title":"Lost MySQL Admin Password - TrySitePrice","og_description":"If you’ve lost the MySQL admin password, you can reset it by following these steps: Stop the MySQL server: sudo systemctl stop mysql Start the MySQL server with the --skip-grant-tables option to skip the permission check: sudo mysqld_safe --skip-grant-tables & Connect to the MySQL server as the root user without a password: mysql -u root ... Read more","og_url":"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/","og_site_name":"TrySitePrice","article_published_time":"2023-02-19T07:20:20+00:00","article_modified_time":"2024-08-27T11:20:59+00:00","author":"Rahul Sahu","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/#article","isPartOf":{"@id":"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/"},"author":{"name":"Rahul Sahu","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4"},"headline":"Lost MySQL Admin Password","datePublished":"2023-02-19T07:20:20+00:00","dateModified":"2024-08-27T11:20:59+00:00","mainEntityOfPage":{"@id":"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/"},"wordCount":139,"commentCount":0,"publisher":{"@id":"https:\/\/trysiteprice.com\/blog\/#organization"},"articleSection":["Best\/Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/","url":"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/","name":"Lost MySQL Admin Password - TrySitePrice","isPartOf":{"@id":"https:\/\/trysiteprice.com\/blog\/#website"},"datePublished":"2023-02-19T07:20:20+00:00","dateModified":"2024-08-27T11:20:59+00:00","breadcrumb":{"@id":"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/trysiteprice.com\/blog\/lost-mysql-admin-password\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/trysiteprice.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Lost MySQL Admin Password"}]},{"@type":"WebSite","@id":"https:\/\/trysiteprice.com\/blog\/#website","url":"https:\/\/trysiteprice.com\/blog\/","name":"TrySitePrice","description":"Free Website Value Calculator Tool","publisher":{"@id":"https:\/\/trysiteprice.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/trysiteprice.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/trysiteprice.com\/blog\/#organization","name":"TrySitePrice","url":"https:\/\/trysiteprice.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png","contentUrl":"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png","width":395,"height":268,"caption":"TrySitePrice"},"image":{"@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4","name":"Rahul Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g","caption":"Rahul Sahu"},"sameAs":["https:\/\/trysiteprice.com\/blog"],"url":"https:\/\/trysiteprice.com\/blog\/author\/rsahu4242_trysiteprice\/"}]}},"_links":{"self":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/6092","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/comments?post=6092"}],"version-history":[{"count":2,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/6092\/revisions"}],"predecessor-version":[{"id":7848,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/6092\/revisions\/7848"}],"wp:attachment":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/media?parent=6092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/categories?post=6092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/tags?post=6092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}