Please check in your wpDataTables settings that you correctly entered MySQL host/ MySQL database/MySQL user/password.
If you did enter the credentials could you please check your server error log to see if there is any errors that can give us the clue of what is going on. f there is some problem other than wrong credentials it will be logged in server error log which you can find in your cPanel (or similar hosting management solution )
Hi, I get this error when testing my remote connection:
wpDataTables could not connect to MySQL server. MySQL said: Can't connect to MySQL server on 'my.ip.address' (111)
Pretty sure it's my server denying the connection as I created the user within MySQL but I'm clueless on how to authorize it.
Configuration is as follow:
Server A (Wordpress with WpDataTables) cloud hosted on Ubuntu 14.04 with Sentora control pannel
Server B (has the Database that I want to connect with) cloud hosted on Ubuntu 14.04 with LAMP and PHPMyAdmin
Thanks for your help
Hi fab418,
Thank you for your purchase.
Please check in your wpDataTables settings that you correctly entered MySQL host/ MySQL database/MySQL user/password.
If you did enter the credentials could you please check your server error log to see if there is any errors that can give us the clue of what is going on.
f there is some problem other than wrong credentials it will be logged in server error log which you can find in your cPanel (or similar hosting management solution )
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
HelloBogdan,
This is what I entered:
MySQL host: 'IP address of the server'
MySQL database: 'name of the database'
MySQL user: 'username'
password: 'password associated with user'
I also tried with root user and password with no success.
Error.log file:
[Mon Apr 10 13:05:07.238492 2017] [mpm_event:notice] [pid 3829:tid 140335339620224] AH00489: Apache/2.4.7 (Ubuntu) configured -- resuming normal operations
[Mon Apr 10 13:05:07.238620 2017] [core:notice] [pid 3829:tid 140335339620224] AH00094: Command line: '/usr/sbin/apache2'
[Mon Apr 10 13:05:14.522194 2017] [mpm_event:notice] [pid 3829:tid 140335339620224] AH00491: caught SIGTERM, shutting down
[Mon Apr 10 13:05:15.583158 2017] [mpm_prefork:notice] [pid 5634] AH00163: Apache/2.4.7 (Ubuntu) configured -- resuming normal operations
[Mon Apr 10 13:05:15.583237 2017] [core:notice] [pid 5634] AH00094: Command line: '/usr/sbin/apache2'
[Mon Apr 10 13:05:16.843405 2017] [mpm_prefork:notice] [pid 5634] AH00169: caught SIGTERM, shutting down
[Mon Apr 10 13:05:17.950403 2017] [mpm_prefork:notice] [pid 5720] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.19 configured -- resuming normal operations
[Mon Apr 10 13:05:17.950487 2017] [core:notice] [pid 5720] AH00094: Command line: '/usr/sbin/apache2'
[Mon Apr 10 13:08:19.607946 2017] [mpm_prefork:notice] [pid 5720] AH00169: caught SIGTERM, shutting down
[Mon Apr 10 13:08:20.680441 2017] [mpm_prefork:notice] [pid 8426] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.21 configured -- resuming normal operations
[Mon Apr 10 13:08:20.680503 2017] [core:notice] [pid 8426] AH00094: Command line: '/usr/sbin/apache2'
[Mon Apr 10 13:08:23.048652 2017] [mpm_prefork:notice] [pid 8426] AH00171: Graceful restart requested, doing restart
[Mon Apr 10 13:08:23.111197 2017] [mpm_prefork:notice] [pid 8426] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.21 configured -- resuming normal operations
[Mon Apr 10 13:08:23.111212 2017] [core:notice] [pid 8426] AH00094: Command line: '/usr/sbin/apache2'
[Mon Apr 10 13:10:12.822519 2017] [mpm_prefork:notice] [pid 8426] AH00169: caught SIGTERM, shutting down
[Mon Apr 10 13:10:13.826807 2017] [mpm_prefork:notice] [pid 9521] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.21 configured -- resuming normal operations
[Mon Apr 10 13:10:13.826877 2017] [core:notice] [pid 9521] AH00094: Command line: '/usr/sbin/apache2'
[Mon Apr 10 13:10:55.098243 2017] [mpm_prefork:notice] [pid 9521] AH00169: caught SIGTERM, shutting down
[Mon Apr 10 13:11:07.827657 2017] [mpm_prefork:notice] [pid 1129] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.21 configured -- resuming normal operations
[Mon Apr 10 13:11:07.830043 2017] [core:notice] [pid 1129] AH00094: Command line: '/usr/sbin/apache2'
[Mon Apr 10 13:16:08.302827 2017] [mpm_prefork:notice] [pid 1129] AH00169: caught SIGTERM, shutting down
[Mon Apr 10 13:16:09.302128 2017] [mpm_prefork:notice] [pid 1467] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.21 configured -- resuming normal operations
[Mon Apr 10 13:16:09.302188 2017] [core:notice] [pid 1467] AH00094: Command line: '/usr/sbin/apache2'
Solved by adding # before:
in /etc/mysql/my.cnf
and restart mysql with:
Hi fab418,
We are glad that you found the solution, good job.
If you have any more issues feel free to open a new ticket, we will gladly help.
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