ubantu python3.5安装pymysql +MySQL服务器 及测试

一  安装mysql服务器

 sudo apt-get install mysql-server
 sudo apt-get isntall mysql-client
 sudo apt-get install libmysqlclient-dev

参考链接：https://blog.csdn.net/fighter_yy/article/details/40753889

使用mysql

➜  PY3.5 mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.11-0ubuntu6 (Ubuntu)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| MYTEST             |
| mysql              |
| performance_schema |
| qcwy               |
| sys                |
+--------------------+
6 rows in set (0.00 sec)

mysql> use qcwy
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------+
| Tables_in_qcwy |
+----------------+
| user           |
+----------------+
1 row in set (0.00 sec)

二 安装pymysql

参考网上教程

三 测试连接

首先有一个qcwy的数据库，包含一张user的表，以下为

#!/usr/bin/env pytho
# -*- coding:utf-8 -*-
import pymysql

# 创建连接
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='root', db='qcwy', charset='utf8')
# 创建游标
cursor = conn.cursor()

# 执行SQL，并返回收影响行数
cursor.execute("select * from user")

# 执行SQL，并返回受影响行数
#effect_row = cursor.execute("update tb7 set pass = '123' where nid = %s", (11,))

# 执行SQL，并返回受影响行数,执行多次
#effect_row = cursor.executemany("insert into tb7(user,pass,licnese)values(%s,%s,%s)", [("u1","u1pass","11111"),("u2","u2pass","22222")])

print(cursor.fetchall())
# 提交，不然无法保存新建或者修改的数据
conn.commit()

# 关闭游标
cursor.close()
# 关闭连接
conn.close()