Learn about Centmin Mod LEMP Stack today
Register Now

Just installed latest version of Centmin, what is DEFAULT MYSQL PASSWORD?

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by johnnyc, Mar 23, 2015.

  1. johnnyc

    johnnyc Member

    33
    2
    8
    Mar 23, 2015
    Ratings:
    +2
    Local Time:
    2:50 AM
    Just did a clean install of latest version of mysql, ,I don't know what the default mysql password is..

    How do I find out?

    Thanks.
     
  2. Steve Tozer

    Steve Tozer Member

    70
    42
    18
    Jul 28, 2014
    South Wales, UK
    Ratings:
    +49
    Local Time:
    8:50 AM
    1.91
    10.0.19
    Hello,

    If you run:
    Code:
    cat ~/.my.cnf
    Should display your mysql root password

    You can just type
    Code:
    mysql
    and this will log you into mysql as root due to the .my.cnf file with your credentials in there.
     
    Last edited: Mar 23, 2015
    • Like Like x 1
  3. eva2000

    eva2000 Administrator Staff Member

    30,196
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,144
    Local Time:
    5:50 PM
    Nginx 1.13.x
    MariaDB 5.5
    Last edited: Mar 24, 2015
  4. johnnyc

    johnnyc Member

    33
    2
    8
    Mar 23, 2015
    Ratings:
    +2
    Local Time:
    2:50 AM
    That line says no such file exists...
    Code:
    *************************************************
    *  MariaDB Security Setup
    *************************************************
    /usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found
    
    NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
          SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!
    
    In order to log into MariaDB to secure it, we'll need the current
    password for the root user.  If you've just installed MariaDB, and
    you haven't set the root password yet, the password will be blank,
    so you should just press enter here.
    
    Enter current password for root (enter for none):
    OK, successfully used password, moving on...
    
    Setting the root password ensures that nobody can log into the MariaDB
    root user without the proper authorisation.
    
    Set root password? [Y/n] New password:
    Re-enter new password:
    Password updated successfully!
    Reloading privilege tables..
    ... Success!
    
    
    By default, a MariaDB installation has an anonymous user, allowing anyone
    to log into MariaDB without having to have a user account created for
    them.  This is intended only for testing, and to make the installation
    go a bit smoother.  You should remove them before moving into a
    production environment.
    
    Remove anonymous users? [Y/n]  ... Success!
    
    Normally, root should only be allowed to connect from 'localhost'.  This
    ensures that someone cannot guess at the root password from the network.
    
    Disallow root login remotely? [Y/n]  ... Success!
    
    By default, MariaDB comes with a database named 'test' that anyone can
    access.  This is also intended only for testing, and should be removed
    before moving into a production environment.
    
    Remove test database and access to it? [Y/n]  - Dropping test database...
    ... Success!
    - Removing privileges on test database...
    ... Success!
    
    Reloading the privilege tables will ensure that all changes made so far
    will take effect immediately.
    
    Reload privilege tables now? [Y/n]  ... Success!
    
    Cleaning up...
    
    All done!  If you've completed all of the above steps, your MariaDB
    installation should now be secure.
    
    Thanks for using MariaDB!
    *************************************************
    *  MariaDB Security Setup Completed
    *************************************************
    
    *************************************************
    *  Setup memcached.php admin page ...
    *************************************************
    
    Setup Memcached Server Admin Login Details for /usr/local/nginx/html/memcache.php
    (Type username your want to set and press Enter):
    (Type password your want to set and press Enter):
    current memcached username: memcacheuser
    current memcached password: memcachepass
    new memcached username:
    new memcached password:
    *************************************************
    * memcache.php admin page installed
    *************************************************
    
    *************************************************
    * Running updatedb command. Please wait....
    *************************************************
    *************************************************
    * Post-Install Check List....
    *************************************************
    
    --------------------------------------------------------
    Check ccache Version:
    --------------------------------------------------------
    ccache version 3.1.6
    
    Copyright (C) 2002-2007 Andrew Tridgell
    Copyright (C) 2009-2011 Joel Rosdahl
    
    This program is free software; you can redistribute it and/or modify it under
    the terms of the GNU General Public License as published by the Free Software
    Foundation; either version 3 of the License, or (at your option) any later
    version.
    
    --------------------------------------------------------
    Check Nginx Version:
    --------------------------------------------------------
    nginx version: nginx/1.5.8
    built by gcc 4.4.7 20120313 (Red Hat 4.4.7-4) (GCC)
    TLS SNI support enabled
    configure arguments: --sbin-path=/usr/local/sbin --conf-path=/usr/local/nginx/conf/nginx.conf --add-module=../ngx_pagespeed-release-1.7.30.1-beta --with-http_spdy_module --with-http_ssl_module --with-http_gzip_static_module --with-http_stub_status_module --with-http_sub_module --with-http_addition_module --with-http_secure_link_module --with-http_flv_module --with-http_realip_module --with-libatomic --with-pcre=../pcre-8.34 --with-pcre-jit --with-http_dav_module --add-module=../nginx-dav-ext-module-0.0.2 --add-module=../ngx-fancyindex-ngx-fancyindex --add-module=../ngx_cache_purge-2.1 --add-module=../nginx-accesskey-2.0.3 --with-openssl=../openssl-1.0.1e --add-module=../nginx-http-concat-master --with-openssl-opt=enable-tlsext
    
    --------------------------------------------------------
    Check PHP-FPM Version:
    --------------------------------------------------------
    PHP 5.3.28 (cli) (built: Jan  5 2014 04:39:49)
    Copyright (c) 1997-2013 The PHP Group
    Zend Engine v2.3.0, Copyright (c) 1998-2013 Zend Technologies
    
    --------------------------------------------------------
    Check MariaDB installed RPM Versions:
    --------------------------------------------------------
    MariaDB-devel-5.5.34-1.i686
    MariaDB-shared-5.5.34-1.i686
    MariaDB-compat-5.5.34-1.i686
    MariaDB-server-5.5.34-1.i686
    MariaDB-client-5.5.34-1.i686
    MariaDB-common-5.5.34-1.i686
    MariaDB-test-5.5.34-1.i686
    
    --------------------------------------------------------
    Check Memcached Server Version:
    --------------------------------------------------------
    memcached 1.4.17
    
    --------------------------------------------------------
    Check CSF Firewall Version:
    --------------------------------------------------------
    csf: v6.39 (generic)
    
    --------------------------------------------------------
    Check Siege Benchmark Version:
    --------------------------------------------------------
    SIEGE 3.0.5
    
    Copyright (C) 2013 by Jeffrey Fulmer, et al.
    This is free software; see the source for copying conditions.
    There is NO warranty; not even for MERCHANTABILITY or FITNESS
    FOR A PARTICULAR PURPOSE.
    
    
    --------------------------------------------------------
    Check ngx_pagespeed Control Script:
    [URL='http://centminmod.com/nginx_ngx_pagespeed.html']ngx_pagespeed install on Centmin Mod - Menu based Nginx installer for CentOS servers[/URL]
    --------------------------------------------------------
    pscontrol handler
    pscontrol edit
    pscontrol on
    pscontrol off
    pscontrol statson
    pscontrol statsoff
    
    --------------------------------------------------------
    Check TwemPerf Version:
    --------------------------------------------------------
    This is mcperf-0.1.1
    
    
    --------------------------------------------------------
    Check mysqlreport version:
    --------------------------------------------------------
    mysqlreport v3.5-maria11 Jul 4 2013
    
    --------------------------------------------------------
    Check NSD Bind Version:
    --------------------------------------------------------
    NSD version 3.2.16
    Written by NLnet Labs.
    
    Copyright (C) 2001-2011 NLnet Labs.  This is free software.
    There is NO warranty; not even for MERCHANTABILITY or FITNESS
    FOR A PARTICULAR PURPOSE.
    
    --------------------------------------------------------
    Check YUM Repo List
    --------------------------------------------------------
    Loaded plugins: downloadonly, fastestmirror, priorities
    Loading mirror speeds from cached hostfile
    * base: lug.mtu.edu
    * epel: mirror.steadfast.net
    * extras: yum.singlehop.com
    * rpmforge: mirror.nexcess.net
    * updates: mirrors.cmich.edu
    1710 packages excluded due to repository priority protections
    repo id         repo name                                            status
    CentALT         CentALT Packages for Enterprise Linux 6 - i386            51+212
    base            CentOS-6 - Base                                         4,791+11
    epel            Extra Packages for Enterprise Linux 6 - i386            8,361+75
    extras          CentOS-6 - Extras                                             12
    mariadb         MariaDB                                                      8+1
    rpmforge        RHEL 6 - RPMforge.net - dag                          3,270+1,455
    updates         CentOS-6 - Updates                                           215
    vz-base         vz-base                                                        3
    vz-updates      vz-updates                                                   1+3
    repolist: 16,712
    
    *************************************************
    * Centmin Mod install completed....
    *************************************************
    
    --------------------------------------------------------
    Please bookmark:
    --------------------------------------------------------
    ###############################################################
    * Getting Started Guide - [URL='http://centminmod.com/getstarted.html']Getting Started with Centmin Mod[/URL]
    * Find the latest Centmin Mod version - [URL='http://centminmod.com']Centmin Mod - Shell Menu based Nginx installer for CentOS servers[/URL]
    * Centmin Mod FAQ - [URL='http://centminmod.com/faq.html']Centmin Mod FAQ - Menu based Nginx installer[/URL]
    * Change Log - [URL='http://centminmod.com/changelog.html']Change Log Centmin Mod - Menu based Nginx installer for CentOS servers[/URL]
    * Google+ Page latest news [URL='http://centminmod.com/gpage']Announcements | Centmin Mod Community[/URL]
    * Google+ Community Forum [URL='http://centminmod.com/gcom']Centmin Mod Community[/URL]
    ###############################################################
    # Cheap VPS Hosting at Digitalocean
    # [URL='https://www.digitalocean.com/?refcode=c1cb367108e8']SSD Cloud Server, VPS Server, Simple Cloud Hosting | DigitalOcean[/URL]
    ###############################################################
    
    ccache stats:
    cache directory                     /home/.ccache
    cache hit (direct)                    70
    cache hit (preprocessed)               0
    cache miss                          3083
    called for link                      250
    called for preprocessing             345
    compile failed                        88
    preprocessor error                    47
    bad compiler arguments                56
    unsupported source language           21
    autoconf compile/link                675
    unsupported compiler option           11
    no input file                        122
    files in cache                      6891
    cache size                         139.9 Mbytes
    max cache size                       2.0 Gbytes
    
    
    Total Centmin Mod Install Time: 8397.706036481 seconds
    
     
    Last edited by a moderator: Mar 24, 2015
  5. eva2000

    eva2000 Administrator Staff Member

    30,196
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,144
    Local Time:
    5:50 PM
    Nginx 1.13.x
    MariaDB 5.5
    what version of Centmin Mod are you using ? nginx 1.5.8 suggests a very old version of Centmin Mod ?

    Auto passwords for MariaDB MySQL wasn't added until Centmin Mod 1.2.3-eva2000.07 stable release History for inc/mysqlsecure.inc - centminmod/centminmod ยท GitHub

    Prior to .07 stable, no Mysql root password was set at all so need to set your mysql root password yourself.

    Edited your post above to wrap output in CODE tags
     
  6. johnnyc

    johnnyc Member

    33
    2
    8
    Mar 23, 2015
    Ratings:
    +2
    Local Time:
    2:50 AM

    Looks like I'm using 06... but "mysql" command says password is invalid?
     
  7. eva2000

    eva2000 Administrator Staff Member

    30,196
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,144
    Local Time:
    5:50 PM
    Nginx 1.13.x
    MariaDB 5.5