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.
https://virtualmin.com/node/66724
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.
I read that Jamie was working on a fix for at least error
The target table user of the INSERT is not insertable-into
from this thread *[QUICKFIX]* for MariaDB 10.2 - 10.4.7 !!! mentioned by @Eric
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?
Centos7
Webmin version 1.940
Usermin version|1.780
Virtualmin version 6.08
mysql Ver 15.1 Distrib 10.4.11-MariaDB, for Linux (x86_64) using readline 5.1