{"id":7263,"date":"2021-08-11T02:36:32","date_gmt":"2021-08-11T02:36:32","guid":{"rendered":"https:\/\/www.magetop.com\/blog\/?p=7263"},"modified":"2021-08-11T07:44:04","modified_gmt":"2021-08-11T07:44:04","slug":"change-mysql-password-policy-level","status":"publish","type":"post","link":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/","title":{"rendered":"How To Change MySQL Password Policy Level"},"content":{"rendered":"\n<p>In this post, I will guide you on <strong>How To Change MySQL Password Policy Level<\/strong>. MySQL updated the password strength check feature and improved security, but this makes it difficult to use.<\/p>\n\n\n\n<p>The latest MySQL servers come with a password validation plugin. This plugin is validate_password, it will check password strength to improve security for MySQL server.<\/p>\n\n\n\n<p>So when you change your password and your password doesn&#8217;t respond to the validation_password&#8217;s set you will get the error:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ERROR 1819 (HY000): Your password does not satisfy the current policy requirements<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Steps To Change MySQL Password Policy Level<\/h2>\n\n\n\n<p>First, log in to MySQL as root or another user with privileges.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nmysql -u root -p\n<\/pre><\/div>\n\n\n<p>Execute query to see current setting of &#8220;validate_password&#8221; using below command:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSHOW VARIABLES LIKE 'validate_password%';\n<\/pre><\/div>\n\n\n<p>You can see the output like this:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nmysql&gt; SHOW VARIABLES LIKE 'validate_password%';\n+--------------------------------------+--------+\n| Variable_name                        | Value  |\n+--------------------------------------+--------+\n| validate_password_dictionary_file    |        |\n| validate_password_length             | 8      |\n| validate_password_mixed_case_count   | 1      |\n| validate_password_number_count       | 1      |\n| validate_password_policy             | MEDIUM |\n| validate_password_special_char_count | 1      |\n+--------------------------------------+--------+\n6 rows in set (0.01 sec)\n<\/pre><\/div>\n\n\n<p>The default level of the password policy is MEDIUM.<\/p>\n\n\n\n<p>We need to change it to LOW by using the below query:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSET GLOBAL validate_password_policy=LOW;\n<\/pre><\/div>\n\n\n<p>Output:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nmysql&gt; SET GLOBAL validate_password_policy=LOW;\nQuery OK, 0 rows affected (0.02 sec)\n<\/pre><\/div>\n\n\n<p>The LOW level required only the password length to min 8 characters, it will not check for uppercase, numbers, or special characters.<\/p>\n\n\n\n<p>To make this setting, edit MySQL configuration (<code>my.cnf<\/code>) file:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;mysqld]\nvalidate_password_policy=LOW\n<\/pre><\/div>\n\n\n<p>Restart MySQL service to take a change.<\/p>\n\n\n\n<p>Follow us for the more helpful posts!<\/p>\n\n\n\n<p>We hope this is a useful post for you.<\/p>\n\n\n\n<p>You can read more useful posts like&nbsp;<strong><a href=\"https:\/\/www.magetop.com\/blog\/add-terms-and-conditions-checkbox-in-magento-2\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Add Terms And Conditions Checkbox In Magento 2<\/a><\/strong>.<\/p>\n\n\n\n<p>Thank you for reading!<\/p>\n","protected":false},"excerpt":{"rendered":"<p> I will guide you on How To Change MySQL Password Policy Level. MySQL updated the password strength check feature and improved security, but this makes it difficult to use.<\/p>\n","protected":false},"author":106,"featured_media":7266,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2],"tags":[1856,1857,1855],"class_list":["post-7263","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-magento-2-tutorials","tag-change-mysql-password-policy-level","tag-how-to-change-mysql-password-policy-level","tag-mysql-password-policy-level"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Change MySQL Password Policy Level - Magetop Blog<\/title>\n<meta name=\"description\" content=\"In this post, I will guide you on How To Change MySQL Password Policy Level. MySQL updated the password strength check feature...\" \/>\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.magetop.com\/blog\/change-mysql-password-policy-level\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Change MySQL Password Policy Level - Magetop Blog\" \/>\n<meta property=\"og:description\" content=\"In this post, I will guide you on How To Change MySQL Password Policy Level. MySQL updated the password strength check feature...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/\" \/>\n<meta property=\"og:site_name\" content=\"Magetop Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/MagetopStore\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-11T02:36:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-11T07:44:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i1.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-MySQL-Password-Policy-Level.png?fit=748%2C438&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"748\" \/>\n\t<meta property=\"og:image:height\" content=\"438\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Aaron LX\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@MagetopStore\" \/>\n<meta name=\"twitter:site\" content=\"@MagetopStore\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aaron LX\" \/>\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.magetop.com\/blog\/change-mysql-password-policy-level\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/\"},\"author\":{\"name\":\"Aaron LX\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/b8770690a02cc53a273d6b7205229ff7\"},\"headline\":\"How To Change MySQL Password Policy Level\",\"datePublished\":\"2021-08-11T02:36:32+00:00\",\"dateModified\":\"2021-08-11T07:44:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/\"},\"wordCount\":219,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-MySQL-Password-Policy-Level.png?fit=748%2C438&ssl=1\",\"keywords\":[\"Change MySQL Password Policy Level\",\"How To Change MySQL Password Policy Level\",\"MySQL Password Policy Level\"],\"articleSection\":[\"Magento 2 Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/\",\"url\":\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/\",\"name\":\"How To Change MySQL Password Policy Level - Magetop Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-MySQL-Password-Policy-Level.png?fit=748%2C438&ssl=1\",\"datePublished\":\"2021-08-11T02:36:32+00:00\",\"dateModified\":\"2021-08-11T07:44:04+00:00\",\"description\":\"In this post, I will guide you on How To Change MySQL Password Policy Level. MySQL updated the password strength check feature...\",\"breadcrumb\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-MySQL-Password-Policy-Level.png?fit=748%2C438&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-MySQL-Password-Policy-Level.png?fit=748%2C438&ssl=1\",\"width\":748,\"height\":438,\"caption\":\"How To Change MySQL Password Policy Level\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.magetop.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Change MySQL Password Policy Level\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#website\",\"url\":\"https:\/\/www.magetop.com\/blog\/\",\"name\":\"Magetop Blog\",\"description\":\"Exploring Magento Tips, Tricks, and Trends\",\"publisher\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.magetop.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#organization\",\"name\":\"Magetop.com\",\"url\":\"https:\/\/www.magetop.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1\",\"width\":475,\"height\":475,\"caption\":\"Magetop.com\"},\"image\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/MagetopStore\",\"https:\/\/x.com\/MagetopStore\",\"https:\/\/www.linkedin.com\/company\/magetop\",\"https:\/\/www.pinterest.com\/magetop\",\"https:\/\/www.youtube.com\/channel\/UCXoiJsz88OfPmwa8QpUkwOA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/b8770690a02cc53a273d6b7205229ff7\",\"name\":\"Aaron LX\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/11\/475315059_122137709240563546_260104055231757176_n.jpg?fit=96%2C96&#038;ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/11\/475315059_122137709240563546_260104055231757176_n.jpg?fit=96%2C96&#038;ssl=1\",\"caption\":\"Aaron LX\"},\"description\":\"Aaron is a passionate writer, crazy about shopping, eCommerce and trends. Besides his outstanding research skills and a positive mind, Aaron eagerly shares his experience with the readers.\",\"url\":\"https:\/\/www.magetop.com\/blog\/author\/aaron-lx\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Change MySQL Password Policy Level - Magetop Blog","description":"In this post, I will guide you on How To Change MySQL Password Policy Level. MySQL updated the password strength check feature...","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.magetop.com\/blog\/change-mysql-password-policy-level\/","og_locale":"en_US","og_type":"article","og_title":"How To Change MySQL Password Policy Level - Magetop Blog","og_description":"In this post, I will guide you on How To Change MySQL Password Policy Level. MySQL updated the password strength check feature...","og_url":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/","og_site_name":"Magetop Blog","article_publisher":"https:\/\/www.facebook.com\/MagetopStore","article_published_time":"2021-08-11T02:36:32+00:00","article_modified_time":"2021-08-11T07:44:04+00:00","og_image":[{"width":748,"height":438,"url":"https:\/\/i1.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-MySQL-Password-Policy-Level.png?fit=748%2C438&ssl=1","type":"image\/png"}],"author":"Aaron LX","twitter_card":"summary_large_image","twitter_creator":"@MagetopStore","twitter_site":"@MagetopStore","twitter_misc":{"Written by":"Aaron LX","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#article","isPartOf":{"@id":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/"},"author":{"name":"Aaron LX","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/b8770690a02cc53a273d6b7205229ff7"},"headline":"How To Change MySQL Password Policy Level","datePublished":"2021-08-11T02:36:32+00:00","dateModified":"2021-08-11T07:44:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/"},"wordCount":219,"commentCount":1,"publisher":{"@id":"https:\/\/www.magetop.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-MySQL-Password-Policy-Level.png?fit=748%2C438&ssl=1","keywords":["Change MySQL Password Policy Level","How To Change MySQL Password Policy Level","MySQL Password Policy Level"],"articleSection":["Magento 2 Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/","url":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/","name":"How To Change MySQL Password Policy Level - Magetop Blog","isPartOf":{"@id":"https:\/\/www.magetop.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#primaryimage"},"image":{"@id":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-MySQL-Password-Policy-Level.png?fit=748%2C438&ssl=1","datePublished":"2021-08-11T02:36:32+00:00","dateModified":"2021-08-11T07:44:04+00:00","description":"In this post, I will guide you on How To Change MySQL Password Policy Level. MySQL updated the password strength check feature...","breadcrumb":{"@id":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#primaryimage","url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-MySQL-Password-Policy-Level.png?fit=748%2C438&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-MySQL-Password-Policy-Level.png?fit=748%2C438&ssl=1","width":748,"height":438,"caption":"How To Change MySQL Password Policy Level"},{"@type":"BreadcrumbList","@id":"https:\/\/www.magetop.com\/blog\/change-mysql-password-policy-level\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.magetop.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How To Change MySQL Password Policy Level"}]},{"@type":"WebSite","@id":"https:\/\/www.magetop.com\/blog\/#website","url":"https:\/\/www.magetop.com\/blog\/","name":"Magetop Blog","description":"Exploring Magento Tips, Tricks, and Trends","publisher":{"@id":"https:\/\/www.magetop.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.magetop.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.magetop.com\/blog\/#organization","name":"Magetop.com","url":"https:\/\/www.magetop.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1","width":475,"height":475,"caption":"Magetop.com"},"image":{"@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/MagetopStore","https:\/\/x.com\/MagetopStore","https:\/\/www.linkedin.com\/company\/magetop","https:\/\/www.pinterest.com\/magetop","https:\/\/www.youtube.com\/channel\/UCXoiJsz88OfPmwa8QpUkwOA"]},{"@type":"Person","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/b8770690a02cc53a273d6b7205229ff7","name":"Aaron LX","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/11\/475315059_122137709240563546_260104055231757176_n.jpg?fit=96%2C96&#038;ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/11\/475315059_122137709240563546_260104055231757176_n.jpg?fit=96%2C96&#038;ssl=1","caption":"Aaron LX"},"description":"Aaron is a passionate writer, crazy about shopping, eCommerce and trends. Besides his outstanding research skills and a positive mind, Aaron eagerly shares his experience with the readers.","url":"https:\/\/www.magetop.com\/blog\/author\/aaron-lx\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-MySQL-Password-Policy-Level.png?fit=748%2C438&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/paOdw5-1T9","jetpack-related-posts":[{"id":9819,"url":"https:\/\/www.magetop.com\/blog\/how-to-install-phpmyadmin-on-ubuntu\/","url_meta":{"origin":7263,"position":0},"title":"How To Install phpMyAdmin On Ubuntu","author":"Aaron LX","date":"February 11, 2025","format":false,"excerpt":"phpMyAdmin is a free, open-source tool used to manage MySQL and MariaDB databases through a web-based interface. Written in PHP, it allows users to perform a wide range of database operations, including creating, modifying, and deleting databases, tables, and records. Please follow the post\u00a0How To Install phpMyAdmin On Ubuntu to\u2026","rel":"","context":"In &quot;Magento 2 Tutorials&quot;","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"How To Install phpMyAdmin On Ubuntu","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/02\/How-To-Install-phpMyAdmin-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/02\/How-To-Install-phpMyAdmin-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/02\/How-To-Install-phpMyAdmin-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/02\/How-To-Install-phpMyAdmin-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/02\/How-To-Install-phpMyAdmin-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7273,"url":"https:\/\/www.magetop.com\/blog\/change-database-name-in-magento-2\/","url_meta":{"origin":7263,"position":1},"title":"How To Change Database Name In Magento 2","author":"Aaron LX","date":"August 11, 2021","format":false,"excerpt":"In this post, I will guide you on How To Change Database Name In Magento 2. The env file contains information about the database like dbname, username, and password, and you can change them to work with the MySQL server.","rel":"","context":"In &quot;Magento 2 Tutorials&quot;","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"How To Change Database Name In Magento 2","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-Database-Name-In-Magento-2.png?fit=1063%2C631&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-Database-Name-In-Magento-2.png?fit=1063%2C631&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-Database-Name-In-Magento-2.png?fit=1063%2C631&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-Database-Name-In-Magento-2.png?fit=1063%2C631&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-Database-Name-In-Magento-2.png?fit=1063%2C631&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":5476,"url":"https:\/\/www.magetop.com\/blog\/install-magento-2-4-7-on-ubuntu\/","url_meta":{"origin":7263,"position":2},"title":"How To Install Magento 2.4.7 On Ubuntu","author":"Aaron LX","date":"May 14, 2021","format":false,"excerpt":"Magento 2.4.7 has been released with hundreds of quality fixes and enhancements, enhancing GraphQL coverage for custom attributes and resolver caches. Please follow the post\u00a0How To Install Magento 2.4.7 On Ubuntu to install it successfully.","rel":"","context":"In &quot;Magento 2 Tutorials&quot;","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"How To Install Magento 2.4.7 On Ubuntu","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Install-Magento-2.4.7-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Install-Magento-2.4.7-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Install-Magento-2.4.7-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Install-Magento-2.4.7-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Install-Magento-2.4.7-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":5605,"url":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/","url_meta":{"origin":7263,"position":3},"title":"How To Import And Export Database In MySQL Or MariaDB","author":"Aaron LX","date":"June 24, 2021","format":false,"excerpt":"In this post, I will guide you on\u00a0How To Import And Export Database In MySQL Or MariaDB. Use data dumps to back up and restore your information.","rel":"","context":"In &quot;Magento 2 Tutorials&quot;","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"How To Import And Export Database In MySQL Or MariaDB","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1200%2C711&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1200%2C711&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1200%2C711&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1200%2C711&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1200%2C711&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":10049,"url":"https:\/\/www.magetop.com\/blog\/how-to-install-mariadb-on-ubuntu\/","url_meta":{"origin":7263,"position":4},"title":"How To Install MariaDB On Ubuntu","author":"Aaron LX","date":"April 3, 2025","format":false,"excerpt":"MariaDB is a popular, open-source relational database management system that is a fork of MySQL. It is highly performant, secure, and compatible with most MySQL tools. In this guide, we will walk you through How To Install MariaDB On Ubuntu step by step. Steps To Install MariaDB On Ubuntu 1.\u2026","rel":"","context":"In &quot;Magento 2 Tutorials&quot;","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/04\/How-To-Install-MariaDB-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/04\/How-To-Install-MariaDB-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/04\/How-To-Install-MariaDB-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/04\/How-To-Install-MariaDB-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/04\/How-To-Install-MariaDB-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7256,"url":"https:\/\/www.magetop.com\/blog\/huong-dan-export-database-mysql\/","url_meta":{"origin":7263,"position":5},"title":"H\u01b0\u1edbng d\u1eabn Export Database Mysql, t\u1ea1o file backup Database Mysql","author":"Callula Huy","date":"August 10, 2021","format":false,"excerpt":"Trong b\u00e0i vi\u1ebft n\u00e0y m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch Export Database Mysql, c\u0169ng c\u00f3 th\u1ec3 g\u1ecdi l\u00e0 t\u1ea1o file backup Database Mysql.","rel":"","context":"In &quot;Magento 2 H\u01b0\u1edbng D\u1eabn Ti\u1ebfng Vi\u1ec7t&quot;","block_context":{"text":"Magento 2 H\u01b0\u1edbng D\u1eabn Ti\u1ebfng Vi\u1ec7t","link":"https:\/\/www.magetop.com\/blog\/vn\/"},"img":{"alt_text":"H\u01b0\u1edbng d\u1eabn Export Database Mysql","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/Huong-dan-Export-Database-Mysql.jpg?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/Huong-dan-Export-Database-Mysql.jpg?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/Huong-dan-Export-Database-Mysql.jpg?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/Huong-dan-Export-Database-Mysql.jpg?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/Huong-dan-Export-Database-Mysql.jpg?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts\/7263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/users\/106"}],"replies":[{"embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/comments?post=7263"}],"version-history":[{"count":4,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts\/7263\/revisions"}],"predecessor-version":[{"id":7272,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts\/7263\/revisions\/7272"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/media\/7266"}],"wp:attachment":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/media?parent=7263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/categories?post=7263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/tags?post=7263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}