[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 jidanni at jidanni.org
Fri Nov 25 16:00:53 UTC 2016


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.



More information about the pkg-mysql-maint mailing list