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?

    • Offizieller Beitrag

    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.


    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.


    Or even separate users for each website?

    I would create separate users for each site.

    omv 7.0-32 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.9 | compose 7.0.9 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!