python连接数据库首先倒入数据库模块，然后创建数据库连接，创建游标对象进行Mysql数据库操作。
Python源码
#密码不显示
import getpass
#数据库模块
import pymysql
#创建数据库连接
conn = pymysql.connect(host = '',user = '',password = '',db = '')
#创建游标对象
cur = conn.cursor()
#输入用户名
name = input('用户名：')
#输入密码
pwd = getpass.getpass('密码:')
try:
#在hello表里面添加用户输入的用户名以及密码
sql = "INSERT INTO hello(`n`, `p`) VALUES ('%s', '%s')" % (name,pwd)
#执行sql语句
cur.execute(sql)
except Exception as e:
print("用户名重复，请重试", e)
else:
#提交到数据库执行
conn.commit()
print("插入数据成功;")SQL源码
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for hello -- ---------------------------- DROP TABLE IF EXISTS `hello`; CREATE TABLE `hello` ( `id` int(11) NOT NULL AUTO_INCREMENT, `n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `p` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `name`(`n`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;