I got a problem that I do not know what my employee used for username
I have tried resetting the password, but it I do not know the username
I do have access to the mySQL database
Can someone help me please
I have tried resetting the password, but it I do not know the username
I do have access to the mySQL database
Can someone help me please
Use phpAdmin to get into the database, then search the relevant table.
Life is not a dress rehearsal, it's the real thing.
(1) Go into database, into user table, ADD a record, give it an admin username that you'll remember (~!admin or bobadmin or the like), fill in the rest of the boxes (or if line-wise, the rest of the record row).
(2)(a) If you do have your own customer account, you can grab the name/password from the customer table and paste them into your own new user record.
(2)(b)(1) Simpler, yet, is just to put in a new username, put in any password, Save,
(2)(b)(2) THEN upload ocreset.php into /admin/, address that as http://[store]/admin/ocreset.php, give it the new username, it will make a new password on the spot (no mail), and that will be in the database on the spot.
(2)(b)(3) Read his instructions here:
http://forum.opencart.com/viewtopic.php?t=15626#p76531
Download it here:
http://www.jaygilford.com/download/ocreset
(2)(a) If you do have your own customer account, you can grab the name/password from the customer table and paste them into your own new user record.
(2)(b)(1) Simpler, yet, is just to put in a new username, put in any password, Save,
(2)(b)(2) THEN upload ocreset.php into /admin/, address that as http://[store]/admin/ocreset.php, give it the new username, it will make a new password on the spot (no mail), and that will be in the database on the spot.
(2)(b)(3) Read his instructions here:
http://forum.opencart.com/viewtopic.php?t=15626#p76531
Download it here:
http://www.jaygilford.com/download/ocreset
Who is online
Users browsing this forum: No registered users and 4 guests