>>>>> "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'