Hi , i like to connect a MySql that is hosted on pythonanywhere. It can be done only by ssh . How to dp that in the plugin ?
Here is what pythonanywhere is telling me :
SettingValueSSH Hostname:your SSH hostnameSSH Username:your PythonAnywhere usernameSSH Password:the password you use to log in to the PythonAnywhere websiteSSH Key file:should not be necessary when you specify the passwordMySQL Hostname:your PythonAnywhere database hostname, eg. yourusername.mysql.pythonanywhere-services.comMySQL Server Port:3306Username:your PythonAnywhere usernamePassword:your PythonAnywhere database passwordDefault Schema:your database name, eg yourusername$mydatabase
You may also need to allow ssh login based management as one of the mysql workbench options under server connections -> remote management.
It's also a good idea to set the Edit -> Preferences -> SQL Editor -> DBMS_Connection keep alive interval setting to 200, to avoid any "lost connection" issues due to our 5-minute connection timeout.
I'm not sure you'll be able to do this, but the info you need looks like you could.
To connect a separate DB connection to wpDataTables, you need to set a connection name (you choose this), choose the type of the connection (MySQL), add database name, host, username, password and port. You can also choose which driver will be used for the connection.
If you have all that, you should be able to connect to the database, but since it's only SSH, don't know if that'll be enough. Please try and let me know. If it doesn't work, can you provide me the connection details, so I can try from my installation?
the problem is, that regarding to this description, you need a password for the ssh connection and a password for the database, whre in your frontend you can specify only one password
Would be a great feature if this could be done. You need an paid pythonanywhre account (5 Euro) per month to test it. I am not allowed to share the data at the meoment.
You're right, and the first sentence on that page says it all:
MySQL databases on PythonAnywhere are protected by a firewall, so external computers can't access them
Anyway, I'll still forward the question to one of our developers. Maybe he has a workaround for this. I'll get back to you as soon as he responds (some time on Monday, since we don't work on weekends).
Our developer took a look at this, and he said that there may be a way of doing this through VPN, but you'd need to have the tunnel constantly opened for something like that.
He doesn't know how to do it, but if you are willing to explore this option, I'm sure you'll be able to find some useful info.
Hi , i like to connect a MySql that is hosted on pythonanywhere. It can be done only by ssh . How to dp that in the plugin ?
SettingValueSSH Hostname:your SSH hostnameSSH Username:your PythonAnywhere usernameSSH Password:the password you use to log in to the PythonAnywhere websiteSSH Key file:should not be necessary when you specify the passwordMySQL Hostname:your PythonAnywhere database hostname, eg. yourusername.mysql.pythonanywhere-services.comMySQL Server Port:3306Username:your PythonAnywhere usernamePassword:your PythonAnywhere database passwordDefault Schema:your database name, eg yourusername$mydatabaseHere is what pythonanywhere is telling me :
Hello Dirk
I'm not sure you'll be able to do this, but the info you need looks like you could.
To connect a separate DB connection to wpDataTables, you need to set a connection name (you choose this), choose the type of the connection (MySQL), add database name, host, username, password and port. You can also choose which driver will be used for the connection.
If you have all that, you should be able to connect to the database, but since it's only SSH, don't know if that'll be enough. Please try and let me know. If it doesn't work, can you provide me the connection details, so I can try from my installation?
Kind Regards,
Aleksandar Vuković
[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 Aleksandar,
the problem is, that regarding to this description, you need a password for the ssh connection and a password for the database, whre in your frontend you can specify only one password
https://help.pythonanywhere.com/pages/AccessingMySQLFromOutsidePythonAnywhere/
Would be a great feature if this could be done. You need an paid pythonanywhre account (5 Euro) per month to test it. I am not allowed to share the data at the meoment.
Dirk
Hi again Dirk
You're right, and the first sentence on that page says it all:
MySQL databases on PythonAnywhere are protected by a firewall, so external computers can't access them
Anyway, I'll still forward the question to one of our developers. Maybe he has a workaround for this. I'll get back to you as soon as he responds (some time on Monday, since we don't work on weekends).
Kind Regards,
Aleksandar Vuković
[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 again Dirk
Our developer took a look at this, and he said that there may be a way of doing this through VPN, but you'd need to have the tunnel constantly opened for something like that.
He doesn't know how to do it, but if you are willing to explore this option, I'm sure you'll be able to find some useful info.
Kind Regards,
Aleksandar Vuković
[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