Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Is it possible to access MySQL data being hosted on the web?

Megalo
in External Data Sources

Featured Replies

I have been using Rental Hosting Server.

One of the advantages to use that server is MySQL.

Now, I would like to access that MySQL with FileMaker, and see MySQL data on my local PC.

Is there anyway to do that?

If anyone knows, please tell me.

Upgrade to 9 or 10 and you can basically view the data through FileMaker's ESS capability. Keep in mind the supported MySQL version though.

http://www.filemaker.com/products/filemaker-pro/sql.html

  • Author

Thanks for your comment.

But, doesn't it work only for MySQL set up on your own PC?

I want to access to the MySQL, which exist on Rental Hosting Server.

No not true. It does not have to be on the same box as the MySQL server. ESS uses ODBC.

  • Author

Thank you very much.

I succeeded at making MySQL ODBC and connect to it.

  • 2 months later...

I'm trying to do the same thing, but have have not been able to make the connection. My website and MySQL database is shared-hosted by GoDaddy and when I called them, they said I cannot connect to this database because when this database was created, we did not check the box to allow direct access. Therefore, the GoDaddy server only allows access to this database from the same IP address that the database is hosted on. If we want direct access, we now have to recreate a new database and check this box, but the database will be much less secure.

I do not want our database to not be secure, so I need to know if there is another way I can access the data in the database from FileMaker Pro on my desktop.

Any ideas?

You should be able to setup the online database to only accept a connection from your IP address, which would limit the security issue somewhat. It is password protected too, so it should not present a major security headache - especially since the database is presumably only containing data that is available online anyway.

If you just want to read the data from the database, then you could do it via a web viewer in FileMaker as an alternative.

We have been running such a database linked up in this way for several years.

Good luck with it.

Edited by Guest

Create an account or sign in to comment

https://fmforums.com/topic/70319-is-it-possible-to-access-mysql-data-being-hosted-on-the-web/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.