准备工作: 1.在本地虚拟机172.16.0.115上安装mysql，并设置权限如下
mysql> grant all privileges on *.* to root@"%" Identified by "Mypassword4!"; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.01 sec)2.在pycharm所在ubuntu虚拟机上验证是否可以访问172.16.0.115上的mysql
hanli@ubuntu:~$ mysql -h 172.16.0.115 -u root -pMypassword4!`3.代码如下：
import mysql.connector # 连接到数据库: conn = mysql.connector.connect(host='172.16.0.115', user='root', password='Mypassword4!', database='test') # 连接到数据库后，需要打开游标，称之为Cursor，通过Cursor执行SQL语句，然后，获得执行结果 cursor = conn.cursor() # 创建user表: cursor.execute('create table user (id varchar(20) primary key, name varchar(20))') # 插入一行记录，注意MySQL的占位符是%s: cursor.execute('insert into user (id, name) values (%s, %s)', ('1', 'Michael')) print('rowcount =', cursor.rowcount) # 提交事务: conn.commit() cursor.close() # 运行查询: cursor = conn.cursor() cursor.execute('select * from user where id = %s', ('1',)) values = cursor.fetchall() print(values) # 关闭Cursor和Connection: cursor.close() conn.close()执行结果：
rowcount = 1 [('1', 'Michael')]转载于:https://www.cnblogs.com/fanren224/p/8457223.html
