[AccessD] MySQL db on Arvixe linux server

[Jim Lawrence]

I would suspect that the data base in question is isolated from their regular network. Forward facing servers are always susceptible to attack but there are many ways to secure a network. Here is a link to an article I was just reading when I saw this post...it may be interesting.

https://www.digitalocean.com/community/tutorials/7-security-measures-to-protect-your-servers

Jim

----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Thursday, October 8, 2015 2:23:43 PM
Subject: Re: [AccessD] MySQL db on Arvixe linux server

It's not MySql or Linex Servers.

It's a matter of basic security.   Web hosting organisations need to lock down their systems 
very tightly because they are under constant attack using every newly identified security bug 
in their environment.  

I'm surprised that your Windows host provider has opened MyDQL server to remote 
connection from outside their environment, very few do so.

Yes you can use ADO with the ODBC driver, but again, only if the DB engine accepts the 
connection.

FWIW, You should do the same with any corporate SQL Server installation inside a LAN for 
secruity reasons - configure it to only allow connections from the same sub-net.

-- 
Stuart

On 8 Oct 2015 at 8:34, Doug Murphy wrote:

> Thanks Stuart,
> 
> Is it possible to connect using ADO and perform operations
> programmatically? I am not clear on why connections are limited on
> Linux servers. It seems the MySql odbc driver likes to connect on port
> 3306. Is that typically blocked on Linux servers. When I have a MySql
> database on a Windows shared hosting server I can connect with ADO.
> The application I am looking at is simple and has only one main table.
> It would be easy to keep Access on the client computer synchronized
> with the server db if we can connect.
> 
> Thanks
> 
> Doug
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of Stuart McLachlan Sent: Wednesday, October 07, 2015 10:23 PM To:
> Access Developers discussion and problem solving Subject: Re:
> [AccessD] MySQL db on Arvixe linux server
> 
> I've changed the subject back to the appropriate one.
> 
> If it's on a shared hosting account, you almost certainly will not be
> able to access it from Access.
> 
> The best I've ever managed in that situation is to export the data
> locally at one end as plain text, compress it, upload/download it via
> FTP , uncompress and then import at the other end.  It's a lot of
> work.
> 
> 
> Still, it's worth contacting the hosting provider and checking whether
> you can have remote access.
> 
> -- 
> Stuart
> 
> On 7 Oct 2015 at 22:11, doug wrote:
> 
> > Jim,
> > 
> > I am guessing not. The db is on a shared hosting account. 
> > 
> > -------- Original message --------
> > From: Jim Lawrence <accessd at shaw.ca> 
> > Date:10/07/2015  9:41 PM  (GMT-08:00) 
> > To: Access Developers discussion and problem solving
> > <accessd at databaseadvisors.com> Subject: Re: [AccessD] Stored
> > Procedure as Rowsource for Chart 
> > 
> > Hi David:
> > 
> > Here is an overly simplified Youtube vid of connecting MS Access to
> > a MySQL DB: https://www.youtube.com/watch?v=F06hvR6ksh4
> > 
> > Here is a link to some comprehensive lists of database to database
> > connection string: http://www.connectionstrings.com and
> > http://www.dofactory.com/reference/connection-strings and
> > http://www.carlprothman.net/Default.aspx?tabid=90
> > 
> > Aside: If you use the standard method of generating an ODBC connect,
> > the file created can be stripped down to a basic string by changing
> > the file's extension to ".txt" and using the resultant connection
> > text string directly within your Access connection module.
> > 
> > Do you have direct root access to the MySQL DB that you will be
> > using?
> > 
> > 
> > HTH
> > Jim 
> > 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com