Skip to main content

Command Palette

Search for a command to run...

How to import and export admin users on Magento 2?

Published
1 min read

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.

More from this blog

R

Rafael Corrêa Gomes - Ecommerce Developer

31 posts

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