[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