Verified based on test plan lxc launch ubuntu:noble test-upgrade-normal lxc file push dist-upgrader_26.04.24_all.tar.gz test-upgrade-normal/root/ lxc exec test-upgrade-normal bash
apt update apt upgrade tar -xvzf dist-upgrader_26.04.24_all.tar.gz cd 26.04.24/ tar -xvzf resolute.tar.gz ./resolute -> upgrade succeeded ---------------------------------------------------- lxc launch ubuntu:noble test-upgrade-mysql-normal lxc file push dist-upgrader_26.04.24_all.tar.gz test-upgrade-mysql-normal/root/ lxc exec test-upgrade-mysql-normal bash apt update apt upgrade apt install mysql-server tar -xvzf dist-upgrader_26.04.24_all.tar.gz cd 26.04.24/ tar -xvzf resolute.tar.gz ./resolute -> upgrade succeeded ---------------------------------------------------- lxc launch ubuntu:noble test-upgrade-mysql-with-plugin-enabled lxc file push dist-upgrader_26.04.24_all.tar.gz test-upgrade-mysql-with-plugin-enabled/root/ lxc exec test-upgrade-mysql-with-plugin-enabled bash apt update apt upgrade apt install mysql-server mysql > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY > 'my_password'; > exit echo "[mysqld]" > /etc/mysql/mysql.conf.d/use-native-password.cnf echo "mysql_native_password" >> /etc/mysql/mysql.conf.d/use-native-password.cnf systemctl restart mysql tar -xvzf dist-upgrader_26.04.24_all.tar.gz cd 26.04.24/ tar -xvzf resolute.tar.gz ./resolute -> upgrade succeeded lxc exec test-upgrade-mysql-with-plugin-enabled bash mysql -p > ---------------------------------------------------- lxc launch ubuntu:noble test-upgrade-mysql-fail lxc file push dist-upgrader_26.04.24_all.tar.gz test-upgrade-mysql-fail/root/ lxc exec test-upgrade-mysql-fail bash apt update apt upgrade apt install mysql-server mysql > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY > 'my_password'; > exit systemctl restart mysql tar -xvzf dist-upgrader_26.04.24_all.tar.gz cd 26.04.24/ tar -xvzf resolute.tar.gz ./resolute Unable to upgrade MySQL The following MySQL accounts use the mysql_native_password authentication plugin, which is disabled by default in the version of MySQL shipped with this release: root@localhost These accounts would be locked out after the upgrade. Please use a separate authentication method for them, such as caching_sha2_password, or explicitly enable mysql_native_password in your MySQL server configuration, then try the upgrade again. For more information, see https://documentation.ubuntu.com/release-notes/26.04/summary-for-lts-users/#mysql ** Tags removed: verification-needed-resolute ** Tags added: verification-done-resolute -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/2158525 Title: mysql root account locked out after upgrade to 26.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu-release-notes/+bug/2158525/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
