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;

Abhishek Monday 11 November 2013 - 8:35 pm | | Default
Used tags: , , , , , , , , ,

No comments

(optional field)
(optional field)

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.
« A script to update Mo… | Home | How to enable debuggi… »