Want to subscribe to topics you're interested in?
Become a Member

centmin.sh Add auto generate database and mysql user during option 2

Discussion in 'Feature Requests & Suggestions' started by pdinh97qng, Sep 15, 2019.

  1. pdinh97qng

    pdinh97qng Member

    121
    15
    18
    Jan 24, 2016
    Ratings:
    +39
    Local Time:
    10:25 PM
    I know that centmin mod have a tool to create database and mysql user but it will be much easier if we have an option whether to generate them after creating a vhost domain (option 2).

     
  2. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    8:25 AM
    Nginx-1.29.x
    MariaDB 10.6.x
    With a question if we need to create that, YES i agree as most of the times is needed!
     
  3. eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    3:25 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    I'd have to think about that as you already have quick ways of doing just that see Install - Quick Centmin Mod Install + Nginx Vhost Site + MySQL Database Setup

    one time task ensure letsencrypt support is enabled
    Code (Text):
    touch /etc/centminmod/custom_config.inc
    echo "LETSENCRYPT_DETECT='y'" >> /etc/centminmod/custom_config.inc
    

    then you can create letsencrypt HTTPS SSL default site called domain.com with desired pure-ftpd username = ftpusername and create mysql database named = mydb with mysql user = myadmin and mysql user password = mypass
    Code (Text):
    nv -d domain.com -s lelived -u ftpusername
    /usr/local/src/centminmod/addons/mysqladmin_shell.sh createuserdb mydb myadmin mypass
    

    centmin.sh menu option 2 or nv command line can create nginx vhost sites easily as outlined at Nginx Vhost & NSD DNS Setup - CentminMod.com LEMP Nginx web stack for CentOS