MySQL Connection String

[cornerpilot]

Despite reading a couple of other similar posts & solutions, I'm still having problems connecting from my pc to the remote MySQL database.

The following is a repeesentation of my connection string (VBA - a similar one works fine for my local db on localhost):

strConn = "DRIVER={MySQL ODBC 5.1 Driver};" & _
"Server=whatgoeshereforaremoteDB?;" & _
"Option=16384;" & _
"Port=3306;" & _
"Stmt=;" & _
"Database=dbname;" & _
"Uid=username;" & _
"Pwd=password;Option=3"

I think I'm having problems with the Server section. I've tried:

• webhosting.uk.com's IP address
• my site's ipaddress (which may not be static...)
• the web address of my site (minus the www dot)
• the web address of my site

I frequently get the error 'Access denied for user 'username'@'(my IP address)' (using password:yes)'

The username & password are those that the php uses to connect to the MySQL database during normal web site use.

Can anyone shed any light?

Thanks for listening.
Cornerpilot

[WH-WinAdmin]

Hello,

You get error message "Access denied" only when your database user do not have sufficient permissions over the database. This can be easily fixed by granting necessary permissions to DB user.
If you let us know the database name and its login details along with domain name under which its created then we can grant the permissions for you.

[cornerpilot]

Thanks, but what value should I enter for 'Server'?

C

[WiPaul]

Hello ,

The value for server should be localhost if your account is on plesk server and if your account is on a dotnet panel server then you should use the IP of the database server .

Regards,

Paul.
Windows Support Department.

[cornerpilot]

Thanks Paul.

My account is on CPanel on Shared Linux Hosting; what should I use for that?

When I use the IP address (115.124.117.240) & Port (2306) - shown in the IE/Firefox address bar of phpMyAdmin for the remote DB, I get the message:
Lost connection to MySQL server at 'reading initial communication packet', system error:2'

If I use port 3306 I get the message:
'Can't connect to MySQL server on '115.124.117.240' (10060)'


C

[sysadmin]

Originally Posted by cornerpilot

Thanks Paul.

My account is on CPanel on Shared Linux Hosting; what should I use for that?

When I use the IP address (115.124.117.240) & Port (2306) - shown in the IE/Firefox address bar of phpMyAdmin for the remote DB, I get the message:
Lost connection to MySQL server at 'reading initial communication packet', system error:2'

If I use port 3306 I get the message:
'Can't connect to MySQL server on '115.124.117.240' (10060)'


C

You need to use localhost in your scripts to connect to the MySQL database. Also, please open up a support ticket if you're still facing problems with connecting the SQL server through your scripts.

I'm moving this thread to the appropriate (cPanel Shared Hosting) section for further assistance.

[cornerpilot]

Thanks, and apologies. Don't kow how I ended up in the wrong area...

[PatrickP]

You will need to add your local machine IP under cPanel >> Remote Mysql , then try to access the database with port : 3306 .

[cornerpilot]

Brilliant Patrick, that did it. Thank you.

C

[PatrickP]

Good to hear that it worked for you .