MYSQL: [Warning] Using a password on the command line interface can be insecure.

Error:

[root@PROD01 ~]# mysql -uroot -p*******< /root/mysql_dbs_oevent.dump
mysql: [Warning] Using a password on the command line interface can be insecure.
Please use --connect-expired-password option or invoke mysql in interactive mode.
[root@PROD01 ~]#

Solution:

ALTER USER 'root'@'localhost' IDENTIFIED BY '*******';
FLUSH PRIVILEGES;