Applicable to:
- Plesk Onyx 17.5 for Windows
Symptoms
-
An attempt to connect to the MySQL database from ASP/ASP.NET/PHP scripts fails:
CONFIG_TEXT: 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)\MySQL\Connector ODBC 5.1\myodbc5.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 followingNote: 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%etc\DiskSecurity
folder. - Apply the new security settings (thecommand may take much time, be patient):
C:\> "C:\Program Files (x86)\Plesk\admin\bin64\applysecurity.exe" --apply
Video tutorial:
Comments
3 comments
step 4 is incorrect as adding > after bin64 would cause an error. replace > with \ and remove the space.
@Christopher Danks
Hello!
Thank you for notice.
The article was updated.
Hi
i add only ( Unicode Driver ) in connection string and problem resolved
Change this :
Conn.Open "DRIVER={MySQL ODBC 5.3 };SERVER=localhost; DATABASE=psa; UID=admin;PASSWORD=mypassword;Port=8306; OPTION=3"
To :
Conn.Open "DRIVER={MySQL ODBC 5.3 Unicode Driver};SERVER=localhost; DATABASE=psa; UID=admin;PASSWORD=mypassword;Port=8306; OPTION=3"
Best Regards
Masoud Saeidi
http://www.esfahanhost.com
Please sign in to leave a comment.