For some reason I can't run the mysql_secure_installation command in the linuxserver/mariadb container. It works fine in the official mariadb container and is in the mariadb documentation recommended for a "productive" system. But mine ist only throwing the following error when I enter my password that I chose at container creation:
Enter current password for root (enter for none):
ERROR 1133 (28000) at line 1: Can't find any matching row in the user table
My mariadb will only be for a private nextcloud, so it's not directly a productive system. But nextcloud will be accessible from the internet (behind reverse proxy) so I am concerned about security.
So is it intended that the mysql_secure_installation can't be executed or is it already been done by linuxserver? Or should I pick the official mariadb container for my usecase?