Learn about Centmin Mod LEMP Stack today
Become a Member

Beta Branch revise centmin.sh menu option 11 add mysql root password reset

Discussion in 'Centmin Mod Github Commits' started by eva2000, Dec 11, 2016.

  1. eva2000

    eva2000 Administrator Staff Member

    30,613
    6,862
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,304
    Local Time:
    8:53 PM
    Nginx 1.13.x
    MariaDB 5.5
    revise centmin.sh menu option 11 add mysql root password reset

    For 123.09beta01 revise centmin.sh menu option 11 with a submenu option 0 (to preserve existing submenu numbers) to allow MySQL root user password resetting with proper updating of /root/.my.cnf as well. Example below of submenu option 0

    Code (Text):
    --------------------------------------------------------
         MariaDB MySQL Upgrade & Management Sub-Menu
    --------------------------------------------------------
    0). Regenerate New MySQL Root User Password (local server)
    1). MariaDB 5.2.x Branch Upgrade Only
    2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
    3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
    4). MariaDB 5.5 to MariaDB 10.1.x YUM upgrade
    5). MariaDB 10.x to MariaDB 10.1.x YUM upgrade
    6). MariaDB 10.1.x to MariaDB 10.2.x YUM upgrade
    7). Back to Main menu
    --------------------------------------------------------
    Enter option [ 0 - 7 ] 0
    --------------------------------------------------------
    
    This routine will reset the MySQL root user password
    and properly update the /root/.my.cnf file as well.
    
    This routine is only for local MariaDB MySQL servers not remote ones
    
    Do you want to continue? [y/n]: y
    
    Process begins in 10 seconds...
    
    Previous MySQL root password:
    
    [client]
    user=root
    password=E55t78qeSth/z3jO
    
    mysqladmin -u root -pE55t78qeSth/z3jO password 5hlC1E8sgsXXaX85
    
    New MySQL root user password: 5hlC1E8sgsXXaX85
    
    /root/.my.cnf updated
    
    [client]
    user=root
    password=5hlC1E8sgsXXaX85
    


    Continue reading...

    123.09beta01 branch

     
    • Like Like x 2
  2. eva2000

    eva2000 Administrator Staff Member

    30,613
    6,862
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,304
    Local Time:
    8:53 PM
    Nginx 1.13.x
    MariaDB 5.5
    new centmin.sh menu option 11 retitled
    Code (Text):
    --------------------------------------------------------
         Centmin Mod Menu 123.09beta01 centminmod.com    
    --------------------------------------------------------
    1).  Centmin Install
    2).  Add Nginx vhost domain
    3).  NSD setup domain name DNS
    4).  Nginx Upgrade / Downgrade
    5).  PHP Upgrade / Downgrade
    6).  XCache Re-install
    7).  APC Cache Re-install
    8).  XCache Install
    9).  APC Cache Install
    10). Memcached Server Re-install
    11). MariaDB MySQL Upgrade & Management
    12). Zend OpCache Install/Re-install
    13). Install/Reinstall Redis PHP Extension
    14). SELinux disable
    15). Install/Reinstall ImagicK PHP Extension
    16). Change SSHD Port Number
    17). Multi-thread compression: pigz,pbzip2,lbzip2...
    18). Suhosin PHP Extension install
    19). Install FFMPEG and FFMPEG PHP Extension
    20). NSD Install/Re-Install
    21). Update - Nginx + PHP-FPM + Siege
    22). Add Wordpress Nginx vhost + Cache Plugin
    23). Update Centmin Mod Code Base
    24). Exit
    --------------------------------------------------------
    Enter option [ 1 - 24 ] 11
    --------------------------------------------------------
    
     
    • Like Like x 2