Pymysql .err operationalerror 2003, cant connect to mysql server on (timed out)

problem

python Remote link database error pymysql.err.OperationalError: (2003, “Can’t connect to MySQL server on ‘xxx.xxx.xxx.x’ (timed out)”)

terms of settlement

When linking the database of the remote host , You need to use it first ssh verification , Then link the database on the server , It can be solved in general

    def __init__(self):
        self.ssh_host = " The host address "
        self.ssh_port = 22
        self.ssh_user = " Host name "
        self.ssh_password = " Host password "
        self.mysql_host = "127.0.0.1"
        self.mysql_port = 3306
        self.mysql_user = " Database users "
        self.mysql_password = " Database password "
        self.mysql_db = " Database name "
        self.server = None
        self.conn = None
        self.cursor = None

    #  Link to 
    def connect(self):
        self.server = SSHTunnelForwarder(
            (self.ssh_host, self.ssh_port),
            ssh_username=self.ssh_user,
            ssh_password=self.ssh_password,
            remote_bind_address=(self.mysql_host, self.mysql_port))
        self.server.start()
        self.conn = pymysql.connect(host=self.mysql_host,
                                    port=self.server.local_bind_port,
                                    user=self.mysql_user,
                                    passwd=self.mysql_password,
                                    db=self.mysql_db)
        # self.cursor = self.conn.cursor(cursor=pymysql.cursors.DictCursor)
        self.cursor = self.conn.cursor()

版权声明
本文为[White tea·]所创，转载请带上原文链接，感谢
https://cdmana.com/2022/03/202203040402548481.html

Validated on 20 December 2021 • Posted on 20 December 2021

A Connection Timed Out error occurs when the database’s firewall won’t allow you to connect to the database from your local machine or resource.

If you are getting this error, check that you have added the machine or resource you are connecting from to the database’s list of trusted sources. To check your database’s trusted sources, see the following guides for PostgreSQL, MySQL, Redis, and MongoDB.

Verify your connection string and add your local machine to the database cluster’s trusted sources.

Prepend your connection string with your database client.

Check for typos and formatting errors in the connection string.

Hi Guys,

I have launched one RDS instance in AWS. But when I tried to connect to this database from my local system, it is showing me the below error.

$ mysql -h mydatabase.cn5kssisqx6k.ap-south-1.rds.amazonaws.com -u admin -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'mydatabase.cn5kssisqx6k.ap-south-1.rds.amazonaws.com' (110 "Connection timed out")
You have mail in /var/spool/mail/root

Jul 26, 2020 in AWS by
• 38,230 points • 5,249 views

1 answer to this question.

Related Questions In AWS

• All categories
• 
  Apache Kafka (84)
• 
  Apache Spark (596)
• 
  Azure (131)
• 
  Big Data Hadoop (1,907)
• 
  Blockchain (1,673)
• 
  C# (124)
• 
  C++ (268)
• 
  Career Counselling (1,060)
• 
  Cloud Computing (3,356)
• 
  Cyber Security & Ethical Hacking (145)
• 
  Data Analytics (1,266)
• 
  Database (853)
• 
  Data Science (75)
• 
  DevOps & Agile (3,500)
• 
  Digital Marketing (111)
• 
  Events & Trending Topics (28)
• 
  IoT (Internet of Things) (387)
• 
  Java (1,148)
• 
  Kotlin (3)
• 
  Linux Administration (384)
• 
  Machine Learning (337)
• 
  MicroStrategy (6)
• 
  PMP (423)
• 
  Power BI (516)
• 
  Python (3,154)
• 
  RPA (650)
• 
  SalesForce (92)
• 
  Selenium (1,569)
• 
  Software Testing (56)
• 
  Tableau (608)
• 
  Talend (73)
• 
  TypeSript (124)
• 
  Web Development (2,989)
• 
  Ask us Anything! (66)
• 
  Others (1,004)
• 
  Mobile Development (37)

Subscribe to our Newsletter, and get personalized recommendations.

Already have an account? Sign in.

Can't connect to MySQL server on timed out?

What is the use of PyMySQL module in Python?

Can't connect to the database the server answered Connection Refused?