2

I call a procedure that includes an infinite loop in phpmyadmin:

WHILE i < 10 DO
  INSERT INTO ...
END WHILE;

Then I can't get into phpmyadmin anymore. It just shows 500 error. Is it possible to resolve it without root permission?

Lai Yu-Hsuan
  • 27,509
  • 28
  • 97
  • 164
  • 2
    Could you reboot the server? If its shared hosting justa call them and ask for a reboot/fix. Also, its mysql that is in a loop. Not phpmyadmin. – Iznogood Feb 24 '12 at 15:49
  • 1
    Related: http://stackoverflow.com/questions/3787651/how-can-i-stop-a-running-mysql-query – Calmarius Jul 17 '13 at 14:22

1 Answers1

4

Could you reboot the server? If its shared hosting just call them and ask for a reboot/fix. Also, its mysql that is in a loop. Not phpmyadmin.

Without ssh access and root powers you are pretty much stuck.

On shared hosting its possible eventually the process will be killed/server rebooted because it is probably eating up ressources.

Iznogood
  • 12,447
  • 3
  • 26
  • 44