Redhat8安装配置mysql，以及Python简单mysql操作

'''

刚刚开始接触linux、mysql、python，打算开始三线并行学习，希望自己能坚持下去！

配置环境：

        redhat：Red Hat 8.5.0-10

        mysql：8.0.26-1.module_el8.4.0+915+de215114

        python：3.10.8

'''

一. 服务器端安装mysql

1.配置yum，直接下载的阿里centos8的repo；

[root@luffy yum.repos.d]# wget http://mirrors.aliyun.com/repo/Centos-8.repo

2.查看mysql相关的可用包；

[root@luffy yum.repos.d]# yum list mysql*

执行命令显示：

 3.安装mysql-devel.x86_64、mysql-server.x86_64，其它依赖包yum会自动安装；

[root@luffy /]# yum -y install mysql-devel.x86_64 

[root@luffy /]# yum -y install mysql-server.x86_64

4.查看已安装的包；

[root@luffy /]# yum list installed mysql*

执行命令显示：

二. 配置mysql服务器

1.配置mysql-server.cnf

[luffy@localhost ~]$ vim /etc/my.cnf.d/mysql-server.cnf

2.设置服务器端字符格式及引擎

[mysqld]
character_set_server=utf8
default-storage-engine=INNODB

三. 服务相关操作

1.启动服务

[luffy@localhost ~]$ systemctl start mysqld.service

2.查看状态

[luffy@localhost ~]$ systemctl status mysqld.service 

3.停止服务

[luffy@localhost ~]$ systemctl stop mysqld.service 

4.开机启动

[luffy@localhost ~]$ systemctl enable mysqld.service

5.配置生效

[luffy@localhost ~]$ systemctl daemon-reload

四. mysql登录配置

1.进入mysql命令行，刚安装完不需要密码，设置密码后直接在-p后输入密码

[luffy@localhost ~]$ mysql -u root -p

2.选择数据库mysql，mysql>模式下命令后不要忘了";"

mysql> use mysql;

3.配置远程用户

mysql> update user set host='%' where user='root';

4.设置用户密码

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

5.查看用户

mysql> select host,user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | root             |
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
+-----------+------------------+
4 rows in set (0.00 sec)

6.退出mysql命令行

mysql> exit

五. 关闭、禁用防火墙

[luffy@localhost ~]$ systemctl stop firewalld.service 

[luffy@localhost ~]$ systemctl disable firewalld.service

六. python连接数据库

1.添加数据行

import pymysql
import SpiderDcd
spider = SpiderDcd.SpiderDcd()
car_list = spider.go()

db = pymysql.connect(
    host = '192.168.72.200',
    user = 'root',
    password = '123456',
    database = 'mysql',
    charset = 'utf8'
)

try:
    cursor = db.cursor()
    for car in car_list:
        sql = f'''insert into car(car_url,car_name,car_price,car_score) values ("{car['car_url']}","{car['car_name']}","{car['car_price']}","{car['car_score']}")'''
        print(sql)
        cursor.execute(sql)
        db.commit()

    cursor.close()
    db.close()
    print('Yes!')
except Exception as e:
    print(e)

2.查询并打印出数据 

import pymysql
mysql_connect = pymysql.connect(
    host = '192.168.72.200',
    user = 'root',
    password = '123456',
    database = 'mysql',
    charset = 'utf8'
)
cursor = mysql_connect.cursor()
sql = 'select * from car'
cursor.execute(sql)
results = cursor.fetchall()
cursor.close()
mysql_connect.close()
print(results)