# MariaDB syntax change on Rocky 10 **URL:** \ **Category:** Webmin\ **Tags:** feature-request\ **Created:** [May 9, 2026, 11:31pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187 "2026-05-09T23:31:22Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![richard47](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@richard47](https://forum.virtualmin.com/u/richard47)\ **Post date:** [May 9, 2026, 11:31pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/1 "2026-05-09T23:31:23Z")
| SYSTEM INFORMATION | | | --- | --- | | OS type and version | Rocky Linux 10.1 | | Webmin version | 2.640 | Trying to add a MariaDB user using Webmin, results in this error message: > ### Failed to save user : SQL create user ‘xyz’@‘localhost’ identified with mysql\_native\_password by ‘xxxxxxxx’ 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 ‘by ‘xxxxxxxx’’ at line 1 - **Syntax Mismatch:** MariaDB changed how it handles the `IDENTIFIED` clause. The `IDENTIFIED WITH 'plugin' BY 'password'` syntax is more common in standard MySQL, but MariaDB often expects `IDENTIFIED VIA` or simply `IDENTIFIED BY`. - **Webmin Compatibility:** It looks like Webmin is sending a legacy MySQL command that your current Rocky Linux MariaDB environment (likely 10.11 or newer) finds “deprecated” or syntactically incorrect. > [!TIP] Since you are on **Rocky Linux 10** , you are likely running a very recent version of MariaDB where the `VIA` keyword has replaced `WITH` for plugin declarations. Can Webmin be updated to support the new syntax in MariaDB? Thanks. ---
**Author:** ![richard47](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@richard47](https://forum.virtualmin.com/u/richard47)\ **Post date:** [May 9, 2026, 11:54pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/2 "2026-05-09T23:54:15Z")
Another related issue: Viewing the user named “root”, the **Current hashed password** field shows **invalid**. This happens because MariaDB 10.4+ moved user credentials from the `mysql.user` table to a more secure internal structure. Webmin is likely trying to read the old `Password` column, which is now blank or deprecated, causing it to display “invalid” even if your login actually works. So there may be a number of differences in the latest MariaDB that Webmin is not aware of. ---
**Author:** ![lawk](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/l/dbc845/32.png) [@lawk](https://forum.virtualmin.com/u/lawk)\ **Post date:** [May 10, 2026, 5:39pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/3 "2026-05-10T17:39:00Z")
Which mariadb are you actually running? I run 10.11 on Alma 9.7 and it works fine. I will upgrade to 11.8 when alma 9.8 has it in module stream. I would assume Virtualmin can deal with 11.8 ---
**Author:** ![richard47](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@richard47](https://forum.virtualmin.com/u/richard47)\ **Post date:** [May 10, 2026, 6:20pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/4 "2026-05-10T18:20:21Z")
Webmin says I am running MariaDB version 10.11.15. I don’t use Virtualmin, just Webmin. ---
**Author:** ![Ilia](https://cdn.forum.virtualmin.com/user_avatar/forum.virtualmin.com/ilia/32/10185_2.png) [@Ilia](https://forum.virtualmin.com/u/Ilia)\ **Post date:** [May 10, 2026, 6:35pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/5 "2026-05-10T18:35:42Z")
> [@richard47](#): > > Webmin says I am running MariaDB version 10.11.15. What is the actual MariaDB version you are running? ---
**Author:** ![richard47](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@richard47](https://forum.virtualmin.com/u/richard47)\ **Post date:** [May 11, 2026, 7:32pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/6 "2026-05-11T19:32:21Z")
select version(); ±-----------------+ | version() | ±-----------------+ | 10.11.15-MariaDB | ±-----------------+ Same as Webmin reports. How could it be different? ---
**Author:** ![Ilia](https://cdn.forum.virtualmin.com/user_avatar/forum.virtualmin.com/ilia/32/10185_2.png) [@Ilia](https://forum.virtualmin.com/u/Ilia)\ **Post date:** [May 12, 2026, 12:07am UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/7 "2026-05-12T00:07:07Z")
What is the content of `/etc/webmin/mysql/config` file? ---
**Author:** ![richard47](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@richard47](https://forum.virtualmin.com/u/richard47)\ **Post date:** [May 12, 2026, 8:03pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/8 "2026-05-12T20:03:38Z")
/etc/webmin/mysql/config max\_text=1000 max\_dbs=50 ssl=0 mysqladmin=/usr/bin/mysqladmin access=\*: \* stop\_cmd=systemctl stop mariadb mysqlshow=/usr/bin/mysqlshow add\_mode=1 start\_cmd=systemctl start mariadb style=1 my\_cnf=/etc/my.cnf blob\_mode=0 mysql=/usr/bin/mysql webmin\_subs=0 mysqldump=/usr/bin/mysqldump date\_subs=0 mysqlimport=/usr/bin/mysqlimport login=root nodbi=0 passwd\_mode=0 mysql\_data=/var/lib/mysql nopwd=0 perpage=25 mysql\_libs= ---
**Author:** ![Ilia](https://cdn.forum.virtualmin.com/user_avatar/forum.virtualmin.com/ilia/32/10185_2.png) [@Ilia](https://forum.virtualmin.com/u/Ilia)\ **Post date:** [May 13, 2026, 12:26am UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/9 "2026-05-13T00:26:21Z")
Got it, thanks for the heads-up. I think I found the bug causing the issue on your end. Try applying this patch and let me know if it works. ```auto webmin patch https://github.com/webmin/webmin/commit/413087a ``` ---
**Author:** ![richard47](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@richard47](https://forum.virtualmin.com/u/richard47)\ **Post date:** [May 13, 2026, 5:02pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/10 "2026-05-13T17:02:23Z")
Sorry but I’m not clear on how to apply the patch. Just copy the mysql-lib.pl file over an existing file and restart Webmin? In GitHub I just “Download the raw file”? ---
**Author:** ![jimr1](https://cdn.forum.virtualmin.com/user_avatar/forum.virtualmin.com/jimr1/32/14173_2.png) [@jimr1](https://forum.virtualmin.com/u/jimr1)\ **Post date:** [May 13, 2026, 5:09pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/11 "2026-05-13T17:09:14Z")
Just run the command @Ilia posted in the previous post ---
**Author:** ![richard47](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@richard47](https://forum.virtualmin.com/u/richard47)\ **Post date:** [May 13, 2026, 6:19pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/13 "2026-05-13T18:19:35Z")
Thanks. It isn’t obvious that is a command to be entered on a command line. ---
**Author:** ![ID10T](https://cdn.forum.virtualmin.com/user_avatar/forum.virtualmin.com/id10t/32/7895_2.png) [@ID10T](https://forum.virtualmin.com/u/ID10T)\ **Post date:** [May 13, 2026, 8:13pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/14 "2026-05-13T20:13:20Z")
It is to ‘regular’ readers here. 😉 ---
**Author:** ![Joe](https://cdn.forum.virtualmin.com/user_avatar/forum.virtualmin.com/joe/32/9_2.png) [@Joe](https://forum.virtualmin.com/u/Joe)\ **Post date:** [May 13, 2026, 9:13pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/15 "2026-05-13T21:13:40Z")
Not everyone is here every day, and that’s fine. There are several `webmin` commands, which you can see with: ```auto [root@n1 ~]# webmin -l disable-proxy disable-twofactor enable-proxy language-manager list-config passwd patch server set-config update-devel ``` All have help. ```auto [root@n1 ~]# webmin list-config --help Usage: webmin list-config [options] Options: --help, -h Print this usage summary and exit. --config, -c Specify the full path to the Webmin configuration directory. Defaults to "/etc/webmin" --module, -m Specify which module configuration to display. If none given, configuration will be assumed to be the Webmin core configuration (/etc/webmin/miniserv.conf). --option, -o Specify a single option to display. By default, the entire configuration file will be displayed. If this option is given, only the option specified will be shown. --describe, -d Display the description of the option from the module "config.info" file, instead of it's current value. This option is only available for modules, as miniserv.conf does not have a config.info. ``` ---
**Author:** ![richard47](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@richard47](https://forum.virtualmin.com/u/richard47)\ **Post date:** [May 13, 2026, 9:43pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/16 "2026-05-13T21:43:57Z")
Thank you very much for the information. I have been using Webmin for many years, currently on nine cloud servers and one local, but I have rarely needed to visit the forum so all of those options are new to me. I guess that is a testament to the stability and reliability of Webmin in my experience. I don’t use git so first try resulted in this: > sudo webmin patch [Fix MariaDB create user auth plugin syntax · webmin/webmin@413087a · GitHub](https://github.com/webmin/webmin/commit/413087a) > Neither “patch” nor “git” commands are installed Strange and annoying that the text I pasted in is not displayed correctly, The blue text is not exactly the command I sent to my server or pasted in to this editor. Installed git. > sudo webmin patch [Fix MariaDB create user auth plugin syntax · webmin/webmin@413087a · GitHub](https://github.com/webmin/webmin/commit/413087a) > Patch applied successfully to: > mysql/mysql-lib.pl Tested adding a user to MariaDB and it was successful with no error messages. Thank you. ---
**Author:** ![system](https://cdn.forum.virtualmin.com/uploads/default/original/2X/c/cd96d761e326db4b2bef94886a639109bd7a8e76.svg) [@system](https://forum.virtualmin.com/u/system)\ **Post date:** [May 21, 2026, 9:44pm UTC](https://forum.virtualmin.com/t/mariadb-syntax-change-on-rocky-10/137187/17 "2026-05-21T21:44:23Z")
Closed on May 21, 2026, 9:44pm UTC This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.