SuperCrazyMark
New Pleskian
Hello,
I want to write an ASP script to connect to the Plesk MySql database so I can read my client info etc to be displayed in our custom written Account pages (hopefully to be able to read & write so clients can view/amend their account details from our pages).
I have found the following connection script:
It seems to connect without errors but when I try and query the MySql database I get the following error:
Is there another admin user I need to use to be able to connect to the actual Plesk MySql database?
Any help would be much appreciated.
-Mark
I want to write an ASP script to connect to the Plesk MySql database so I can read my client info etc to be displayed in our custom written Account pages (hopefully to be able to read & write so clients can view/amend their account details from our pages).
I have found the following connection script:
Code:
<%
Dim sConnection, objConn , objRS
sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=mysqld; UID=admin;PASSWORD=++My admin password++; OPTION=3"
Set objConn = Server.CreateObject("ADODB.Connection")
%>
It seems to connect without errors but when I try and query the MySql database I get the following error:
HTML:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver]Access denied for user 'admin'@'localhost' (using password: YES)
Is there another admin user I need to use to be able to connect to the actual Plesk MySql database?
Any help would be much appreciated.
-Mark