>>>>> "NHR" == Norvald H Ryeng <norvald.ry...@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'

Reply via email to