Learn about Centmin Mod LEMP Stack today
Register Now

MariaDB what is default MySQL root password ?

Discussion in 'Centmin Mod Insights' started by wahyuway, Jul 16, 2014.

  1. wahyuway

    wahyuway New Member

    2
    0
    1
    Jul 16, 2014
    Ratings:
    +0
    Local Time:
    7:29 PM
    1.7.2
    MariaDB 5.5
    hi, i have diffculty to access mysql. I use the #1 option to install centminmod. What are the default password for mysql? i had changed the conf in /root/.my.cnf but still got access denied to access mysql
    Thanks

     
  2. eva2000

    eva2000 Administrator Staff Member

    54,523
    12,211
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,780
    Local Time:
    10:29 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    @wahyuway For Centmin Mod 1.2.3-eva2000.07 releases, the default mysql root password is the one listed in /root/.my.cnf

    changing the password in /root/.my.cnf won't change you're actual mysql root password you have to do that via methods outlined at http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html and http://www.cyberciti.biz/faq/mysql-change-root-password/. Then afterwards, update /root/.my.cnf with your new mysql root password.

    the /root/.my.cnf only allows mysql client commands via SSH without the mysql user and password prompts by reading the existing or newly set mysql root passwords.