trying to upgrade from 10.3.1 to 10.4.4...run the installer and it does a pre check first to see if there are any errors...I do get an error and this is what it tells me...
Parallels Panel pre-upgrade checking...
WARNING: [MYSQL ERROR] Unable to connect database. The reason of problem:
WARNING: [MYSQL ERROR] Unable to connect database. The reason of problem:
WARNING: [MYSQL ERROR] Unable to connect database. The reason of problem:
WARNING: Unable to connect to local default MySQL server. Read carefully article http://kb.parallels.com/en/111983 for details.
so i check the knowladge base it tells me....and i run this command:
C:\Program Files\Parallels\Plesk\admin\bin>dbclient.exe --direct-sql --sql="select * from databaseservers where type='mysql' and host='localhost'"
i get my username and password from it
then i run this command:
"%plesk_bin%\dbclient.exe" --direct-sql --sql="Update databaseservers set admin_login='<MySQL user name>', admin_password='<type password here>' where host='localhost' and type='mysql'"
this command also works
now when i type this command:
%plesk_dir%Databases\MySQL\bin\mysql.exe" -uadmin -p<password> -hlocalhost
i get access denied with the password from the first command i did....
now when i type back the last command which is %plesk_dir%Databases\MySQL\bin\mysql.exe" -uadmin -p<password> -hlocalhost
i can log in with admin username and the password is my password to my local administrator password to my windows server am able to get in
so the problem is my passwords are 2 differnet passwords altogether the output from the command i used to retrive is different from the login to mysql.exe when i run it...and i think thats why the plesk upgrading is failing
can anyone help me on this?
thanks
Parallels Panel pre-upgrade checking...
WARNING: [MYSQL ERROR] Unable to connect database. The reason of problem:
WARNING: [MYSQL ERROR] Unable to connect database. The reason of problem:
WARNING: [MYSQL ERROR] Unable to connect database. The reason of problem:
WARNING: Unable to connect to local default MySQL server. Read carefully article http://kb.parallels.com/en/111983 for details.
so i check the knowladge base it tells me....and i run this command:
C:\Program Files\Parallels\Plesk\admin\bin>dbclient.exe --direct-sql --sql="select * from databaseservers where type='mysql' and host='localhost'"
i get my username and password from it
then i run this command:
"%plesk_bin%\dbclient.exe" --direct-sql --sql="Update databaseservers set admin_login='<MySQL user name>', admin_password='<type password here>' where host='localhost' and type='mysql'"
this command also works
now when i type this command:
%plesk_dir%Databases\MySQL\bin\mysql.exe" -uadmin -p<password> -hlocalhost
i get access denied with the password from the first command i did....
now when i type back the last command which is %plesk_dir%Databases\MySQL\bin\mysql.exe" -uadmin -p<password> -hlocalhost
i can log in with admin username and the password is my password to my local administrator password to my windows server am able to get in
so the problem is my passwords are 2 differnet passwords altogether the output from the command i used to retrive is different from the login to mysql.exe when i run it...and i think thats why the plesk upgrading is failing
can anyone help me on this?
thanks