Connection string for MySQL (1 Viewer)

CedarTree

Registered User.
Local time
Today, 06:13
Joined
Mar 2, 2018
Messages
418
Hello - we have an Access database and want to begin to migrate the data to MySQL for others to access the data (read-only for now) using a web portal. Looking for a connection string to use in VBA to link the tables in MySQL to Access. The MySQL database is hosted on siteground if that helps. Thanks!!!
 
Thank you. Yes that would be worst case but a connection string would be ideal.
 
The MySQL database is hosted on siteground if that helps.
What is siteground? Are they just a webhost, or do you have a VPS with them?

Do they allow direct remote access to the MySQL server?

If not, do they allow SSH access to your VPS instance?

If they are just a webhost then it is unlikely you will be able to access the MySQL instance from outside your webserver.

Unless you can access them directly there is no point in trying to work out the connection string.

In this case you would probably have to set up a web API and use that for your db access. Otherwise your probably stuck with phpMyAdmin ( 🤮 )
 
What is siteground? Are they just a webhost, or do you have a VPS with them?

Do they allow direct remote access to the MySQL server?

If not, do they allow SSH access to your VPS instance?

If they are just a webhost then it is unlikely you will be able to access the MySQL instance from outside your webserver.

Unless you can access them directly there is no point in trying to work out the connection string.

In this case you would probably have to set up a web API and use that for your db access. Otherwise your probably stuck with phpMyAdmin ( 🤮 )

My bosses use them as well, but just for hosting and email.
We moves from TSOHost who I thought were pretty good.
 

Users who are viewing this thread

Back
Top Bottom