I am using Webmin 2.301 on a Debian Linux 11 Server. MariaDB version is 10.5.26
Since a few weeks, I always get the following error, when I try to create a new user (Username, Password and Permissions) in the MariaDB Database Server → User Permissions.
Failed to save user : SQL grant 1 on . to ‘Testuser’@‘%’ failed : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘1 on . to ‘Testuser’@’%‘’ at line 1
I can only say that I last successfully created a user with permissions in the same way on January 30, 2025.
And if I do exactly the same today:
If I only specify the username, password, and hosts, the user is created without any errors.
As soon as I specify even just one permission, I get this error message. The user is still created, but with permissions set to None. (It also seems to me, that the order of the permissions - dropdown list has changed for some entries)
I have not changed any webmin oder mariadb settings since that time. I have installed the webmin updates to 2.3 / 2.31 in February.
I suspect that this might have come with
Webmin 2.300 and Usermin 2.200 released (February 14, 2025).
At least something was changed in that module (and the permissions list is now sorted differently than before):
“Fix to improve how permissions are displayed in MySQL/MariaDB module.”
As I said, at the end of January with Webmin 2.202, I didn’t have these issues yet…