show tables; Tables_in_mysql columns_priv db func help_category help_keyword help_relation help_topic host proc tables_priv time_zone time_zone_leap_second time_zone_name time_zone_transition time_zone_transition_type user show tables; Tables_in_test grant ALL on *.* to test@localhost identified by "gambling"; grant ALL on *.* to test@127.0.0.1 identified by "gambling"; show tables; Tables_in_mysql columns_priv db func help_category help_keyword help_relation help_topic host proc tables_priv time_zone time_zone_leap_second time_zone_name time_zone_transition time_zone_transition_type user show tables; Tables_in_test update mysql.user set password=old_password("gambling2") where user=_binary"test"; flush privileges; set password=""; set password='gambling3'; ERROR HY000: Password hash should be a 41-digit hexadecimal number set password=old_password('gambling3'); show tables; Tables_in_mysql columns_priv db func help_category help_keyword help_relation help_topic host proc tables_priv time_zone time_zone_leap_second time_zone_name time_zone_transition time_zone_transition_type user show tables; Tables_in_test delete from mysql.user where user=_binary"test"; flush privileges;