OperationalError: (OperationalError) (2003, “无法连接到 MySQL 服务器上的 '192.168.129.139' (111)") 无 无

2021-12-30 00:00:00 python sqlalchemy sql mysql

我正在尝试在运行 12.04 的 Ubuntu 机器上使用 mysql 创建远程数据库.

I am trying to create a remote database using mysql on an Ubuntu machine running 12.04.

它有一个启用远程登录且没有密码的 root 用户.我已经启动了服务器.

It has a root user with remote login enabled and no password.I have started the server.

输出

sudo netstat -tap | grep mysql

节目

tcp        0      0 localhost:mysql         *:*                     LISTEN      13246/mysqld

我创建了一个名为 nwtopology 的数据库(如前所述，root 还没有密码.)

I have created a database called nwtopology using (as mentioned root doesn't have a password yet.)

 create database nwtopology
 grant all privileges on *.* to root@192.168.129.221
 FLUSH PRIVILEGES;

在同样运行 Ubuntu 12.04 的客户端机器上，我使用 python 脚本通过 sqlalchemy 连接到远程 mysql 数据库.

From the client machine that also runs Ubuntu 12.04 I use a python script to connect to the remote mysql database using sqlalchemy.

from pox.core import core
import pox.openflow.libopenflow_01 as of
import re
import datetime
import time
from sqlalchemy import create_engine, ForeignKey
from sqlalchemy import Column, Date, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship, backref
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.sql.expression import exists

log = core.getLogger()
engine = create_engine('mysql://root@192.168.129.139/nwtopology', echo=False)
Base = declarative_base()
Session = sessionmaker(bind=engine)
session = Session()

class SourcetoPort(Base):
    """"""
    __tablename__ = 'source_to_port'
    id = Column(Integer, primary_key=True)
    port_no        = Column(Integer)
    src_address    = Column(String,index=True)

    #-----------------------------------------
    def __init__(self, src_address,port_no):
        """"""
        self.src_address = src_address
        self.port_no     = port_no

create_engine() 调用失败并出现以下错误.

The create_engine() call is failing with the following error.

POX 0.1.0 (betta) / Copyright 2011-2013 James McCauley, et al.
Traceback (most recent call last):
  File "/home/karthik/ms_thesis/pox/pox/boot.py", line 89, in do_import2
    __import__(name, globals(), locals())
  File "/home/karthik/ms_thesis/pox/custom/tutorial.py", line 39, in <module>
    Base.metadata.create_all(engine)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/schema.py", line 2515, in create_all
    tables=tables)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2230, in _run_visitor
    conn = self.contextual_connect(close_with_result=False)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2340, in contextual_connect
    self.pool.connect(),
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 210, in connect
    return _ConnectionFairy(self).checkout()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 371, in __init__
    rec = self._connection_record = pool._do_get()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 697, in _do_get
    con = self._create_connection()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 174, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 256, in __init__
    self.connection = self.__connect()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 316, in __connect
    connection = self.__pool._creator()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 80, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 280, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (OperationalError) (2003, "Can't connect to MySQL server on '192.168.129.139' (111)") None None

我不明白为什么会这样?非常感谢任何帮助?

I cannot figure out why this is happening?Any help is greatly appreciated?

推荐答案

看起来 mysql 配置为仅在 localhost 上侦听.

Looks like mysql is configured to listen only on localhost.

您可以通过从您的客户端机器运行 telnet 192.168.129.139 3306 来测试这一点.

You can test this by running telnet 192.168.129.139 3306 from your client machine.

最可能的原因 - mysqld 被配置为这样做.

Most probable reason - mysqld is configured to do so.

请尝试按照此处描述的配置步骤:

编辑 /etc/mysql/my.cnf 文件以配置 MySQL 以侦听来自网络主机的连接，将 bind-address 指令更改为服务器的 IP 地址.例如，将 192.168.0.5 替换为适当的地址.如果没有这样的条目 - 取消注释或创建新行.

Edit the /etc/mysql/my.cnf file to configure MySQL to listen for connections from network hosts, change the bind-address directive to the server's IP address. For example Replace 192.168.0.5 with the appropriate address. If there are no such entry - uncomment it or create new line.

bind-address            = 192.168.0.5

然后重启mysqld

sudo service mysql restart

然后使用 telnet 或再次运行您的应用程序进行测试.netstat 也会有 mysqld 的第二个条目.

Then test with telnet or by running your application once again. Also netstat would have second entry for mysqld.

相关文章