App Engine and MySQL

Question

I just wanted to ask if we can access an external MySQL server from Google App Engine...

Answer 1

The only way to communicate with other hosts is by using UrlFetch that only provides HTTP and HTTPS requests.
So, you can't do it out of the box.

Anyway, if you really need to access an external MySQL server database, you should consider to expose it through a Web API (RESTful, Soap web-services for example). In this way your data would be available also via UrlFetch.

Answer 2

I am still in the learning phase of all this, but I am fairly certain you can do this now a few ways:

• Link Apps Scripts to App Engine and use the JDBC
• Link it to Google
• Cloud SQL Store your SQL database on Google Cloud Store
• Connect Apps Scripts via spreadsheet scripting

"Google Apps Script has the ability to make connections to databases via JDBC with the Jdbc Service. The current support extends to MySQL, Microsoft SQL Server and Oracle. Apps Script makes it easy to connect to databases hosted on Google Cloud SQL, but also works with other cloud hosting platforms and even local databases." https://developers.google.com/apps-script/jdbc

(edited for structure)