unable to create Virtual Server

When creating Virtual Server through Virtualmin get this

Creating MySQL login .. .. MySQL database failed! : mysql::execute_sql_logged failed : SQL create user 'xxxxxxxxx'@'localhost' identified by password('') 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 '('')' at line 1 at /usr/share/webmin/web-lib-funcs.pl line 1374.

Saving server details .. .. done

Virtualmin version: 6.08
Mariadb/MySQL version: 10.3.17



Howdy -- thanks for contacting us!

What is the username and password in question in this case?

I'm curious if there's a character in one of them that's causing the issue you're seeing.

ok sure. since it will be recreate username: speedtest password: bBQ3V[tBCutL

Hmm, just as a test, could you try changing the users password so that there is no "[" character in it, and then try it again?

If that works, that means there's some kind of escaping issue going on there.

same...I think it is related to incompatible mariadb problem.

Ilia's picture
Submitted by Ilia on Fri, 01/17/2020 - 05:23

What Webmin version are you running on your system? Make sure to install latest version, which is 1.941.

Besides, what is the output of:

cat /usr/libexec/webmin/virtual-server/feature-mysql.pl |grep '$variant eq "mariadb" && &compare_versions($ver, "10.4")'

Note: Replace `libexec` with `share` on Debian/Ubuntu.