[Bug 1610574] Re: mysql_secure_installation locks out root database user
If you don't specify the user it'll just use the username you run the command as (so root, with sudo). As noted you should be able to work around the bug with ALTER USER, i.e. running: sudo mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY 'passphrase';" on the command line -- 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
[Bug 1610574] Re: mysql_secure_installation locks out root database user
>After running secure_installation, can you still log in with «sudo >mysql» with no password or user specified? I succeeded with "sudo mysql -u root". I did not try it with no user specified. -- 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
[Bug 1610574] Re: mysql_secure_installation locks out root database user
This is related to a bug in mysqladmin failing to properly set the password for an account with auth_socket enabled: http://bugs.mysql.com/bug.php?id=81965 (I'm not sure if secure_installation uses mysqladmin or if it's just the same logic). When installing the package with an empty root password, the root user will have unix socket authentication enabled, so only the system root user can log in as root. To set a password, the auth plugin must also be reset to mysql_native_password, i.e. with «ALTER USER 'root'@'localhost' IDENTIFIED BY 'passphrase' WITH 'mysql_native_password';» After running secure_installation, can you still log in with «sudo mysql» with no password or user specified? Also note that mysql_secure_installation is largely redundant for a fresh 5.7 installation; The only feature 5.7 doesn't set by default is the password validation plugin. ** Bug watch added: MySQL Bug System #81965 http://bugs.mysql.com/bug.php?id=81965 -- 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
[Bug 1610574] Re: mysql_secure_installation locks out root database user
FYI, if you have any difficulty reproducing this issue, I actually
installed the mysql-server package using Puppet (version 3.8.5), not
manually with apt-get. The puppet manifest file contains simply:
package { 'mysql-server':
ensure => 'installed',
}
To run it, simply place the above lines into a file (say) "build.pp" and run
this puppet command:
$ sudo puppet apply build.pp
I suspect this may be relevant.
** Description changed:
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:
+ Steps to reproduce this issue 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
--
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
[Bug 1610574] Re: mysql_secure_installation locks out root database user
** Changed in: mysql-5.7 (Ubuntu) Importance: Undecided => High -- 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
