Get the most out of your Centmin Mod LEMP stack
Become a Member

Creating specific user and database

Discussion in 'Centmin Mod Insights' started by RoldanLT, Oct 10, 2014.

  1. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    11:44 PM
    1.11
    10.2
    I'm using your command here: WordPress + Super Cache plugin for Centmin Mod Nginx | wp1.centmincache.com
    Code:
    mysqladmin -u root -p create domain1v381
    mysql -u root -p -e "CREATE USER 'domain1username'@'localhost' IDENTIFIED BY 'yourmysqlpass';"
    mysql -u root -p -e "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON domain1v381.* TO 'domain1username'@'localhost'; FLUSH PRIVILEGES;"
    To create a database and exclusive user.
    This command is not specific to wordpress only right?
    It's fine to use it for other php apps? like Xenforo.

    Thanks!
     
  2. eva2000

    eva2000 Administrator Staff Member

    31,001
    6,920
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,426
    Local Time:
    1:44 AM
    Nginx 1.13.x
    MariaDB 5.5
    • Like Like x 1
  3. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    11:44 PM
    1.11
    10.2
    That's a very handy script :)
    Thanks!
     
  4. eva2000

    eva2000 Administrator Staff Member

    31,001
    6,920
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,426
    Local Time:
    1:44 AM
    Nginx 1.13.x
    MariaDB 5.5
    it is ... don't even have to move out of the comfort of good old SSH window :D