SQL query to set/update the MySQL user password in the old style

The following query can be used to set/update the MySQL user password in the old style:-

SET PASSWORD FOR ‘user’@’%’=OLD_PASSWORD(‘password’);
FLUSH Privileges;

]]>