When you need to access a MySQL database, you need an ADO database connection.
It can be set up as follows:
<%
SQLserveradr="[server]"
SQLdatabase="[database]"
SQLlogin="[user name]"
SQLpassword="password"
Set Conn = Server.CreateObject("ADODB.Connection")
conStr = "driver={MySql};server="& SQLserveradr &";database="& SQLdatabase
conStr = conStr & ";uid="& SQLlogin &";pwd="& SQLpassword & ";OPTION=3"
Conn.Open conStr
%>
OPTION - the part of the connection string may vary according to the context in which you need your connection, usually either 3 or 16386 is recommended - read more in the documentation for MySQL's ODBC connector.
Article from the support category: ASP & ASP.NET
We strongly advice you to choose another password
The entered password is known in "Have I Been Pwned", which is a public database of leaked passwords on the internet.
Probably you (or someone else) used the password before on a website, which is known to have leaked the password. It is not safe to use this password.
We strongly advice you to choose another password.
Enter your password here for more information: https://haveibeenpwned.com/Passwords.