I just installed Webmin & Virtualmin on this server.
For some reasons,
The configuration entered on “MariaDB Server Configuration” information page are not been saved.
When I’m trying to create a database’s user, I’m getting the error below:
" Failed to save user : SQL create user ‘cell_user’@‘localhost’ identified by ‘hoN1NNA3TGrw1Rp’ failed : Operation CREATE USER failed for ‘cell_user’@‘localhost’"
Also, this is the log report:
[Sat Dec 17 05:30:22.128092 2022] [ssl:warn] [pid 53587:tid 139630112294784] AH01906: deseua.com:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Sat Dec 17 05:31:03.859939 2022] [authz_core:error] [pid 61083:tid 139629680338496] [client 185.3.94.183:35850] AH01630: client denied by server configuration: /home/deseua/public_html/server-status
[Sat Dec 17 05:31:08.712840 2022] [authz_core:error] [pid 61082:tid 139629713909312] [client 185.3.94.183:43754] AH01630: client denied by server configuration: /home/deseua/public_html/server-status
Could this issue be related to Ubuntu 22.04 or Webmin?
When Mysql is completely removed and purged from the server, its still showing up in Webmin of the server running Ubuntu 22.04 (see attached with_ubuntu_22 screenshot). However, when Mysql is removed from a server running Ubuntu 20.04, Mariadb instead shows up in Webmin (see with_ubuntu_20 screenshot attached).
Both servers have Mariadb installed and only the server running Ubuntu 22.04 is showing an error when trying to create a database user.