Client is hosting a wordpress site on Linode and Iโve been asked to interact with the database using an app I have built on Appsheet. Hoping there are no issues and it works and acts like an AWS host?
Steve, thanks for these! Iโm actually attempting a more direct approach and maybe you or someone else can help me. Iโm very new to all of the mySQL database connections but Iโm learning fast. I am attempting to access a wordpress database with Appsheet directly. I have a database name, ip address, UN & PW. Iโm having the wordpress developer check on his side but Iโm still getting an error. Since Iโm a noob, I want to make sure that I was given the correct info and iโm entering it correctly. Error message:
Add Sql info:
Iโm afraid I have no experience with databases. Have you searched help.appsheet.com?
Thanks for the reply. I think Iโm going to pull the plug on database access idea and stick with wordpress API and webhooks. Someone suggested to me that this is probably more secure option and also future proof in case changes are made to the data models in the database.
Still a little over my head but I think there is more support going this directionโฆbesides if Steve doesnโt have experience doing itโฆitโs probably not worth doing!!!
Oh, definitely not the case here! Databases are hugely useful for AppSheet apps, but I would suggest that youโre playing with very advanced topics. Perhaps find a simpler approach to start?
Most likely, you havenโt added the ip addresses (from where Appsheet will be connecting) to access the WP MySQL server. Have you done this step -Managing IP Addresses and Firewall Information | AppSheet Help Center ?
Thanks for this. Iโm looking into this now. Working with a 3rd party so the process of connecting these is grueling.
@Bellave_Jayaram UPDATE: Success!!!
Thanks again for this response! I was able to connect once all of the IP addresses were added to the Firewall.
I also found this video very helpful: How to Make an App Using Your SQL Data - YouTube
Very cool. Keep us posted on how you are interfacing between Wordpress and the app (what kinda of things you are doing, how itโs helpful, roadblocks etc.) when you find time.
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |