repair-mysql-data.ps1

Rename-Item -Path "./data" -NewName "./data_old"
Copy-Item -Path "./backup" -Destination "./data" -Recurse
Remove-Item "./data/test" -Recurse
$dbPaths = Get-ChildItem -Path "./data_old" -Exclude ('mysql', 'performance_schema', 'phpmyadmin') -Recurse -Directory
Copy-Item -Path $dbPaths.FullName -Destination "./data" -Recurse
Copy-Item -Path "./data_old/ibdata1" -Destination "./data/ibdata1"

repair-mysql-data.txt

Based on this answer: https://stackoverflow.com/a/61859561/1956278
---
PowerShell.exe -ExecutionPolicy UnRestricted -File repair-mysql-data.ps1
---
CREATE USER 'root'@'%' IDENTIFIED BY ''; 
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;