Upgrading MySQL

[mike0c]

I received a scanalert/hackersafe warning that we need to upgrade MySQL to the latest version. Is this straightforward to do? I notice that there seem to be two MySQL databases: Plesk\Databases\MySQL and \Plesk\MySQL. Do they both need updating? I've also noted in other threads a mention of a MySQL 5 update script, to 'fix permissions' Is this straightforward as well?

 

[Bender]

Hi,

You can upgrade MySql that is used for clients databases(located in Databases\MySQL) as described in this article:

http://kb.swsoft.com/en/1077

MySql instance located in Plesk\MySQL is used for Plesk database itself and it is not suggested to upgrade it to 5 version.

Anyway, it is not available for external connections.

 

[mike0c]

Thanks for the response, is it possible to block the client MySQL for external connections, as none of the Clients are using it?

 

[Bender]

Hi,

You can just block connections to 3306 port with firewall.