Join the community today
Register Now

/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by pamamolf, Jun 9, 2014.

  1. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    7:02 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    Hi after installation i run to secure mysql removing anonymous login and test database:


    Code:
    mysql_secure_installation
    I got a prompt for root password to start but on the top i got this:
    Code:
    /usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found
    Why?

    Thanks
     
  2. eva2000

    eva2000 Administrator Staff Member

    53,153
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    2:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    can be ignored.. left over error from MariaDB changes itself and you do not need to run mysql_secure_installation if you use .07 beta and onwards as password is auto generated at the end

    i.e. for .07 beta 21

    Code:
    *************************************************
    * Centmin Mod install completed....
    *************************************************
    
    *************************************************
    *  Setup memcached_*.php admin page ...
    *************************************************
    
    Setup Memcached Server Admin Login Details for /usr/local/nginx/html/memcache_28368.php
    current memcached username: memcacheuser
    current memcached password: memcachepass
    *************************************************
    Memcached Server Admin Login: /usr/local/nginx/html/memcache_28368.php
    new memcached username: memadmin8852493ccc
    new memcached password: a21726d5b59b37ce16b02ef8
    *************************************************
    *************************************************
    * memcache_28368.php admin page installed
    *************************************************
    
    *************************************************
    * MariaDB Security Setup
    *************************************************
    
    -------------------------------------------------------
    MySQL root user password set
    MySQL root user added to /root/.my.cnf
    -------------------------------------------------------
    MySQL root password: vxohyeOzCGkTvRAg
    -------------------------------------------------------
    *************************************************
    * MariaDB Security Setup Completed
    *************************************************
     
  3. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    7:02 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    I am running this to remove anonymous logins and test database and not to create a new password :)
     
  4. eva2000

    eva2000 Administrator Staff Member

    53,153
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    2:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  5. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    7:02 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    I am not sure about anonymous logins but on my installation i had the test database :(

    I found it using phpmyadmin before i delete it.
     
  6. eva2000

    eva2000 Administrator Staff Member

    53,153
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    2:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    .06 stable or .07 beta ?
     
  7. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    7:02 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    123.07beta21

    Code:
    https://github.com/centminmod/centminmod/archive/123.07beta21.zip
     
  8. eva2000

    eva2000 Administrator Staff Member

    53,153
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    2:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  9. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    7:02 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    Fresh install only latest Centos 6.5 64bit

    I just format the server and install latest centminmod 123.07beta21 .
     
  10. eva2000

    eva2000 Administrator Staff Member

    53,153
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    2:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    strange then
     
  11. rdan

    rdan Well-Known Member

    5,439
    1,397
    113
    May 25, 2014
    Ratings:
    +2,186
    Local Time:
    12:02 PM
    Mainline
    10.2
    Last time when I setting up my Live Server for Final install after I've done installing minimal centos, I also have the test database.
     
  12. eva2000

    eva2000 Administrator Staff Member

    53,153
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    2:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    ah indeed there is ! will fix that :)
     
  13. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    7:02 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    Ok the test database is not so important as the anonymous logins that i am not sure if it is removed by the script.
     
  14. eva2000

    eva2000 Administrator Staff Member

    53,153
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    2:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  15. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    7:02 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    Now i have remove them from the mysql_secure_installation but i think that was not there and your script do it already :)

    So only the test database need a fix to not be there :)
     
  16. eva2000

    eva2000 Administrator Staff Member

    53,153
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    2:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  17. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    7:02 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    Nice good and fast job :)