I installed fresh magento

just copied the magento folders and after that created database using cpanel.

now, i dont know what username and password to give in backend.

i followed this

i run SELECT * FROM admin_user; and than it showed :

enter image description here

if the user created already, than somehow we can change username and password, here there is no user created!

enter image description here


Try this sql script (where username is 'myuser' and password is 'password'):

LOCK TABLES `admin_role` WRITE, `admin_user` WRITE;

SET @SALT = "rp";
SET @PASS = CONCAT(MD5(CONCAT(@SALT, "password")), CONCAT(":", @SALT));
FROM admin_user

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_user
                       WHERE username = 'myuser'), 'Firstname');

| improve this answer | |
  • i want to know why user didt created initially, just curious to know ? – Baby in Magento May 3 '16 at 7:16
  • @BabyinMagento I don't know for certain, but I think at installation there was a error. – Siarhey Uchukhlebau May 3 '16 at 7:17
  • may be you are right, as always i do some errors , Thanks :-) – Baby in Magento May 3 '16 at 7:18

you can add admin with MySql query:

/* This is an example SQL script.
You should replace all the UPPERCASED variables.
The <USERNAME> variable can only be alphanumeric characters, and probably underscores (haven't tested)

You can either generate a password hash using the PHP code below,
or you can grab a password hash from the admin_user table from an
existing Magento install for which you know the admin password.

/* Use the following PHP script to generate a salted password hash. You can also use a straight md5 hash, but it's much more easily brute-forced
<?php $password = 'PASSWORD'; $salt = 'GF'; echo $hash = md5($salt.$password).':'.$salt; ?>

insert into admin_user
(select max(user_id) + 1 from admin_user) user_id,
'FIRST NAME' first_name,
'LAST NAME' last_name,
'EMAIL' email,
'USERNAME' username,
'HASH EXAMPLE: 178f29c8e4c6c801db90cd171e3b2b53:in' password, /* You can replace this value with an md5 hash */
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;

insert into admin_role
(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

This is code from: HERE by Erik Hansen

Good luck! :)

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.