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 February 2026

1 ziyue Hook Security Magnetic Tool for Wall

ziyue Hook Security Magnetic Tool for Wall

  • PREMIUM ABS MATERIAL ENSURES DURABILITY AND RUST RESISTANCE.
  • NO-DRILL INSTALLATION MAKES SETUP QUICK AND EASY.
  • VERSATILE USE FOR HOME, OFFICE, OR WORKSHOP APPLICATIONS.
BUY & SAVE
Save 7%
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 BLACK ABS HOUSING: PREMIUM, RUST-RESISTANT MATERIAL.
  • EFFORTLESS INSTALLATION: NO DRILLING REQUIRED FOR QUICK SETUP.
  • VERSATILE USE: PERFECT FOR DISPLAYING ITEMS AND KEEPING DOORS CLOSED.
BUY & SAVE
Save 6%
ziyue 2 Pack Hook Security Magnetic Tool Key for Wall (2Pack)
3 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 DESIGN: HIGH-QUALITY MATERIALS ENSURE LONG-LASTING USE.
  • HASSLE-FREE INSTALLATION: NO DRILLING REQUIRED FOR QUICK SETUP.
  • VERSATILE USE: PERFECT FOR ORGANIZING AND DISPLAYING VARIOUS ITEMS.
BUY & SAVE
Save 6%
ziyue 4 Pack Hook Security Magnetic Tool Key for Wall, 4 Black
4 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

  • SPACE-SAVING DESIGN: DISPLAY YOUR ITEMS WHILE DECLUTTERING!

  • VERSATILE SECURITY: COMPATIBLE WITH VARIOUS PEG & SLAT WALL HOOKS.

  • SMART UNLOCK FEATURE: EASILY ACCESS ITEMS WITH A SIMPLE SLIDE ACTION.

BUY & SAVE
XCHTX 2PK Magnetic Key for Anti-Theft Security Slatwall&Peg Hook Magnet Key
5 Katzco Precision Demagnetizer-Magnetizer - Pack of 3 Colors - Black, Red, Blue - for Screwdrivers, Small Tools, Small, Big Screws, Drills, Drill Bits, Sockets, Nuts, Bolts, Nails, Construction Tools

Katzco Precision Demagnetizer-Magnetizer - Pack of 3 Colors - Black, Red, Blue - for Screwdrivers, Small Tools, Small, Big Screws, Drills, Drill Bits, Sockets, Nuts, Bolts, Nails, Construction Tools

  • HASSLE-FREE TOOL MAGNETIZATION-NO BATTERIES REQUIRED!
  • COMPACT & LIGHTWEIGHT-EASILY FITS IN ANY TOOLBOX!
  • VERSATILE FOR ALL TOOLS-PERFECT FOR DIYERS AND PROFESSIONALS!
BUY & SAVE
Katzco Precision Demagnetizer-Magnetizer - Pack of 3 Colors - Black, Red, Blue - for Screwdrivers, Small Tools, Small, Big Screws, Drills, Drill Bits, Sockets, Nuts, Bolts, Nails, Construction Tools
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 POUNDS-PERFECT FOR ANY JOB!
  • PRECISION MOUNTING: FIND STUDS EASILY-SECURELY HANG YOUR TV!
  • SECURE KEY HIDING: RUST-FREE DESIGN FOR WORRY-FREE CAR KEY STORAGE!
BUY & SAVE
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 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

  • HOLD UP TO 12 LBS: POWERFUL, COMPACT DESIGN FOR VERSATILE USE.
  • PRECISION WALL MOUNTING: EASILY LOCATE STUDS FOR SECURE INSTALLATIONS.
  • KEY HIDER SECURITY: ATTACH UNDER YOUR CAR TO PREVENT LOCKOUTS.
BUY & SAVE
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
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 PULL CAPACITY FOR EFFORTLESS METAL RETRIEVAL!

  • ERGONOMIC CUSHION GRIP FOR COMFORTABLE, EXTENDED USE!

  • VERSATILE TOOL FOR DIY, HOME, AND PROFESSIONAL APPLICATIONS!

BUY & SAVE
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.