Discover Centmin Mod today
Register Now

MariaDB Unable to upgrade mariaDB from 10.0.x to 10.1.x

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Andy, Mar 21, 2017.

  1. Andy

    Andy Active Member

    281
    42
    28
    Aug 6, 2014
    Ratings:
    +49
    Local Time:
    12:31 AM
    Any reason I got this error?

    Do you want to continue with upgrade to MariaDB 10.1.x ? [y/n] y

    checking mysql root password works in /root/.my.cnf
    mysqladmin ver
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: YES)'

    mysql root user password in /root/.my.cnf is not correct
    Aborting MariaDB 10.1.x upgrade...
     
  2. eva2000

    eva2000 Administrator Staff Member

    29,037
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,784
    Local Time:
    2:31 PM
    Nginx 1.13.x
    MariaDB 5.5
    did you change your mysql root password in the past ? if you did, you need to also update /root/.my.cnf with the new mysql root password

    from MariaDB MySQL - CentminMod.com LEMP Nginx web stack for CentOS

     
  3. Andy

    Andy Active Member

    281
    42
    28
    Aug 6, 2014
    Ratings:
    +49
    Local Time:
    12:31 AM
  4. eva2000

    eva2000 Administrator Staff Member

    29,037
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,784
    Local Time:
    2:31 PM
    Nginx 1.13.x
    MariaDB 5.5
    changing root password isn't a simple process as outlined at http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html so you would of remembered if you did change root passwords :)

    if you don't remember the mysql root password, you'd just have to change it again and be sure to update /root/.my.cnf with whatever new mysql root password you changed to
     
  5. Andy

    Andy Active Member

    281
    42
    28
    Aug 6, 2014
    Ratings:
    +49
    Local Time:
    12:31 AM
    Hum, maybe you did change it when you helped me recover the site from a back up? It's been a while since you did that.
     
  6. eva2000

    eva2000 Administrator Staff Member

    29,037
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,784
    Local Time:
    2:31 PM
    Nginx 1.13.x
    MariaDB 5.5