Right configuration for SQL

    • OMV 2.x
    • Resolved
    • Right configuration for SQL

      The question is more SQL related than OMV related, still I could not find too much info on this.

      On freshly installed MySQL server on OMV2 there are few default users with no passwords, as far as I understand.



      The intention is to use it with Nginx and Wordpress for websites.

      The question is what is the best available practice for this reason?

      1) shall I create password (s) for existing user (s), for example, for root? Or is it enough that I just disable SQL management site after server set-up?

      2) shall I create separate from root SQL user (with its own password) for Wordpress and websites? Or even separate users for each website?
    • VanRaiks wrote:

      shall I create password (s) for existing user (s), for example, for root? Or is it enough that I just disable SQL management site after server set-up?
      root should always have a strong password.

      VanRaiks wrote:

      shall I create separate from root SQL user (with its own password) for Wordpress and websites?
      never use root for anything other than admin things and definitely not for web sites.

      VanRaiks wrote:

      Or even separate users for each website?
      I would create separate users for each site.
      omv 4.1.12 arrakis | 64 bit | 4.15 proxmox kernel | omvextrasorg 4.1.11
      omv-extras.org plugins source code and issue tracker - github

      Please read this before posting a question and this and this for docker questions.
      Please don't PM for support... Too many PMs!