linux安装mysql

liunx下载mysql:
    下载mysql包：
        wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
    安装mysql包：
        yum -y install mysql57-community-release-el7-10.noarch.rpm
    安装mysql：
        yum -y install mysql-community-server --nogpgcheck
    启动mysql：
        systemctl start mysql.service
    系统启动时启动mysql：
        systemctl enable mysql.service
    查看mysql是否启动：
        systemctl status mysql.service
mysql密码设置：
    set password for 'root'@'localhost'=password('123')
    如果报： Your password does not satisfy the current policy requirements,密码不符合规定：
    用：
        set global validate password policy=0;
        set global validate password mixed case count=0;
        set global validate password number count: 3;
        set global validate password special char count=0;
        set global validate password length=3;
    之后从新执行即可：
    成功后执行flush privileges;

create database h2209;
use h2209;
show tables;
create table yu(id int,name varchar(20));

import pymysql
con = pymysql.connect(host = '127.0.0.1',port=3306,user='root',database='h2209',password='123')
conn=con.cursor()
sql="""insert into yu value(1,'lisi')"""
conn.execute(sql)
sql="""select id,name from stu"""
conn.execute(sql)
ui=conn.fetchall()
for i in ui:
    print(ui)
sql="""update stu set name='zhangsan' where id=1"""
conn.execute(sql)
sql = """delete from su where id=1"""
conn.execute(sql)
con.commit()
conn.close()