You often see this issue while login in magento admin dashboard. There may be several reason behind this issue:
- Browser Cache Issue : First clear your browser cache or try to open same URL (www.your_site.com/admin) in incognito windows.
- Magento Session/ Cache Issue: It might be your magento session/cache issue, So go to your magento_root/var/session and delete all the session created there and clean cache created over magento_root/var/cache.
- Database Issue: If both the cases not resolve the issue, it might be some issue in database. check the “admin_user” , if the entry missing for the same which you are try then create the admin user by using below SQL query:
LOCK TABLES `admin_role` WRITE , `admin_user` WRITE;
SET @SALT = "rp";
SET @PASS = CONCAT(MD5( CONCAT(@SALT, "your_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@domain.com', 'your_username', @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_user WHERE username = 'your_username'), 'FirstName');
UNLOCK TABLES;Happy Coding 🙂
Praveen Maurya work in e-commerce domain having knowledge of Plugin development in Magento 1.x/2.x, Drupal, Woo-Commerce, PrestaShop, Opencart and other e-commerce solution. When he is not engrossed with anything related to these, he loves to explore new things.