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
>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 Ub
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,
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 in
** 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 noti