How to import and export admin users on Magento 2?

Rafael Corrêa Gomes

I work at LeSite as Technology Director, where I’m responsible for lead the technical team to building innovative products.

My passion for building software and sharing knowledge brought me to speak in over 14 conferences and create 21 projects used for more than 20,000 developers in the world. Now, I’m focused on helping merchants bringing innovation and technology strategy to their e-commerce ecosystem using the Magento 2, Adobe Commerce, Shopify Plus and other platforms.

Escrevo sobre desenvolvimento, e-commerce, Shopify, Magento, produtividade e carreira profissional.

Your admin users data are on the tables admin_user and admin_passwords in your Magento 2 database, you can use these commands to export and then import in your second store:

Export

$ mysqldump -p --user=username dbname admin_user admin_passwords > myAdminUsers.sql

Import

$ mysql -u username -p -D dbname < myAdminUsers.sql

Important

If you use a database prefix, don't forget to use on these commands above.

How to import and export admin users on Magento 2?

Comments

More from this blog

Adobe Commerce upgrade and resign in parallel

PWA myths and secrets revealed

Deploy a Next.js App to AWS Amplify

How to downgrade Composer via homebrew?

How to add new users to the Magento Cloud panel?

Command Palette

Comments

More from this blog