mysql edit user doesn't work in mariadb 10.4.7

Creating new virtual machines now works for me with the edits shown elsewhere. But creating a new mysql user in webmin in the mysql section fails with this error

“Failed to save user : SQL insert into user (host, user, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv, Create_tablespace_priv, Delete_history_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, authentication_string) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) failed : The target table user of the INSERT is not insertable-into”

the file I believe that is causing the issue is edit_user.cgi in the mysql folder.

Howdy,

Yeah there’s a number of fixes being worked on in order to get both Webmin and Virtualmin to properly work with newer MariaDB versions… Jamie is putting the finishing touches on that now.

-Eric

1 Like

I can live without creating mysql users for a bit … And yay for Jamie …

This has been implemented in Webmin 1.960 and Virtualmin 6.13 is going to have support for it (MariaDB 10.4+ and MySQL 8+) too. Let us know if it works for you.

Has this been added in Webmin?
I don’t see it as an option.
If it has, how do we upgrade?

This is an ancient thread, discussing a version of Wemin released over a year ago. Please don’t make zombies.

If you have new problems, please create a new topic (it cannot be the same problem, because Webmin 1.960 added support for the issue being discussed).