Webmin > Servers > MySQL Database Server > MySQL Server Configuration
Change “Sort buffer size” from
[*] Default
to
[*] 1 [Mb]
Save and Restart MySQL
Results in a wrecked MySQL that can not start.
Upon investigation it looks like Webmin wrote garbage into /etc/mysql/mysql.conf.d/mysqld.cnf
set-variable = sort_buffer_size=1M
That’s invalid and stopped MySQL from being able to start, which in turn leaves the entire MySQL admin section of Webmin inaccessible, and therefor impossible to even attempt to revert the change through Webmin’s UI.
Manually editing that file so the line reads:
sort_buffer_size=1M
allowed MySQL to be able to restart. Chasing down where that setting was actually edited in the filesystem was … fun.
No worries, fortunately tracked down what was going on and fortunately I was doing this way after office hours in case something went screwy (it pays to be paranoid) - so little real damage done. Thought you should know!