Unable to connect to MySQL

[tgtcat6]

I've upgraded to 11, but when I try and apply updates, I'm getting

WARNING: Unable to connect to local default MySQL server. Read carefully article http://kb.parallels.com/en/111983 for details.

I've followed the directions in the KB mentioned, but haven't had any luck yet.

Am I missing something?

 

[IgorG]

But can you connect to MySQL server with command

%plesk_dir%Databases\MySQL\bin\mysql.exe" -uadmin -p<password> -hlocalhost

?

 

[tgtcat6]

I can sort of connect, but when it prompts for the admin password, it just doesn't work

ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password:
YES)

I've double checked the admin password with the select command located in that article; I've even been able to change the admin password, but that hasn't allowed me to actually connect

 

[MansurE]

Same Problem

I recive the Same problem.
As mentioned in the KB http://kb.parallels.com/en/111983

I am able to connect the DB via mysql.exe" -uadmin -p<password> -hlocalhost

Executing the following command I get as expected the following Response:
dbclient.exe --direct-sql --sql="select * from databaseservers where type='mysql' and host='localhost'"

1 localhost 3306 mysql 5.1.48 admin <password> 0
no_error


Even when I try to reset the Passwort with the following Command I recive the Error while Updateing:
dbclient.exe --direct-sql --sql="Update databaseservers set admin_login='admin', admin_password='<password>' where host='localhost' and type='mysql'"

I also tryed to retype the Passwort via the Plesk Frontend - Databaseserver - Tool

 

[MansurE]

Possible Solution

In my Installation there are two MySQL installations on the Server.
On Ports 3306 and 8306

After setting the Databaselogin to the following it worked:
User: admin
Passwort: The regular PLESK Password (The Panellogin Password)

May it helps

 

[tgtcat6]

Yeah, it looks like I have MySQL 4.1 and 5.0

Which one should I be using?

 

[MansurE]

I mean the 4.1 MySQL is the one Plesk uses as an internal Database (Plus PHP4).
In there the Password is also stored.

The MySQL 5.x is the Customerdatabase and - what I reccon - should have the same Connection settings as the Plesk Login. You should keep that one for the Customers, because 5.x is the regular version nowadays.

User this article:
http://kb.parallels.com/en/111983

and update the Data not on the Database connected on the 3306 Port. Instead update the Data on the 8306-Port - Database.

Just suggestion ... it helped me for that problem, but still I cant download Licencekey and Updates ...
Thatfor I investigate more in an another Thread with no help from others till now.

 

[tgtcat6]

Yeah, I've already tried that KB article, that hasn't helped me

 

[InderS]

With plesk 11 you should go for mysql 5 and have you checked the error logs of mysql?