Pages

Monday 11 February 2013

ERROR while trying to upgrade MySQL password format for Billing user.

Upgrade failed with below error:
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table


ERROR while trying to upgrade MySQL password format for Billing user
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again
Such error occurs if the password for "billing" user is missing in the psa database. To fix it,
------
#insert into `user` (Host,User,Password) values ('localhost', 'billing', 'password');


#echo 'SET PASSWORD FOR "billing"@"localhost" = PASSWORD("password")'|mysql -uadmin -p`cat /etc/psa/.psa.shadow`


#echo 'GRANT ALL PRIVILEGES ON `billing`.* TO "billing"@"localhost";' | mysql -uadmin -p`cat /etc/psa/.psa.shadow`
------

No comments:

Post a Comment