MySQL user creation / secure_auth errors

mysql_user_create_secure_auth

mysql> create user 'user'@'host_fqdn_or_ip' identified by 'secret_password';
Query OK, 0 rows affected (0.07 sec)

mysql> grant select on database_name.* to 'user'@'host_fqdn_or_ip';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)

mysql> set session old_passwords=0; set password for 'user'@'host_fqdn_or_ip' = password('secret_password');

Last command is neeed if client errors out with authentication problems ( client option secure_auth enabled )