title: How to login to admin or backend if magento database is deleted
body: <p>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.</p>
  
  <p>But now the problem is that I am not able to login in backend.</p>
  
  <p>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</p>
  
  <pre><code>UPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin';
  </code></pre>
  
  <p>But this also don't help me.</p>
  
  <p>Can anyone tell me now how can I login to backend.</p>
  
  <p>"Parent Role id ‘G1’ does not exist"</p>
  
  <p>error message is displayed on login as admin</p>
  
  <p>I am using 1.7 version</p>