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