Last updated
[mysqld]
# 设置3306端口
port=3306
# 设置mysql的安装目录
basedir=D:\Program Files\MySQL
# 设置mysql数据库的数据的存放目录
datadir=D:\Program Files\MySQL\Data
# 允许最大连接数
max_connections=200
# 允许连接失败的次数。
max_connect_errors=10
# 服务端使用的字符集默认为UTF8
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 默认使用“mysql_native_password”插件认证
#mysql_native_password
default_authentication_plugin=mysql_native_password
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8CD \d D:/mysqld --initialize --consoleD:\Program Files\mysql\bin>mysqld --initialize --console
2019-02-14T11:47:59.282979Z 0 [System] [MY-013169] [Server] D:\Program Files\mysql\bin\mysqld.exe (mysqld 8.0.15) initializing of server in progress as process 13752
2019-02-14T11:47:59.284705Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2019-02-14T11:48:40.707445Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 7CwffH5<(lem
2019-02-14T11:49:02.894787Z 0 [System] [MY-013170] [Server] D:\Program Files\mysql\bin\mysqld.exe (mysqld 8.0.15) initializing of server has completedmysqld --install [服务名]mysql -u root -pALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';CREATE DATABASE iodata;
use iodata;
/*show tables;
create table teacher
(
code varchar(20) primary key,
name varchar(20)
);*/
CREATE TABLE user_info
(
ID int NOT NULL AUTO_INCREMENT,/* 设置自动加的用户ID*/
user_id VARCHAR(200) NOT NULL,/*支持中英文200个字符的用户字符串*/
user_pass VARCHAR(200) NOT NULL,
user_create datetime(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
user_modified datetime(3) NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
PRIMARY KEY (ID)/* 设置主键*/
);use iodata;
CREATE USER 'porter'@'localhost' IDENTIFIED BY 'shuruniziji_mima';/* 创建用户 */
INSERT INTO iodata.user_info ( user_id, user_pass)
VALUES
( 'porter', '123');
grant all privileges on *.* to 'porter'@'%'; /* 放行用户的所有权限并允许远程网络连接 */# -*- coding:utf-8 -*-
import pymysql
import sys
def get_db_data():
connect = pymysql.Connect(
host="210.28.33.2",
port=3306,
user="porter",
passwd="smrit",
db="iodata",
charset='utf8'
)
print("写入中，请等待……")
cursor = connect.cursor()
sql = "select * from user_info"
cursor.execute(sql)
number = cursor.fetchall()
print(number)
cursor.close()
connect.close()
if __name__ == "__main__":
get_db_data()use iodata;
CREATE TABLE Images(Id INT PRIMARY KEY AUTO_INCREMENT, Data MEDIUMBLOB);# -*- coding:utf-8 -*-
import pymysql
import matplotlib.pyplot as plt
import matplotlib.image as mpimg # mpimg 用于读取图片
import sys
def get_loan_number(file):
connect = pymysql.Connect(
host="210.28.33.2",
port=3306,
user="porter",
passwd="smriti",
db="iodata",
charset='utf8'
)
print("写入中，请等待……")
cursor = connect.cursor()
sql = "select Data from images LIMIT 1"
cursor.execute(sql)
fout = open('2.jpg','wb')
image_file = cursor.fetchone()[0]
fout.write(image_file)
fout.close()
cursor.close()
connect.close()
print("写入完成,共写入%d条数据……" % 1)
if __name__ == "__main__":
# file = r"C:\Users\test\Desktop\loanNUmber.txt"
file = "task1.txt"
get_loan_number(file)# -*- coding:utf-8 -*-
import pymysql
def get_loan_number(file):
connect = pymysql.Connect(
host="106.14.221.55",
port=3306,
user="nadersidc",
passwd="366583",
db="defect_detecting",
charset='utf8'
)
print("写入中，请等待……")
cursor = connect.cursor()
# sql = "select id from application where status='SUBMITTING' and contract like 'Performance-%' and " \
# "loan_org_party='166490194444444444'"
# sql = "select Element.Id,Element.FileName,DefectPosition.TopX,DefectPosition.TopY,\
# DefectPosition.Width,DefectPosition.Height from Element,DefectPosition where Element.DefectId=6 \
# and Element.ImageTypeId=2 and DefectPosition.ElementId=Element.Id"
# sql = "select * from Element LIMIT 1,5"
# sql = "select * from * LIMIT 1,5"
# 查询数据库表中所有的表名字
# sql = "select table_name from information_schema.tables where table_schema='defect_detecting'"
sql = "select * from TrainProject LIMIT 1,5"
cursor.execute(sql)
number = cursor.fetchall()
fp = open(file, "w")
loan_count = 0
for loanNumber in number:
loan_count += 1
fp.write(str(loanNumber)+'\n')
fp.close()
cursor.close()
connect.close()
print("写入完成,共写入%d条数据……" % loan_count)
if __name__ == "__main__":
# file = r"C:\Users\test\Desktop\loanNUmber.txt"
file = "task2.txt"
get_loan_number(file)