Cant create MariaDB user

Hello, team!

Getting error when trying to add new user to MariaDB from “User Permissions > Create New User”

SQL show create user ?@? 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 ‘NULL@NULL’ at line 1

SYSTEM INFORMATION

Webmin 2.400
Debian Linux 12, Linux 6.1.0-37-amd64 on x86_64

@POPOV,

Can you take a screenshot of the screen just before submitting the request, so we can see if there are any errors in the form.

Hello, Peter!

Here is a combined screenshot. Fresh debian 12 install and Webmin. I even have purged mariadb and reinstalled from within webmin. No change.

Re.
Popov

@POPOV,

Did you actually specify a username before you submitted the form, the field looks empty and is set to “Anonymous”.

there should be another form

There is no form. Just the error. Here is step by step

  1. From the left menu , go to MariaDB Database Server
  2. Goto User Premissions
  3. Click “Create New User”
  4. The error appear like the screenshot bellow

I have anther Debian 12 machine with Webmin 2.3.0.3 and there are no problems. Since it is productions machine I don’t wand to update to 2400

I have reinstalled now debian from scratch and installed Webmin and Mysql and got the same error.

Re.
Popov

@POPOV,

Have you tried rebooting your system to see if the error continues to happen?

I just installed Debian 12 and I get the same issue. I thought it maybe the root user not having a password but I created and added pasword into config


but I get same error.
Following these docs to add password.

I’m thinking a bug. I will try another OS.

Just installed clean Alma Linux 9 x64 and install mariadb server and still getting the same error.
I can create a database ok in the UI but the create user it produces same error output at OP.
@Jamie any idea what we can be doing wrong?

the miniserv.error also show that error as well, nothing else.

[01/Jun/2025:09:28:01 +0000] [xxx.xxx.xxx.xxx] /mysql/edit_user.cgi?new=1 : SQL show create user ?@? 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 ‘NULL@NULL’ at line 1

This is a known issue which @Ilia recently fixed - we’ll be doing a new release with a fix shortly.

Alternatively, if you need an immediate fix, you can apply the patch by running:

webmin patch https://github.com/webmin/webmin/commit/0a0f038

Thank you for the prompt reply, guys! It is not an urgent matter. I’ll wait for the oficial release. Have a good one!
Re.,
Popov