Public bug reported: Install the 16.04 package mysql-server and immediately run mysql_secure_installation to set the root database password. When complete, the root database password you chose doesn't work. You are locked out from mysql.
Steps reproduce on a fresh Xenial system: 1. sudo apt-get install mysql-server 2. sudo mysql_secure_installation 3. Respond to the questions: - Validate password plugin? No - New password: foobarblat - Re-enter new password: foobarblat - Remove anonymous users? Y - Disallow root login remotely? Y - Remove test database and access to it? Y - Reload privilege tables now? Y 4. mysql -p -u root Enter password: foobarblat ERROR 1698 (28000): Access denied for user 'root'@'localhost' Other people have encountered the same problem: http://askubuntu.com/questions/766334/cant-login-as-mysql-user-root-from-normal-user-account-in-ubuntu-16-04 ** Affects: mysql-5.7 (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1610574 Title: mysql_secure_installation locks out root database user To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1610574/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs