Skip to main content
TopMiniSite

Back to all posts

How to Change the Magento Admin Password from phpMyAdmin?

Published on
4 min read
How to Change the Magento Admin Password from phpMyAdmin? image

Best Magento Security Tools to Buy in March 2026

1 ziyue Hook Security Magnetic Tool for Wall

ziyue Hook Security Magnetic Tool for Wall

  • DURABLE BLACK ABS MAGNET MATERIAL, RUST-RESISTANT FOR LONGEVITY.
  • HASSLE-FREE INSTALLATION: NO DRILLS REQUIRED FOR QUICK SETUP.
  • VERSATILE USE: IDEAL FOR DISPLAYS, CLOSURES, AND GADGET ORGANIZATION.
BUY & SAVE
$13.92 $14.66
Save 5%
ziyue Hook Security Magnetic Tool for Wall
2 ziyue 2 Pack Hook Security Magnetic Tool Key for Wall (2Pack)

ziyue 2 Pack Hook Security Magnetic Tool Key for Wall (2Pack)

  • DURABLE MAGNET IN BLACK ABS: NEVER RUSTS, BUILT TO LAST!

  • HASSLE-FREE INSTALLATION: NO DRILLING NEEDED, SUPER EASY SETUP!

  • VERSATILE USE: PERFECT FOR DISPLAYS, SECURING DOORS, AND ORGANIZING!

BUY & SAVE
$19.64 $20.68
Save 5%
ziyue 2 Pack Hook Security Magnetic Tool Key for Wall (2Pack)
3 XCHTX 2PK Magnetic Key for Anti-Theft Security Slatwall&Peg Hook Magnet Key

XCHTX 2PK Magnetic Key for Anti-Theft Security Slatwall&Peg Hook Magnet Key

  • STRONG MAGNETS PREVENT RETAIL ITEM LOSS WHILE SAVING SPACE!
  • VERSATILE DESIGN FITS VARIOUS SECURITY HOOKS FOR ULTIMATE CONVENIENCE.
  • EASY-TO-USE MECHANISM ENSURES QUICK DISPLAY AND SECURE LOCKING.
BUY & SAVE
$16.68
XCHTX 2PK Magnetic Key for Anti-Theft Security Slatwall&Peg Hook Magnet Key
4 ziyue 4 Pack Hook Security Magnetic Tool Key for Wall, 4 Black

ziyue 4 Pack Hook Security Magnetic Tool Key for Wall, 4 Black

  • DURABLE ABS HOUSING ENSURES LONG-LASTING USE, NEVER RUSTS.
  • HASSLE-FREE INSTALLATION-NO DRILLING REQUIRED FOR EASY SETUP!
  • VERSATILE FOR DISPLAYS, CLOSURES, AND ORGANIZING KEYS/WRENCHES.
BUY & SAVE
$28.49 $29.99
Save 5%
ziyue 4 Pack Hook Security Magnetic Tool Key for Wall, 4 Black
5 MagnetPAL Heavy-Duty Neodymium Anti-Rust Magnet, Magnetic Stud Finder, Hide-A-Key, Tool Holder & Retrieval, Most Powerful Magnet 12lb Pull, Indoor or Outdoor Multi Use Tools, Quick Release Keys Red

MagnetPAL Heavy-Duty Neodymium Anti-Rust Magnet, Magnetic Stud Finder, Hide-A-Key, Tool Holder & Retrieval, Most Powerful Magnet 12lb Pull, Indoor or Outdoor Multi Use Tools, Quick Release Keys Red

  • POWERFUL MAGNET: HOLDS UP TO 12 POUNDS-COMPACT YET MIGHTY!

  • WALL MOUNT SCANNER: PERFECT FOR ACCURATE STUD FINDING WITH EASE.

  • KEY HIDER UNDER CAR: SECURE YOUR KEYS WITH A RUST-FREE, STRONG MAGNET.

BUY & SAVE
$12.99
MagnetPAL Heavy-Duty Neodymium Anti-Rust Magnet, Magnetic Stud Finder, Hide-A-Key, Tool Holder & Retrieval, Most Powerful Magnet 12lb Pull, Indoor or Outdoor Multi Use Tools, Quick Release Keys Red
6 MagnetPAL Heavy-Duty Neodymium Anti-Rust Magnet, Magnetic Stud Finder, Hide-A-Key, Tool Holder & Retrieval, Most Powerful Magnet 12lb Pull, Indoor or Outdoor Multi Use Tools, Quick Release Keys Black

MagnetPAL Heavy-Duty Neodymium Anti-Rust Magnet, Magnetic Stud Finder, Hide-A-Key, Tool Holder & Retrieval, Most Powerful Magnet 12lb Pull, Indoor or Outdoor Multi Use Tools, Quick Release Keys Black

  • UNMATCHED STRENGTH: HOLDS UP TO 12 LBS; THE SMALLEST POWERHOUSE YOU NEED!

  • PRECISION WALL MOUNTING: ENSURE SECURE INSTALLATIONS WITH ACCURATE STUD DETECTION!

  • VERSATILE KEY HIDER: RUST-FREE DESIGN KEEPS YOUR SPARE KEYS SAFE AND ACCESSIBLE!

