Knowledge Base

Connection to MySQL database fails: Specified driver could not be loaded due to system error 5: Access is denied. (MySQL ODBC 5.1 Driver)

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: