# NocoDB with Wordpress MySQL \[Apr 30\] **URL:** \ **Category:** Discord-Discussions\ **Created:** [November 3, 2022, 9:03am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403 "2022-11-03T09:03:36Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:03am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/21 "2022-11-03T09:03:59Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### one click heroku uses heroku-postgresql as a meta database # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/22 "2022-11-03T09:04:00Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### β€œHeroku rotates credentials periodically and updates applications where this database is attached.” # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/23 "2022-11-03T09:04:01Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### seems the meta database got changed # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/24 "2022-11-03T09:04:02Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### can u help verify that? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/25 "2022-11-03T09:04:03Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### \> how to ensure a remote connection can be made to my MySQL. I set it to allow from [ec-2-xxxxxxxxxxx.computer-1.amazonaws.com](http://ec-2-xxxxxxxxxxx.computer-1.amazonaws.com). That worked and I was able to try out Nocodb, connecting directly to the MySQL WP DB. #### #### yesterday u set the host in Siteground. so this s the old value. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/26 "2022-11-03T09:04:05Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### if u go to heroku and select your project, click Resources \> Heroku Postgres under Add-ons \> Settings \> View Credentials. then u ll see the current host # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/27 "2022-11-03T09:04:06Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### compare both to prove if the meta connection string got changed # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/28 "2022-11-03T09:04:07Z")
> πŸ™‹β€β™‚οΈ **robertandrews** _replied_ #### \> can u help verify that? #### #### Yes… I just whitelisted today’s amazonaws host on Siteground and Nocodb successfully connects and shows the WP DB contents. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/29 "2022-11-03T09:04:08Z")
> πŸ™‹β€β™‚οΈ **robertandrews** _replied_ #### Thanks. I’ve just gone in to this (although I didn’t see the Add-ons link)… under for postgresql-xxxx-xxxxx, it says 2 of 20 connections… #### #### In Settings, Database Credentials… the [ec2-xx-xx-xx-xx.computer-1.amazonaws.com](http://ec2-xx-xx-xx-xx.computer-1.amazonaws.com) is different from either of the two I have now whitelisted on Siteground. So, this is a third. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/30 "2022-11-03T09:04:09Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/7df18552ada6aeaf524637673a05c027847bcb37.png) # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/31 "2022-11-03T09:04:11Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### have this seen such page? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/32 "2022-11-03T09:04:12Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### if u r using postgresql, then the credentials would be rotated by Heroku from time to time, which means you have to reset NC\_DB once it got rotated. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/33 "2022-11-03T09:04:13Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### heroku one-click is designed more for people to experience NocoDB. if you wanna use NocoDB in a long term, i’d suggest to have your own DB as a meta DB. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/34 "2022-11-03T09:04:14Z")
> πŸ™‹β€β™‚οΈ **robertandrews** _replied_ #### Yes, that page. I clicked Heroku Postgres. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/35 "2022-11-03T09:04:15Z")
> πŸ™‹β€β™‚οΈ **robertandrews** _replied_ #### \> heroku one-click is designed more for people to experience NocoDB #### #### I would class myself as this. Still, quite frustrating the hit the issue within a day. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/36 "2022-11-03T09:04:16Z")
> πŸ™‹β€β™‚οΈ **robertandrews** _replied_ #### \> if you wanna use NocoDB in a long term, i’d suggest to have your own DB as a meta DB. #### #### You mean locally on my machine, or something on Heroku? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/37 "2022-11-03T09:04:18Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### any DB s fine as long as u can manage it. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/38 "2022-11-03T09:04:19Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### local one is fine if you just wanna experience for a short term # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/39 "2022-11-03T09:04:20Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### but it s weird. if u r using one-click, then why there s no add-ons # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:04am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/40 "2022-11-03T09:04:21Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### can u screenshot Resources page? # [Previous page](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403.md?page=1) [Next page](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403.md?page=3)