Forums

interface error/ mysql

I'm unable to connect mysql which is hosted online. It is showing internal server error with port 3306 even when I have not specified the port This is the connection line: db = sql.connect(host='sql6.freesqldatabase.com', user='user_nm, passwd="paswd", database='db_nm') 'https://photos.google.com/search/tra/photo/AF1QipMUxRuuT6y9FnVm64YRhWr9wqMsTGTfRuosJoiu' enter image description here

scotworld | 3 posts | Dec. 28, 2022, 8:02 p.m. | permalink

You cannot connect to an external database from a free account.

Staff glenn | 9498 posts | PythonAnywhere staff | Dec. 29, 2022, 11:52 a.m. | permalink

Ok so when I upgrade to paid account, I can connect it right?

scotworld | 3 posts | Dec. 30, 2022, 7:40 a.m. | permalink

Yes, so long as the MySQL server is configured to allow incoming connections from anywhere on the Internet. (You could also use a more restrictive IP whitelist, but that can be complex because the IP addresses used by code running on PythonAnywhere can change over time; more information here.)

Staff giles | 11788 posts | PythonAnywhere staff | Dec. 30, 2022, 4:14 p.m. | permalink