Magento add admin user in MySQL
In Magento, if you want to create a new user directly in Mysql, it’s not that easy to insert one record in admin_user table.
You need to also update the privileges and inserting new admin’s roles.
So here is a Mysql script which will create a new admin user with all privileges.
Replace FIRSTNAME, LASTNAME, EMAIL, USERNAME, PASSWORD with your desired values.
insert into admin_user | |
select | |
(select max(user_id) + 1 from admin_user) user_id, | |
'FIRSTNAME' first_name, | |
'LASTNAME' last_name, | |
'TEST@EMAIL.COM' email, | |
'USERNAME' username, | |
MD5('PASSWORD') password, | |
now() created, | |
NULL modified, | |
NULL logdate, | |
0 lognum, | |
0 reload_acl_flag, | |
1 is_active, | |
(select max(extra) from admin_user where extra is not null) extra, | |
NULL, | |
NULL; | |
insert into admin_role | |
select | |
(select max(role_id) + 1 from admin_role) role_id, | |
(select role_id from admin_role where role_name = 'Administrators') parent_id, | |
2 tree_level, | |
0 sort_order, | |
'U' role_type, | |
(select user_id from admin_user where username = 'USERNAME') user_id, | |
'USERNAME' role_name |
8 Comments
Leave a comment
Welcome to my Blog
Certifications
Honor
Recognition
Contributions
Categories
- Apache (2)
- ChatGPT (1)
- Domain name (2)
- eCommerce (2)
- htaccess (1)
- Humor (3)
- Instagram API (1)
- jQuery (4)
- JSON (1)
- Linux (10)
- Magento (142)
- Magento admin (58)
- Magento Certification (5)
- Magento error (13)
- Magento frontend (68)
- Magento Imagine (2)
- Magento Interview (5)
- Magento Master (2)
- Magento2 (10)
- Mobile (1)
- MySQL (7)
- OpenAI (1)
- OroCRM (2)
- Performance (2)
- PHP (8)
- Prototype JS (3)
- Security (4)
- Wordpress (3)
- XML (2)
Tag Cloud
500 internal server error admin answers attribute bug category checkbox checkout cookie customer difference domain name EAV error event extension interview invoice jquery linux magento magento2 magento admin magento error magento interview questions magento orm mysql observer order pinterest product products questions redirect register remove script session simplexml to array state status study guide tax url wordpress
Good one…
I have created a tool to generate the SQL for you. http://m4tt.io/tools/magento-admin-generator/
Good job!
Is it possible to set global password for admin ?
It is a nice idea to use a salt string with the password.
$salt = ‘h3ud7’;
$password = ‘some_secret_passworD_here’;
$password_hash = md5($salt . $password) . ‘:’ . $salt;
nice its really great help for me
its really great helps for me
great work… i love your snippets ….great work once again