- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2019
11:40 PM
02-27-2019
11:40 PM
need help?
Hi,
I am unable to login as admin and I have no store owner.
How do I resolve this? Is there anyone I can contact to resolve this?
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-28-2019
12:12 AM
02-28-2019
12:12 AM
Re: need help?
Hello @cambridgee_camb ,
Please go to magento directory and run below command via terminal
php bin/magento admin:user:create --admin-user="admin" --admin-password="123123q" --admin-email="admin@example.com" --admin-firstname="Admin" --admin-lastname="Admin"
You can set email address, username and password in it.
--
If my answer is useful, please Accept as Solution & give Kudos
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-28-2019
12:26 AM
02-28-2019
12:26 AM
Re: need help?
I am assuming that you are using Magento1x version. If you have forgot your admin password you can run following MySQL command
UPDATE admin_user SET `password` = md5('YOUR_NEW_PASSWORD'), is_active = 1 WHERE `username` = 'YOUR_ADMIN_USERNAME';
To create a new admin user run following my SQL commands
LOCK TABLES `admin_role` WRITE , `admin_user` WRITE; SET @SALT = "rp"; SET @PASS = CONCAT(MD5(CONCAT( @SALT , "password") ), CONCAT(":", @SALT )); SELECT @EXTRA := MAX(extra) FROM admin_user WHERE extra IS NOT NULL; INSERT INTO `admin_user` (firstname,lastname,email,username,password,created,lognum,reload_acl_flag,is_active,extra,rp_token_created_at) VALUES ('Firstname','Lastname','email@example.com','myuser',@PASS,NOW(),0,0,1,@EXTRA,NOW()); INSERT INTO `admin_role` (parent_id,tree_level,sort_order,role_type,user_id,role_name) VALUES (1,2,0,'U',(SELECT user_id FROM admin_use
---
Problem Solved Click Accept as Solution!:Magento Community India Forum
Problem Solved Click Accept as Solution!:Magento Community India Forum