Hi! I tried create new separate connect to remote MySQL Server (using IP, port, login, password, db_name) and plugin answer: wpDataTables could not connect to mysql server. mysql said: Connection refused. Connection settings are correct and proven.
There are no problems on the server side (the port is open, there are no server attempts to connect from the plugin in the MySQL logs). I connect to the server without any problems using the same connection settings from any IP address or computer. I use MySQL 8.0.12 version. (Authentication: mysql_native_password)
I have a hosting with WordPress installed and a plugin. Plugin to the local database server connected without problems. When I try to connect a plugin to a remote database, this error occurs: wpDataTables could not connect to mysql server. mysql said: Connection refused.
Log from hosting:
[17-Oct-2018 08:30:17 UTC] PHP Warning: Invalid argument supplied for foreach() in /usr/www/users/tradeaz/trade.vision/wp-content/plugins/codecanyon-3958969-wpdatatables-tables-and-charts-manager-for-wordpress/controllers/wdt_admin_ajax_actions.php on line 14
[17-Oct-2018 08:46:35 UTC] PHP Notice: Undefined index: wdtSeparateCon in /usr/www/users/tradeaz/trade.vision/wp-content/plugins/codecanyon-3958969-wpdatatables-tables-and-charts-manager-for-wordpress/controllers/wdt_admin_ajax_actions.php on line 14
If I specify the standard port 3306 MySQL - the plugin works, and if you specify a non-standard port 3337, then plugin error: wpDataTables could not connect to mysql server. mysql said: Connection refused. This is bug?
Hi! I tried create new separate connect to remote MySQL Server (using IP, port, login, password, db_name) and plugin answer: wpDataTables could not connect to mysql server. mysql said: Connection refused. Connection settings are correct and proven.
Hi trade_vision,
Thank you for you purchase.
It looks like there is some restriction or security issue on the server side that does not allow you to connect.
Can you please tell me are there any errors in the server log that might give us some clues.
When it is Connection refused error there are other things that yo might check:
First thing check if the port is not closed because this can be the issue.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
There are no problems on the server side (the port is open, there are no server attempts to connect from the plugin in the MySQL logs). I connect to the server without any problems using the same connection settings from any IP address or computer. I use MySQL 8.0.12 version. (Authentication: mysql_native_password)
I have a hosting with WordPress installed and a plugin. Plugin to the local database server connected without problems. When I try to connect a plugin to a remote database, this error occurs: wpDataTables could not connect to mysql server. mysql said: Connection refused.
Log from hosting:
[17-Oct-2018 08:30:17 UTC] PHP Warning: Invalid argument supplied for foreach() in /usr/www/users/tradeaz/trade.vision/wp-content/plugins/codecanyon-3958969-wpdatatables-tables-and-charts-manager-for-wordpress/controllers/wdt_admin_ajax_actions.php on line 14
[17-Oct-2018 08:46:35 UTC] PHP Notice: Undefined index: wdtSeparateCon in /usr/www/users/tradeaz/trade.vision/wp-content/plugins/codecanyon-3958969-wpdatatables-tables-and-charts-manager-for-wordpress/controllers/wdt_admin_ajax_actions.php on line 14
If I specify the standard port 3306 MySQL - the plugin works, and if you specify a non-standard port 3337, then plugin error: wpDataTables could not connect to mysql server. mysql said: Connection refused. This is bug?
Thank you, the issue is resolved. The hosting provider Hetzner has blocked a non-standard port.
HI trade_vision,
Glad to hear that the issue is gone and sorry for not replying earlier.
That error refers for some restrictions, I hope that now everything will work fine.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables