I was going to add this to NEWS.Debian but missed it in my last upload -
sorry.
> The problem is the new feature of mysql-server that generates a
temporary password.
I think it's something else - please see below. Based on this, you
should be able to change the root password to something non-empty with
"sudo dpkg-reconfigure mysql-server-5.7" and then logging in as a non-
root user should work. Alternatively, you should be able to log in as
the mysql root user that has an empty password if you run the client as
Unix root (eg. with sudo).
Please could you confirm if this works for you?
Intended NEWS.Debian next:
Password behaviour when the MySQL root password is empty has
changed. Packaging now enables socket authentication when the MySQL root
password is empty. This means that a non-root user can't log in as root
with an empty password. The new logic is as follows:
The auth_socket plugin will be installed automatically only if it is
to be activated for the root user.
The auth_socket plugin will be activated for the root user:
If you had a database before with an empty root password.
If you create a new database with an empty root password.
The auth_socket plugin WILL NOT be activated for the root user:
If you had a database before with a root password set.
If you create a new database with a root password set.
The auth_socket plugin WILL NOT be activated for any other user.
If you do not want the new behaviour, simply set the MySQL root
password to be non-empty.
The MySQL server now uses strict mode by default. See
http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-strict for
details. See http://dev.mysql.com/doc/refman/5.6/en/sql-mode.html#sql-
mode-setting for details about the default settings in older versions.
--
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
