So I did the most wonderful thing of accidentally deleting all root user in mysql. Long story and I’m pretty upset about it.
Anyways before huge panic I just looked up a way to re-create root and found this
So I went to do this and now found this error I believe is from virtualmin new version?
The target table user of the INSERT is not insertable-into
I have tried several of the fixes I found in virtualmin forums from this thread and none of them worked.
I got as far as trying this command
perl -MCPAN -e shell cpan> install Digest::SHA1 and it just stays there and nothing happens.
Now I’m starting to panic. Everything works for now as all domains have their own user virtualmin creates so that is fine, but I cannot create anything new, cannot access DB as super user.
Does anyone know if that release is out?
Can I escape this error by downgrading virtualmin? if so what version should I fetch?
Anyone have any advice?
Webmin version 1.940
Virtualmin version 6.08
mysql Ver 15.1 Distrib 10.4.11-MariaDB, for Linux (x86_64) using readline 5.1