Welcome to Centmin Mod Community
Become a Member

Stable Branch update centmin.sh menu option 6 additional submenu options in 130.00b…

Discussion in 'Centmin Mod Github Commits' started by eva2000, Jul 2, 2024.

  1. eva2000

    eva2000 Administrator Staff Member

    58,905
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    1:48 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    update centmin.sh menu option 6 additional submenu options in 130.00beta01

    - add centmin.sh menu option 6 submenu options for MySQL database deletion and listing

    ----------------------------------------------------------------
    MySQL User Database Management Sub Menu
    ----------------------------------------------------------------
    Command Line Version community.centminmod.com/threads/543/
    ----------------------------------------------------------------
    1). Create MySQL User and Database
    2). Add Database to Existing MySQL User
    3). Add Existing Database to Existing MySQL User
    4). Add Existing Database to New MySQL User
    5). Change MySQL User Password
    6). Delete MySQL User
    7). Show Grants for MySQL User
    8). Create Global MySQL User (access to all databases)
    9). Create Multiple MySQL Databases and Users from File
    10). Delete MySQL Database
    11). List All MySQL Databases and Users
    12). Return to Main Menu
    ----------------------------------------------------------------
    Enter option [ 1 - 12 ]: 11
    Do you want to proceed with this option? [y/n]: y
    --------------------------------------------------------------
    MySQL Admin
    --------------------------------------------------------------
    --------------------------------------------------------------

    --------------------------------------------------------------
    List MySQL Databases, Creation Dates, and Associated Users
    --------------------------------------------------------------
    db: db1 created: 2024-06-28 15:27:48 [users: user1]
    db: db2 created: 2024-06-28 15:32:26 [users: user2]
    db: db3 created: 2024-06-28 15:35:55 [users: user2, user3]
    db: db4 created: 2024-06-28 15:36:36 [users: user4]
    db: db5 created: 2024-06-28 15:39:04 [users: user5]
    db: db6 created: 2024-06-28 15:40:06 [users: user6]
    db: db7 created: 2024-06-28 15:45:30 [users: user7]
    db: db8 created: 2024-06-28 15:47:05 [users: user8]
    db: db9 created: 2024-06-28 15:48:47 [users: user9]
    db: db10 created: 2024-06-28 15:58:05 [users: user10]
    db: db11 created: 2024-06-28 16:03:32 [users: user11]
    db: db12 created: 2024-06-28 16:04:35 [users: user12]
    db: db13 created: 2024-06-28 16:06:17 [users: user13]
    db: db14 created: 2024-06-28 16:09:01 [users: user14]
    db: newdb1 created: 2024-06-28 16:09:37 [users: user1]
    db: test created: 2024-06-25 11:16:59 [users: none]

    and deletion

    ----------------------------------------------------------------
    MySQL User Database Management Sub Menu
    ----------------------------------------------------------------
    Command Line Version community.centminmod.com/threads/543/
    ----------------------------------------------------------------
    1). Create MySQL User and Database
    2). Add Database to Existing MySQL User
    3). Add Existing Database to Existing MySQL User
    4). Add Existing Database to New MySQL User
    5). Change MySQL User Password
    6). Delete MySQL User
    7). Show Grants for MySQL User
    8). Create Global MySQL User (access to all databases)
    9). Create Multiple MySQL Databases and Users from File
    10). Delete MySQL Database
    11). List All MySQL Databases and Users
    12). Return to Main Menu
    ----------------------------------------------------------------
    Enter option [ 1 - 12 ]: 10
    Do you want to proceed with this option? [y/n]: y
    --------------------------------------------------------------
    MySQL Admin
    --------------------------------------------------------------
    --------------------------------------------------------------


    --------------------------------------------------------------
    Delete MySQL Database
    --------------------------------------------------------------
    WARNING: Ensure you have a MySQL database backup before deletion!

    Enter the name of the database you want to delete: test
    Are you absolutely sure you want to delete the database 'test'?
    Type the database name again to confirm deletion: test

    Ok: Database 'test' was successfully deleted

    Continue reading...

    131.00stable branch