/ Register

Join the community 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.

Previous Thread Next Thread
Loading...
  1. Mar 21, 2017 #1
    Andy

    Andy Active Member

    544
    89
    28
    Aug 6, 2014
    Ratings:
    +133
    Local Time:
    4:52 PM
    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. Mar 21, 2017 #2
    eva2000

    eva2000 Administrator Staff Member

    55,155
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    7:52 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Mar 29, 2017 #3
    Andy

    Andy Active Member

    544
    89
    28
    Aug 6, 2014
    Ratings:
    +133
    Local Time:
    4:52 PM
  4. Mar 29, 2017 #4
    eva2000

    eva2000 Administrator Staff Member

    55,155
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    7:52 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Mar 29, 2017 #5
    Andy

    Andy Active Member

    544
    89
    28
    Aug 6, 2014
    Ratings:
    +133
    Local Time:
    4:52 PM
    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. Mar 29, 2017 #6
    eva2000

    eva2000 Administrator Staff Member

    55,155
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    7:52 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  7. Sep 30, 2017 #7
    Andy

    Andy Active Member

    544
    89
    28
    Aug 6, 2014
    Ratings:
    +133
    Local Time:
    4:52 PM
    All done. Thank you.
     
    Last edited: Sep 30, 2017
Previous Thread Next Thread
Loading...

.