Public bug reported: If you have a mysql database with an empty root password (like we have here for development purpose) with mysql 5.6, with the upgrade to 16.04 you'll find yourself locked out on mysql 5.7
The problem is the new feature of mysql-server that generates a temporary password. Unfortunately, this password is not recorded anywhere, neither in a .mysql_secret file (if the deprecated mysql_install_db script would've been used) which is nowhere on the filesystem, nor in the mysql logs. (Like instead it is on Windows or Red Hat, apparently). The only solution (aside from wiping the db, and selecting a new password at install time), is to follow the instructions to reset permissions: http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html?acf=1 (but you won't be able to simply use the --init-file option, due to the apparmor sandboxing of mysqld) I attached a simple terminal session that demonstrates the issue ProblemType: Bug DistroRelease: Ubuntu 16.04 Package: mysql-server 5.7.11-0ubuntu6 ProcVersionSignature: Ubuntu 4.4.0-17.33-generic 4.4.6 Uname: Linux 4.4.0-17-generic x86_64 ApportVersion: 2.20.1-0ubuntu2 Architecture: amd64 CurrentDesktop: Unity Date: Mon Apr 18 14:34:46 2016 InstallationDate: Installed on 2016-03-07 (42 days ago) InstallationMedia: Ubuntu 16.04 LTS "Xenial Xerus" - Alpha amd64 (20160304) Logs.var.log.daemon.log: MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf: [mysqld_safe] syslog MySQLVarLibDirListing: False PackageArchitecture: all SourcePackage: mysql-5.7 UpgradeStatus: No upgrade log present (probably fresh install) ** Affects: mysql-5.7 (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apparmor apport-bug xenial ** Attachment added: "sessionlog" https://bugs.launchpad.net/bugs/1571668/+attachment/4639266/+files/sessionlog -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1571668 Title: Mysql upgrade locks out its root user To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1571668/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
