0

I accidentally deleted the admin account,know i cannot login how to add admin via phpmyadmin? it is an web aplication

Noo
  • 3
  • 5
  • nope. nope. nope. – Unamata Sanatarai Aug 06 '18 at 11:33
  • 1
    Find a backup and restore. No backups? Sorry. – u_mulder Aug 06 '18 at 11:35
  • Have you read https://serverfault.com/questions/4309/how-to-reset-or-recover-admin-account-password-for-mysqld this? – P.Salmon Aug 06 '18 at 11:39
  • I will try these links ill hope it helps its already installeed @ website, i just need to insert username/password into admin to work! but cannot figure it out how – Noo Aug 06 '18 at 11:46
  • Can someone tell how to insert admin/password using SQL command in phpmyadmin? – Noo Aug 06 '18 at 12:02
  • i tyred REPLACE INTO admin VALUES ( username,password,) I have created them but know cannot login ? – Noo Aug 06 '18 at 12:11
  • What does `deleted admin` mean exactly? Are you talking about a specific application written in php? Or you're referring to MySQL root account? – Nima Aug 06 '18 at 12:35
  • Yes it is an web application written in php, and i accidentally deleted admin account, and know cannot login so i need to add user/pass to my database using phpmyadmin! – Noo Aug 06 '18 at 12:44
  • I used REPLACE INTO admin VALUES ( username,password) i created it but still cannot login. – Noo Aug 06 '18 at 12:44

1 Answers1

0

here you go, a bit of googling and search in other exchange you find this :
I accidentally lost my admin account! what can I do or this i accidentally deleted the admin account in my phpmyadmin

And you can read the chapter about resetting the root password in the MySQL Reference Manual

Maximilien Nowak
  • 113
  • 1
  • 1
  • 8