# 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:** 1
**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/1 "2022-11-03T09:03:36Z")
[dummy title body text appended to avoid empty title body] ---
**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/2 "2022-11-03T09:03:37Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **wkw** _replied_ #### are you using chrome? can you check the network tab when opening a table in NocoDB UI # ---
**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/3 "2022-11-03T09:03:38Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **robertandrews** _replied_ #### Brave browser. โ€ฆ โ€œmsg: โ€œAccess denied for user โ€˜xxxxxxxxxxโ€™@โ€˜[ec2-3-xxxxxxxxxxxxxxxxxxx.compute-1.amazonaws.com](http://ec2-3-xxxxxxxxxxxxxxxxxxx.compute-1.amazonaws.com)โ€™ (using password: YES)โ€โ€ ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/fc3bfdff4ae5922d789fb02a566e50663ff11e03.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:03am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/4 "2022-11-03T09:03:39Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **robertandrews** _replied_ #### Yeah, maybe I can set a wildcard on the Siteground end. The docs do say you can use % for IP ranges, hopefully for hostnames too. # ---
**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/5 "2022-11-03T09:03:41Z")
> ๐Ÿ’ **o1lab** _replied_ #### \<@319896779497668616\> : try recreating the project connecting to your wordpress. If it works then it might be have to do with credentials on wp side # ---
**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/6 "2022-11-03T09:03:42Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **robertandrews** _replied_ #### Or a way to set a fixed hostname 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:03am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/7 "2022-11-03T09:03:43Z")
> ๐Ÿ’ **o1lab** _replied_ #### \> Yeah, maybe I can set a wildcard on the Siteground end. The docs do say you can use % for IP ranges, hopefully for hostnames too. #### #### Ah ok # ---
**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/8 "2022-11-03T09:03:44Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **robertandrews** _replied_ #### The AWS hostname in the error is different from the one I whitelisted last night. # ---
**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/9 "2022-11-03T09:03:45Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **robertandrews** _replied_ #### Grr, wildcard not accepted on the Siteground end. Can I set a fixed hostname on the Heroku/Nocodb side? # ---
**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/10 "2022-11-03T09:03:46Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **robertandrews** _replied_ #### Not sure why Heroku is appearing from amazonaws anyway. # ---
**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/11 "2022-11-03T09:03:48Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **wkw** _replied_ #### did u provision the DB in AWS yourself? # ---
**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/12 "2022-11-03T09:03:49Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **robertandrews** _replied_ #### I havenโ€™t touched AWS. I opened my first Heroku account and used Nocodbโ€™s 1-click deploy. # ---
**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/13 "2022-11-03T09:03:50Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **wkw** _replied_ #### i mean your WordPress MySQL 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:03am UTC](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403/14 "2022-11-03T09:03:51Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **robertandrews** _replied_ #### It was possibly a one-click WordPress install within the Siteground environment, with some importing from a previous site. Itโ€™s been running for ages. # ---
**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/15 "2022-11-03T09:03:52Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **wkw** _replied_ #### u may follow o1lab suggestion to verify the connection and credential first # ---
**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/16 "2022-11-03T09:03:53Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **robertandrews** _replied_ #### Itโ€™s not the WP credentials etc per o1labโ€™s messageโ€ฆ #### #### The issue is that the Nocodb connection on Heroku is coming in via [ec2-xxxxx-xxxx.amazonaws.com](http://ec2-xxxxx-xxxx.amazonaws.com), and that particular hostname rotates. Itโ€™s different this morning than it was last night. #### #### So the connection is being denied by my MySQL database (as per the browser Network tab message), because itโ€™s not on the [amazonaws.com](http://amazonaws.com) I allowed as a remote. #### #### Iโ€™m pretty sure I could whitelist this morningโ€™s hostname and it would be fine. But I canโ€™t predict all the hostnames. #### #### 1. Iโ€™ve no idea why Heroku would come in via [amazonaws.com](http://amazonaws.com) (do they use them?). #### #### 2. I canโ€™t use a wildcard % in specifying the hostnames. # ---
**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/17 "2022-11-03T09:03:54Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **wkw** _replied_ #### oh i got wt you mean now # ---
**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/18 "2022-11-03T09:03:56Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **wkw** _replied_ #### when u access NocoDB, are u browsing [ec2-xxxxx-xxxx.amazonaws.com](http://ec2-xxxxx-xxxx.amazonaws.com)? # ---
**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/19 "2022-11-03T09:03:57Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **robertandrews** _replied_ #### Noโ€ฆ [myappname.herokuapp.com](http://myappname.herokuapp.com) # ---
**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/20 "2022-11-03T09:03:58Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **wkw** _replied_ #### [ec2-xxxxx-xxxx.amazonaws.com](http://ec2-xxxxx-xxxx.amazonaws.com) โ† this may be the addon db as well # [Next page](https://community.nocodb.com/t/nocodb-with-wordpress-mysql-apr-30/403.md?page=2)