Please wait...

Can’t connect to remote MySql database?By Milan Jovanovic on 23/07/18 in

If you are using separate MySql connection option to connect to mysql database, you can test if connection can actually be established with “Test MySQL settings” button.
If connection can’t be established, first please make sure that all entered values needed for connection are correct.
Also make sure that MySql server is allowing remote connections and that MySql user that you are trying to connect with is allowed to connect from your sites host(IP address).

From 2.3 version of our plugin there is an option to add more than one separate database connection. Now every table can have its own separate database connection, so tables can pull data from multiple databases and servers.

If your WordPress is hosted on Azure Web App Services you will need to modify the config.inc.php file, around line 65 find this line of code

$wdtMsSqlDriver = [
‘sqlsrv’ => [‘active’ => false],
‘dblib’ => [‘active’ => true, ‘version’ => ‘7.0’],
‘odbc’ => [‘active’ => false, ‘driver’ => ‘{ODBC Driver 17 for SQL Server}’],
];

and change it to look like this:

$wdtMsSqlDriver = [
‘sqlsrv’ => [‘active’ => true],
‘dblib’ => [‘active’ => false, ‘version’ => ‘7.0’],
‘odbc’ => [‘active’ => false, ‘driver’ => ‘{ODBC Driver 17 for SQL Server}’],
];
Was this answer helpful ? Yes (2) No (3)

Comments are closed.

Do you have the best

essential plugins installed?
Grab the best 46 plugins. Tested and sorted.

Plugins for SEO, Caching, Security, Design and UX, Stats & analytics, Social sharing. Only the best ones.

By clicking "subscribe" you consent that the information you provide via this form will be securely processed and stored in compliance with EU privacy laws (GDPR).

Thank you for subscribing!

Please check your inbox to download the WordPress goodies.