On the wpDataTables settings screen there is a tab for SEPARATE MYSQL CONNECTION. We wanted to issue a SQL statement against the wp_options table to change the settings without using the administrative panel.
I have now discovered that they are in that table with option_name = wdtMySqlHost, wdtMySqlDB, wdtMySqlUser, wdtMySqlPwd and wdtMySqlPort. So I believe I can change these from the command line with a SQL query or even with WP-CLI.
We would like to change the DB settings using a script - perhaps a call to the MySQL command line.
Do you have a way to do this? Maybe you can tell me what table and row we need to look in?
Mark Lee
HI Mark Lee,
Thank you for your purchase.
Sorry but I did not quite understand your issue, can you please describe me a little bit more so I can give you my suggestion.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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
Hi Bogdan,
On the wpDataTables settings screen there is a tab for SEPARATE MYSQL CONNECTION. We wanted to issue a SQL statement against the wp_options table to change the settings without using the administrative panel.
I have now discovered that they are in that table with option_name = wdtMySqlHost, wdtMySqlDB, wdtMySqlUser, wdtMySqlPwd and wdtMySqlPort. So I believe I can change these from the command line with a SQL query or even with WP-CLI.
So you see any problem with this?
Mark
HI Mark Lee,
Can you please tell me did you try to make MySQL table with the query for example like this
SELECT * FROM wp_options and make that table editable.
In that case you can change the values from the wp_options table in database.
Correct me if I did not understand you completely.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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