[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

[Norvald H. Ryeng]

On Tue, 29 Nov 2016 08:40:23 +0800
積丹尼 Dan Jacobson <jidanni at jidanni.org> wrote:

> Now I got as far as
> 
> echo "ALTER USER 'wikiuser'@'localhost.localdomain' IDENTIFIED BY
> '-[censored]-';"|mysql --user=root --password=-[censored]-; sleep 1
> mysql: [Warning] Using a password on the command line interface can
> be insecure. ERROR 1396 (HY000) at line 1: Operation ALTER USER
> failed for 'wikiuser'@'localhost.localdomain' echo "ALTER USER
> 'jidanni'@'%' IDENTIFIED BY '-[censored]-';"|mysql --user=root
> --password=-[censored]-; sleep 1 mysql: [Warning] Using a password on
> the command line interface can be insecure. ERROR 1396 (HY000) at
> line 1: Operation ALTER USER failed for 'jidanni'@'%'

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

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

Regards,

Norvald H. Ryeng