[debian-mysql] 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 Sat, 26 Nov 2016 00:00:53 +0800
積丹尼 Dan Jacobson <jidanni at jidanni.org> wrote:

> NHR> SELECT * FROM mysql.user WHERE LENGTH(password) = 16;  
> 
> ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where
> clause'
> 
> in fact there is only
> 
> Host User Select_priv Insert_priv Update_priv Delete_priv Create_priv
> Drop_priv Reload_priv Shutdown_priv Process_priv File_priv Grant_priv
> References_priv Index_priv Alter_priv Show_db_priv Super_priv
> Create_tmp_table_priv Lock_tables_priv Execute_priv Repl_slave_priv
> Repl_client_priv Create_view_priv Show_view_priv Create_routine_priv
> Alter_routine_priv Create_user_priv Event_priv Trigger_priv
> Create_tablespace_priv ssl_type ssl_cipher x509_issuer x509_subject
> max_questions max_updates max_connections max_user_connections plugin
> authentication_string password_expired password_last_changed
> password_lifetime account_locked
> 
> there.

Sorry, my mistake. I copied a query out of mysql_upgrade, but I forgot
that the upgrade script modifies the table afterwards. Try this:

SELECT * FROM mysql.user WHERE plugin = '';

Regards,

Norvald