Music Philosophy Art Math Chess Programming and much more ...
Efter en Windows-uppdatering slutade phpMyAdmin fungera. Felet orsakades av korrupta systemtabeller i databasen mysql
.
Vanligaste orsaken är att Windows tvångsstängde MySQL mitt i en skrivning. Detta kan ske vid t.ex. omstart, rättighetsändringar eller antivirusblockering.
mysqld --skip-grant-tables --console
mysql -u root
GRANT
eller FLUSH PRIVILEGES
→ systemtabeller trasigamysql
-systemdatabas med mysql_install_db
i tom mappmysql
-mappen till data
-katalogenGRANT ALL PRIVILEGES...
C:\xampp
från Windows Defenderdata
och php.ini
Terminal = PowerShell, trots namnbytet i Windows 11.
After a Windows update, phpMyAdmin stopped working. The error was caused by corrupted system tables in the mysql
database.
Most likely Windows forcibly shut down MySQL during a write. This can happen during reboot, permission changes, or antivirus interference.
mysqld --skip-grant-tables --console
mysql -u root
GRANT
or FLUSH PRIVILEGES
→ system tables are brokenmysql
system tables with mysql_install_db
in empty foldermysql
folder into the data
directoryGRANT ALL PRIVILEGES...
C:\xampp
from Windows Defenderdata
and php.ini
Terminal in Windows 11 = still PowerShell, despite the rename.