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;
Billing Shared CP Support Center |
Billing Reseller CP Support Center |
Billing Shared and Reseller CP Support Center |
Plesk Linux, Windows, Domains |
Virtuozzo VPS Support Center |
Hyper-V VPS Support Center |
Hyper-V VPS Support Center |
![]() |
Customers |
![]() |
Resellers |
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;
No comments