Python Forum
pysql connection to cloud server database times out
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
pysql connection to cloud server database times out
#5
Didn't know that! I just saw somewhere that the default port was 1443. Can't find that again right now!

Anyway, I used this query in mysql on the server to check the port:

Quote:mysql> show variables where variable_name in ('hostname','port');
+---------------+------------+
| Variable_name | Value |
+---------------+------------+
| hostname | ebs-105422 |
| port | 3306 |
+---------------+------------+
2 rows in set (0.01 sec)

mysql>

So at least 1 port is 3306

But I am getting:

Quote:pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '123.456.789.123' ([Errno 111] Connection refused)")

So, there must be some other server setting I am not aware of.

Any clues??

Like I said, this works like a charm on my old shared hosting website.
Reply


Messages In This Thread
RE: pysql connection to cloud server database times out - by Pedroski55 - Oct-11-2021, 04:17 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Database connection problems [login, PyQt5, PySql] gradlon93 5 849 Dec-15-2023, 05:08 PM
Last Post: deanhystad
  Networking Issues - Python GUI client and server connection always freezes Veritas_Vos_Liberabit24 0 809 Mar-21-2023, 03:18 AM
Last Post: Veritas_Vos_Liberabit24
  Mysql error message: Lost connection to MySQL server during query tomtom 6 16,749 Feb-09-2022, 09:55 AM
Last Post: ibreeden
  Serial connection connection issue Joni_Engr 15 8,529 Aug-30-2021, 04:46 PM
Last Post: deanhystad
  How to take the tar backup files form remote server to local server sivareddy 0 2,007 Jul-14-2021, 01:32 PM
Last Post: sivareddy
  ws server exit after getting 1 connection korenron 3 5,575 Feb-04-2021, 07:49 PM
Last Post: nilamo
  run a health check script on cloud server through paramiko amritjsr 4 3,408 Jul-21-2020, 02:30 AM
Last Post: amritjsr
  Connection timed out error when connecting to SQL server kenwatts275 2 3,439 Jun-02-2020, 07:35 PM
Last Post: bowlofred
  Connection DATABASE to Python MenThoLLt 3 2,518 Jan-17-2020, 10:35 PM
Last Post: DT2000
  Unable to login to remote SQL Server database sipriusPT 1 15,216 Dec-20-2019, 10:16 AM
Last Post: sipriusPT

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020