BUY & SAVE
$12.99
MagnetPAL Heavy-Duty Neodymium Anti-Rust Magnet, Magnetic Stud Finder, Hide-A-Key, Tool Holder & Retrieval, Most Powerful Magnet 12lb Pull, Indoor or Outdoor Multi Use Tools, Quick Release Keys Black
7 MeasuPro Demagnetizer and Magnetizer For Screwdrivers Tips, Bits, and Small Tools, Large or Big Screws, Drills, Drill Bits, Sockets, Nuts, BRed olts, Nails, 3 Pack - Red, Black, and Blue

MeasuPro Demagnetizer and Magnetizer For Screwdrivers Tips, Bits, and Small Tools, Large or Big Screws, Drills, Drill Bits, Sockets, Nuts, BRed olts, Nails, 3 Pack - Red, Black, and Blue

  • VERSATILE 3-IN-1 TOOL: ADJUST MAGNETIC STRENGTH EFFORTLESSLY!
  • COMPATIBLE WITH VARIOUS TOOLS: ESSENTIAL FOR EVERY TOOLKIT!
  • 60-DAY WARRANTY: BUY WITH CONFIDENCE FOR OPTIMAL PERFORMANCE!
BUY & SAVE
$14.99
MeasuPro Demagnetizer and Magnetizer For Screwdrivers Tips, Bits, and Small Tools, Large or Big Screws, Drills, Drill Bits, Sockets, Nuts, BRed olts, Nails, 3 Pack - Red, Black, and Blue
8 SE 30-inch Telescoping Magnetic Pick-Up Tool, Extendable Magnetic Wand Pickup Tool for Mechanics, Household, Office & Industry, Stainless Steel, Black Handle

SE 30-inch Telescoping Magnetic Pick-Up Tool, Extendable Magnetic Wand Pickup Tool for Mechanics, Household, Office & Industry, Stainless Steel, Black Handle

  • POWERFUL 15 LBS MAGNET FOR EASY RETRIEVAL OF LOST METAL ITEMS.

  • ERGONOMIC CUSHION GRIP FOR COMFORT DURING EXTENDED USE.

  • VERSATILE TOOL IDEAL FOR DIYERS, HOMEOWNERS, AND PROFESSIONALS.

BUY & SAVE
$8.25
SE 30-inch Telescoping Magnetic Pick-Up Tool, Extendable Magnetic Wand Pickup Tool for Mechanics, Household, Office & Industry, Stainless Steel, Black Handle
+
ONE MORE?

Magento CMS is a popular content management system (CMS) that is specifically designed for e-commerce websites. It is an open-source platform that offers a wide range of features and flexibility to help merchants build and manage their online stores effectively.

Magento CMS provides a robust and scalable solution for businesses of all sizes. With its powerful architecture, it allows users to create and customize their websites according to their specific requirements. It offers a rich set of features such as inventory management, product catalog management, order management, payment processing, and customer management.

One of the key advantages of Magento CMS is its extensive customization options. Users can easily extend and customize the functionality of their online stores by incorporating various extensions and themes available in the Magento marketplace. This enables merchants to create unique and personalized websites that reflect their brand identity.

Another notable feature of Magento CMS is its strong focus on search engine optimization (SEO). The platform offers various SEO tools and features that help improve the visibility and ranking of online stores in search engine results. This can greatly benefit businesses by attracting more organic traffic and driving higher conversions.

Additionally, Magento CMS offers a responsive design that ensures websites are optimized for different devices and screen sizes. This is crucial in today's mobile-driven world, as it enables businesses to provide a seamless user experience across various platforms.

Furthermore, Magento CMS has robust security measures in place to protect online stores from potential threats and attacks. Regular security updates and patches are released, ensuring that websites stay secure and up-to-date.

Overall, Magento CMS is a comprehensive e-commerce solution that provides merchants with the tools and functionality needed to create and manage successful online stores. Its flexibility, customization options, and SEO-friendly features make it a popular choice among businesses looking to establish a strong online presence.

How to Change the Magento Admin Password using SQL query?

To change the Magento admin password using an SQL query, you can follow these steps:

  • Open your database administration tool (e.g., phpMyAdmin).
  • Select the database associated with your Magento installation.
  • Locate the table named admin_user. It stores the admin users' information.
  • Identify the admin user for whom you want to change the password. Typically, the username is "admin."
  • Execute the following SQL query to update the admin user's password:

UPDATE admin_user SET password = CONCAT(SHA2('xxxxNewPassword', 256), ':xxxx:1') WHERE username = 'admin';

  • Replace the xxxxNewPassword with your desired new password. Make sure to choose a strong password.
  • Save the changes, and close the SQL query or database administration tool.

After executing the SQL query, your Magento admin password should be updated to the new value provided.

How to Change the Magento Admin Password from phpMyAdmin?

To change the Magento admin password from phpMyAdmin, you can follow these steps:

  1. Access your hosting account and open phpMyAdmin.
  2. Locate the Magento database in phpMyAdmin. It is typically named with a prefix followed by "_admin".
  3. Click on the database to view its tables.
  4. From the list of tables, find the one named "admin_user". Click on it to open.
  5. Look for the admin user account you want to change the password for and click on the "Edit" button on the left side of the row.
  6. In the "password" field, select the "MD5" function from the dropdown menu.
  7. Enter the new password in the "Value" field. Make sure to use a strong password and note it down for future reference.
  8. Click on the "Go" or "Save" button to save the changes.

After following these steps, the Magento admin password should be successfully changed in the database. You can now log in to the Magento admin panel using the newly set password.