mySQL / mariadb reset primary key

ALTER TABLE members DROP ID;
ALTER TABLE members AUTO_INCREMENT = 1;
ALTER TABLE members ADD ID int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

Windows Sihost.exe error

I ran into this issue by swapping system hard drives and solved this by doing the following

  1. Press CTRL-ALT-DEL and open the task manager
  2. Click File Run new task
  3. Enter cmd and click the “create this task with administrative privileges”
  4. Run sfc /scannow
  5. Run dism /online /cleanup-image /restorehealth

No guarantee that this will help you too.

Back to Top