[Bug 2168920] Re: LTS update fails on mysql_native_password check

** Information type changed from Private Security to Public Security -- You received this bug notification because you are subscribed to linux in Ubuntu. Matching subscriptions: Bgg, Bmail, Nb https://bugs.launchpad.net/bugs/2168920 Title: LTS update fails on mysql_native_password check Status in linux package in Ubuntu: New Bug description: LTS update suggests changing mysql_native_password to caching_sha2_password then fails. After setting default_authentication_plugin=caching_sha2_password AND changing old users to caching_sha2_password, flush privileges AND restarting mysql two mysql built in users remain stuck with mysql_native_password. Users mysql.session and mysql.sys which are locked by mysql, mysql documentation say they will migrate when mysql is updated. Unfortunately the LTS update is blocked because of the check fo any mysql user still on mysql_native_password.... Mysql and net searches provide no means of manually changing those to caching_sha2_password. ProblemType: Bug DistroRelease: Ubuntu 24.04 Package: linux-image-6.8.0-142-generic 6.8.0-142.142 ProcVersionSignature: Ubuntu 6.8.0-142.142-generic 6.8.12 Uname: Linux 6.8.0-142-generic x86_64 NonfreeKernelModules: nvidia_modeset nvidia ApportVersion: 2.28.3-0ubuntu0.1 Architecture: amd64 AudioDevicesInUse: USER PID ACCESS COMMAND /dev/snd/controlC1: atuttle 3946 F.... wireplumber /dev/snd/controlC0: atuttle 3946 F.... wireplumber /dev/snd/seq: atuttle 3942 F.... pipewire CasperMD5CheckResult: unknown CurrentDesktop: KDE Date: Tue Sep 29 15:53:15 2026 HibernationDevice: RESUME=/dev/nvme0n1p3 InstallationDate: Installed on 2018-11-17 (2873 days ago) InstallationMedia: Ubuntu-Server 18.04.1 LTS "Bionic Beaver" - Release amd64 (20180725) IwConfig: lo no wireless extensions. eno1 no wireless extensions. MachineType: Gigabyte Technology Co., Ltd. B450 AORUS ELITE ProcEnviron: LANG=en_US.UTF-8 LANGUAGE=en_US:en PATH=(custom, no user) SHELL=/bin/bash TERM=xterm-256color ProcFB: 0 simpledrmdrmfb ProcKernelCmdLine: BOOT_IMAGE=/boot/vmlinuz-6.8.0-142-generic root=UUID=01736369-094d-46a1-bdf5-ea9657dbb6ef ro PulseList: Error: command ['pacmd', 'list'] failed with exit code 1: No PulseAudio daemon running, or not running as session daemon. RelatedPackageVersions: linux-restricted-modules-6.8.0-142-generic N/A linux-backports-modules-6.8.0-142-generic N/A linux-firmware 20240318.git3b128b60.0ubuntu3.1 RfKill: SourcePackage: linux UpgradeStatus: Upgraded to noble on 2026-09-29 (0 days ago) dmi.bios.date: 10/28/2025 dmi.bios.release: 5.17 dmi.bios.vendor: American Megatrends International, LLC. dmi.bios.version: F67 dmi.board.asset.tag: Default string dmi.board.name: B450 AORUS ELITE dmi.board.vendor: Gigabyte Technology Co., Ltd. dmi.board.version: Default string dmi.chassis.asset.tag: Default string dmi.chassis.type: 3 dmi.chassis.vendor: Default string dmi.chassis.version: Default string dmi.modalias: dmi:bvnAmericanMegatrendsInternational,LLC.:bvrF67:bd10/28/2025:br5.17:svnGigabyteTechnologyCo.,Ltd.:pnB450AORUSELITE:pvrDefaultstring:rvnGigabyteTechnologyCo.,Ltd.:rnB450AORUSELITE:rvrDefaultstring:cvnDefaultstring:ct3:cvrDefaultstring:skuDefaultstring: dmi.product.family: B450 MB dmi.product.name: B450 AORUS ELITE dmi.product.sku: Default string dmi.product.version: Default string dmi.sys.vendor: Gigabyte Technology Co., Ltd. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/linux/+bug/2168920/+subscriptions