MySQL 5.7.11 mysql_secure_installation don't work -

linux version: ubuntu 14.04.1 lts server version: 5.7.11 mysql community server (gpl) download link below: http://dev.mysql.com/downloads/repo/apt/

when try run mysql_secure_installation set password , reload tasks done. when try login mysql, doesn't require password root user.

>>>mysql    mysql> select * user; +-----------+-----------+-------------+-------------+-------------+----    ---------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+ | 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 | +-----------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+ | localhost | root      | y           | y           | y           | y           | y           | y         | y           | y             | y            | y         | y          | y               | y          | y          | y            | y          | y                     | y                | y            | y               | y                | y                | y              | y                   | y                  | y                | y          | y            | y                      |          |            |             |              |             0 |           0 |               0 |                    0 | auth_socket           |                                           | n                | 2016-02-08 15:54:07   |              null | n              | | localhost | mysql.sys | n           | n           | n           | n           | n           | n         | n           | n             | n            | n         | n          | n               | n          | n          | n            | n          | n                     | n                | n            | n               | n                | n                | n              | n                   | n                  | n                | n          | n            | n                      |          |            |             |              |             0 |           0 |               0 |                    0 | mysql_native_password | *thisisnotavalidpasswordthatcanbeusedhere | n                | 2016-02-08 15:54:08   |              null | y              | +-----------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+ 2 rows in set (0.00 sec) 

without password require ?

i don't know why?

i think problems should mysql.user in column plugin, variable name auth_socket.

https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html https://dev.mysql.com/doc/mysql-security-excerpt/5.5/en/socket-authentication-plugin.html

if want change authentication of mysql user, please follow steps in below.

alter user 'root'@'localhost' identified mysql_native_password; alter user 'root'@'localhost' identified 'password'; flush privileges; 

that's should work.