On 3/17/20 8:52 PM, Stefan Seyfried wrote:
Am 16.03.20 um 14:44 schrieb Stefan Seyfried:
Am 16.03.20 um 14:05 schrieb Stefan Seyfried:
Am 16.03.20 um 13:56 schrieb Cristian Rodríguez:
Ditto, I still have a server with hosed mysql authentication.. happended in tumblweed too.. unfortunately I have not been able to completely shut it down for a few hours to do a full restore.. so it is running with skip-grant-tables and no networking whatsoever. apparently the mysql authentication tables ends with no users in, not even root..
OK, I'll open a bug to get this started.
JFTR, this is https://bugzilla.opensuse.org/show_bug.cgi?id=1166781
bugzilla (or the microfocus login site) is semui-down, so let's report here.
I could reproduce this, by restoring the 15.1 filesystem into a VM and running the 15.2 update again.
opensuse-test:~ # mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
So I have a test system available in broken state ready for examination :-)
I have database backups, yeah, but I 'll prefer not to restore them and fix the authentication issue instead.
I am very far from an expert in this area but from what I was reading the other day I believe that the change here is security related which is to follow upstream in no longer allowing the root user access to databases. I believe there are plans to include a post install message with this information but we should also make sure the change is well documented in the release notes. I hope this helps. -- Simon Lees (Simotek) http://simotek.net Emergency Update Team keybase.io/simotek SUSE Linux Adelaide Australia, UTC+10:30 GPG Fingerprint: 5B87 DB9D 88DC F606 E489 CEC5 0922 C246 02F0 014B