Cant create MariaDB user

Webmin
1

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

2

@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.

3

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.

Untitled-1
Untitled-12903×3872 551 KB

Re.
Popov

4

@POPOV,

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

5

there should be another form

image
image1198×647 36 KB

1 Like
6

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

Screenshot 2025-05-31 184330
Screenshot 2025-05-31 1843302784×586 33.7 KB

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

7

@POPOV,

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

8

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

image
image1587×417 44.7 KB

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

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

9

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

10

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

2 Likes
11

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

webmin patch https://github.com/webmin/webmin/commit/0a0f038
1 Like
12

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