{"id":2534,"date":"2013-11-09T14:05:38","date_gmt":"2013-11-09T20:05:38","guid":{"rendered":"https:\/\/secure.rosehosting.com\/blog\/?p=2534"},"modified":"2022-06-03T03:47:17","modified_gmt":"2022-06-03T08:47:17","slug":"how-to-reset-your-mariadb-root-password","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/","title":{"rendered":"How to Reset MariaDB Root Password"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"size-full wp-image-24140 alignnone\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password.png\" alt=\"How to Reset MariaDB Root Password\" width=\"1200\" height=\"600\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password.png 1200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-150x75.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-300x150.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-768x384.png 768w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-1024x512.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-860x430.png 860w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-680x340.png 680w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-500x250.png 500w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-400x200.png 400w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-200x100.png 200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-50x25.png 50w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<p>We&#8217;ll show you, how to reset MariaDB root password. \u00a0Did you forget your MariaDB root password? Do not worry, there is an easy way to reset your password on MariaDB in less than 5 minutes. Please note that you need to have root access to your server to be able to change the password of MariaDB.\u00a0Resetting your MariaDB root password on your Linux server\u00a0is an easy task if you carefully follow our tutorial below.<\/p>\n<p><!--more--><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69cce08ee438f\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69cce08ee438f\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#1-Login-to-your-server-via-SSH\" >1. Login to your server via SSH<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#2-Start-MariaDB-in-Safe-Mode\" >2. Start MariaDB in Safe Mode<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#3-Login-to-MariaDB\" >3. Login to MariaDB<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#4-Reset-MariaDB-Root-Password\" >4. Reset MariaDB Root Password<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#5-Flush-privileges\" >5. Flush privileges<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#6-Restart-MariaDB\" >6. Restart MariaDB<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"1-Login-to-your-server-via-SSH\"><\/span>1. Login to your server via SSH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Log in to your Linux virtual server via SSH as user root and stop the running MariaDB daemon:<\/p>\n<pre class=\"brush: shell; gutter: false\"># service mysql stop\r\nShutting down MySQL. SUCCESS!<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"2-Start-MariaDB-in-Safe-Mode\"><\/span>2. Start MariaDB in Safe Mode<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Start MariaDB in safe mode with &#8216;skip-grant-tables&#8217; option. Grant tables store the passwords, so using this option you can login to MariaDB without password:<\/p>\n<pre class=\"brush: shell; gutter: false\"># mysqld_safe --skip-grant-tables &amp;\r\n[1] 14721\r\n\r\n131108 19:06:41 mysqld_safe Logging to '\/var\/lib\/mysql\/domain.com.err'.\r\n131108 19:06:41 mysqld_safe Starting mysqld daemon with databases from \/var\/lib\/mysql<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"3-Login-to-MariaDB\"><\/span>3. Login to MariaDB<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now, you are able to log in to MariaDB without a password:<\/p>\n<pre class=\"brush: shell; gutter: false\"># mysql -u root\r\nWelcome to the MariaDB monitor.\u00a0 Commands end with ; or \\g.\r\nYour MariaDB connection id is 1\r\nServer version: 5.5.33a-MariaDB MariaDB Server\r\n\r\nCopyright (c) 2000, 2013, Oracle, Monty Program Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\nMariaDB &gt;<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"4-Reset-MariaDB-Root-Password\"><\/span>4. Reset MariaDB Root Password<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Once you are logged in, you can reset your MariaDB root password by executing the following SQL commands:<\/p>\n<pre class=\"brush: shell; gutter: false\">MariaDB [(none)]&gt; use mysql;\r\nMariaDB [(none)]&gt; update user set password=PASSWORD(\"NEWPASSWORD\") where User='root';<\/pre>\n<p>Don&#8217;t forget to replace &#8216;NEWPASSWORD&#8217; with your actual password.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"5-Flush-privileges\"><\/span>5. Flush privileges<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now, flush the privileges and exit from the <a href=\"https:\/\/www.rosehosting.com\/mariadb-hosting.html\">MariaDB server:<\/a><\/p>\n<pre class=\"brush: shell; gutter: false\">MariaDB &gt; flush privileges;\r\nQuery OK, 0 rows affected (0.00 sec) \r\nMariaDB [(none)]&gt; exit; \r\nBye<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"6-Restart-MariaDB\"><\/span>6. Restart MariaDB<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Finally, restart your MariaDB server:<\/p>\n<pre class=\"brush: shell; gutter: false\"># service mysql restart<\/pre>\n<p>Done. Your old MariaDB root password is changed and you have a new password.<\/p>\n<p>Now you can log in to MariaDB using the new password:<\/p>\n<pre class=\"brush: shell; gutter: false\"># mysql -u root -p<\/pre>\n<p><img decoding=\"async\" class=\"alignright size-medium wp-image-25215\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-1-300x259.png\" alt=\"Reset MariaDB Root Password\" width=\"300\" height=\"259\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-1.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-1-150x130.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-1-200x173.png 200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password-1-50x43.png 50w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>If you use one of our <a href=\"https:\/\/www.rosehosting.com\/mariadb-hosting.html\">MariaDB Optimized Hosting<\/a>, you don\u2019t have to reset your MariaDB root password, simply ask our admins, sit back and relax. Our admins will reset MariaDB root password for you immediately.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PS<\/strong><\/span>. If you liked this, on how to reset MariaDB root password, post please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We&#8217;ll show you, how to reset MariaDB root password. \u00a0Did you forget your MariaDB root password? Do not worry, there &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Reset MariaDB Root Password\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#more-2534\" aria-label=\"Read more about How to Reset MariaDB Root Password\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":24140,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,1703,13],"tags":[41,297,177,296,32,327,326,1152],"class_list":["post-2534","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-security","category-tutorials","tag-database","tag-how-to","tag-linux-vps","tag-mariadb","tag-password","tag-reset","tag-root","tag-rosehosting","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Reset MariaDB Root Password<\/title>\n<meta name=\"description\" content=\"We will show you How to Reset MariaDB Root Password. Resetting your MariaDB root password\u00a0is an easy task if you carefully follow our step-by-step guide below.\" \/>\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.rosehosting.com\/blog\/how-to-reset-your-mariadb-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 MariaDB Root Password\" \/>\n<meta property=\"og:description\" content=\"How to Reset MariaDB Root Password | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2013-11-09T20:05:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:47:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\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:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Reset MariaDB Root Password\",\"datePublished\":\"2013-11-09T20:05:38+00:00\",\"dateModified\":\"2022-06-03T08:47:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/\"},\"wordCount\":299,\"commentCount\":13,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/11\\\/How-to-Reset-MariaDB-Root-Password.png\",\"keywords\":[\"database\",\"how-to\",\"linux vps\",\"mariadb\",\"Password\",\"reset\",\"root\",\"rosehosting\"],\"articleSection\":[\"Databases\",\"Security\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/\",\"name\":\"How to Reset MariaDB Root Password\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/11\\\/How-to-Reset-MariaDB-Root-Password.png\",\"datePublished\":\"2013-11-09T20:05:38+00:00\",\"dateModified\":\"2022-06-03T08:47:17+00:00\",\"description\":\"We will show you How to Reset MariaDB Root Password. Resetting your MariaDB root password\u00a0is an easy task if you carefully follow our step-by-step guide below.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/11\\\/How-to-Reset-MariaDB-Root-Password.png\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/11\\\/How-to-Reset-MariaDB-Root-Password.png\",\"width\":1200,\"height\":600,\"caption\":\"How to Reset MariaDB Root Password\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-reset-your-mariadb-root-password\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Reset MariaDB Root Password\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/RoseHosting\",\"https:\\\/\\\/x.com\\\/rosehosting\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/rosehosting\\\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\\\/\\\/www.rosehosting.com\",\"https:\\\/\\\/www.facebook.com\\\/rosehosting.helpdesk\"],\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/author\\\/jwilson\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Reset MariaDB Root Password","description":"We will show you How to Reset MariaDB Root Password. Resetting your MariaDB root password\u00a0is an easy task if you carefully follow our step-by-step guide below.","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.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/","og_locale":"en_US","og_type":"article","og_title":"How to Reset MariaDB Root Password","og_description":"How to Reset MariaDB Root Password | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2013-11-09T20:05:38+00:00","article_modified_time":"2022-06-03T08:47:17+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password.png","type":"image\/png"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Reset MariaDB Root Password","datePublished":"2013-11-09T20:05:38+00:00","dateModified":"2022-06-03T08:47:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/"},"wordCount":299,"commentCount":13,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password.png","keywords":["database","how-to","linux vps","mariadb","Password","reset","root","rosehosting"],"articleSection":["Databases","Security","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/","name":"How to Reset MariaDB Root Password","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password.png","datePublished":"2013-11-09T20:05:38+00:00","dateModified":"2022-06-03T08:47:17+00:00","description":"We will show you How to Reset MariaDB Root Password. Resetting your MariaDB root password\u00a0is an easy task if you carefully follow our step-by-step guide below.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2013\/11\/How-to-Reset-MariaDB-Root-Password.png","width":1200,"height":600,"caption":"How to Reset MariaDB Root Password"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-reset-your-mariadb-root-password\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Reset MariaDB Root Password"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/2534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=2534"}],"version-history":[{"count":1,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/2534\/revisions"}],"predecessor-version":[{"id":42273,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/2534\/revisions\/42273"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/24140"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=2534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=2534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=2534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}