Symptoms
-
An attempt to connect to the MySQL database from ASP/ASP.NET/PHP scripts fails:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 5: Access is denied. (MySQL ODBC 5.1 Driver, C:Program Files (x86)MySQLConnector ODBC 5.1myodbc5.dll). -
Both 32-bit and 64-bit versions of MySQL ODBC Connector are installed:
C:>wmic product | findstr ODBC
{726FBDBD-02AA-479C-9016-807D20DD4B41} MySQL Connector/ODBC 5.3 mysql-connector-odbc-5.3.9-winx64.msi
{8A2B7DC6-48EC-4B6C-9911-76A7E4AF94A3} MySQL Connector/ODBC 5.3 mysql-connector-odbc-5.3.9-win32.msi
Cause
Plesk bug with ID #PPPM-8044 fixed in Plesk Obsidian on August 28th, 2018 (fixed as PPP-35368, Windows).
Resolution
Upgrade to the latest Plesk version.
If update is not possible for some reason, try the following
temporary solution
Note: if you don’t have administrative access to Plesk server via RDP, contact your hosting provider regarding the issue
As a workaround:
-
Connect to the server via RDP.
-
Download the attached file
mysql-odbc.zip
 and open/unzip it. -
Move the downloaded file to the
%plesk_dir%etcDiskSecurity
folder. - Apply the new security settings (thecommand may take much time, be patient):
C:> “C:Program Files (x86)Pleskadminbin64applysecurity.exe” –apply
Video tutorial:
Â
Â
Â