python - 从局域网访问sql数据库

Question

我的两台电脑通过局域网连接。 computer1(192.168.0.56) 包含以下程序

import MySQLdb
db= MySQLdb.connect("localhost","root","pass","testDB")
cursor=db.cursor()
cursor.execute("DROP TABLE IF EXISTS USER")
sql="""CREATE TABLE USER(
   ID  INT(12) NOT NULL AUTO_INCREMENT,
   USERNAME VARCHAR(20) NOT NULL,
   PASSWORD VARCHAR(20) NOT NULL,
   PRIMARY KEY (ID)
   )"""
cursor.execute(sql)
db.close()

我想从另一台计算机(192.168.0.4)向表中插入值

import MySQLdb
db= MySQLdb.connect("192.168.0.56","root","pass","testDB")
cursor=db.cursor()
sql="""INSERT INTO USER(USERNAME,
   PASSWORD)
   VALUES('admin','12345'),
         ('abc','123'),
         ('user3','5687')"""
try:
cursor.execute(sql)
db.commit()
print ("Data is inserted into database")
except:
db.rollback()
print ("Data cann't be updated")
db.close()

错误:访问被拒绝 root@192.168.0.4

Answer 1

Try to use port
as,
db= MySQLdb.connect("192.168.0.56:8080","root","pass","testDB")