MySQL problem

[topws]

hi,
When i try to create a MySQL database from Plesk, i get the following error:

Unable to create database: Create new database failed: Run-Time error: Failed to connect to database: Can't connect to MySQL server on 'localhost' (10061)


The error in the <server>.err file says that:


051011 19:02:27 InnoDB: Starting shutdown...
051011 19:02:29 InnoDB: Shutdown completed; log sequence number 0 43634
051011 19:02:29 [Note] C:\Program Files\SWsoft\Plesk\Databases\MySQL\bin\mysqld-nt.exe: Shutdown complete

Please tell me the solution.

 

[alpha_xs]

Same problem here...

Same action, same troubles.

Did laready try to update mysql.
Unfortantly no luck wtih that.

 

[Gris@]

SwSoft has article how to upgrade MySQL
http://kb.swsoft.com/article_147_1077_en.html

 

[knocx]

you are possibly compromised because of a vulnerability in Plesk MySQL version "Drop Temporary Tables"

Plesk for windows 7.5.6 is vulnerable, you should apply the patch for 7.5.6 same happened to us, scan your processes you will find a trojan probably.

Check if dameware is also installed

regards
knocx

 

[topws]

i solved the problem. i just reinstalled the MySQL and set the crediatials in pleask for MySQL and thats it. It is running very well.

 

[steve009]

I am aslo facing similar Innodb issue

Hi,

In My server also Mysql getting stop. Below is the error shows on the mysql.err file. Please kindly help me. When this happens i am unable to start or stop the Mysql service. Unless untill i will restart the server i am not able to use the mysql service. I hae doubt about 'mesasarc@%', due to this user the database is getting stopped.If you see the below logs you can understand. How to check the running loggs for mysql on windows. What will be path of error log file.

Pls find the below error log

070626 23:42:58 InnoDB: Starting shutdown...
070626 23:43:02 InnoDB: Shutdown completed; log sequence number 0 1052086193
070626 23:43:02 [Note] C:\Program Files\SWsoft\Plesk\Databases\MySQL\bin\mysqld-nt.exe: Shutdown complete


completed; log sequence number 0 979052605
070618 1:17:50 [Note] C:\Program Files\SWsoft\Plesk\Databases\MySQL\bin\mysqld-nt.exe: Shutdown complete

070618 1:20:16 [Warning] Found invalid password for user: 'mesasarc@%'; Ignoring user
C:\Program Files\SWsoft\Plesk\Databases\MySQL\bin\mysqld-nt.exe: ready for connections.
Version: '4.1.7-nt' socket: '' port: 3306 Source distribution

070619 13:08:03 [Warning] Found invalid password for user: 'mesasarc@%'; Ignoring user
070621 5:32:19 [Note] C:\Program Files\SWsoft\Plesk\Databases\MySQL\bin\mysqld-nt.exe: Normal shutdown