To fix the issue please follow below steps.
1. First backup your MySQL database-
mysqldump mysql > /root/mysql.sql
2. The we have to alter the database column order. You can do it by running below command.
mysql -e "ALTER TABLE mysql.user MODIFY COLUMN password_last_changed timestamp AFTER max_statement_time, MODIFY COLUMN password_lifetime smallint AFTER password_last_changed, MODIFY COLUMN account_locked enum('N','Y') AFTER password_lifetime"
3. Then restart the MySQL
/scripts/restartsrv_mysql
or,
service mysqld restart
