How to login to admin or backend if magento database is deleted

0
votes

I was working with magento and by mistake I deleted whole magento database, but on opening magento again from localhost new database was generated successfully.

But now the problem is that I am not able to login in backend.

I created admin user in admin_user table with user name as admin and entered password encrypted with MD5, I also tried with the following query

UPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin';

But this also don't help me.

Can anyone tell me now how can I login to backend.

"Parent Role id ‘G1’ does not exist"

error message is displayed on login as admin

I am using 1.7 version

1
phpmysqlmagentomagento-1.7
can any one tell me what can be the role type for admin user – Jay
Looks like role type is 'G' – thgaskell
yes role type is 'G' by default – Jay
what role type it should have to access it – Jay
delete app/etc/local.xml file and install fresh magento again in 2 mins, you will get every access. delete cache before – Ricky Sharma

1 Answers

0
votes

Magento IS the database. If you've managed to delete it, you start from scratch.

Remove your app/etc/local.xml file, drop all the tables in the Magento database, get your database credentials together and let Magento recreate the complete database table structure from scratch.

Anything else means you start up in some sort of unknown state where the system eventually becomes totally unusable.