[debian-mysql] Bug#845648: Bug#845648: mention how to deal with Pre-4.1 password hash found. It is deprecated and will be removed in a future release. Please upgrade it to a new format warning

[積丹尼 Dan Jacobson]

>>>>> "NHR" == Norvald H Ryeng <norvald.ryeng at oracle.com> writes:

NHR> I think you need to specify the authentication plugin for those users,
NHR> e.g., "mysql_native_password".

NHR> Please read http://dev.mysql.com/doc/refman/5.7/en/alter-user.html for
NHR> details about the ALTER USER command.

Well it says

The default plugin is mysql_native_password unless the
default_authentication_plugin system variable is set otherwise.

Still

ALTER USER 'wikiuser'@'localhost.localdomain' IDENTIFIED WITH mysql_native_password BY '...';
ERROR 1396 (HY000) at line 1: Operation ALTER USER failed for 'wikiuser'@'localhost.localdomain'

and aren't these the ones
WHERE plugin != ''

OK now trying

ALTER USER 'wikiuser'@'localhost.localdomain' IDENTIFIED WITH '' BY '...';"
ERROR 1396 (HY000) at line 1: Operation ALTER USER failed for 'wikiuser'@'localhost.localdomain'