python连接linux的数据库最简单的方法

 一、在linux系统安装数据库mysql

1.配置mysql的yum源

[root@localhost ~]#rpm -ivh https://repo.mysql.com//mysql80-community-release-el7-11.noarch.rpm

2.安装mysql

[root@localhost ~]#yum install mysql-server

3.开启mysql

[root@localhost ~]#systemctl start mysqld
[root@localhost ~]#systemctl enable mysqld

 4.修改mysql的密码

安装mysql会自动生成一个root用户，我们需要对其初始密码进行修改

[root@localhost ~]#grep 'temporary password' /var/log/mysqld.log
[root@localhost ~]#mysql -uroot -p123456
mysql> alter user 'root'@'localhost' identified by '123456';

5. 开放远程连接

mysql> use mysql;
mysql> update user set user.Host='%' where user.User='root';
mysql> flush privileges;

 6.创建数据库

mysql> create database book;
mysql> exit；

 7.永久关闭selinux

[root@localhost ~]# vim /etc/selinux/config
SELINUX=disabled

8.关闭防火墙

[root@localhost ~]# service firewalld stop  关闭防火墙服务
Redirecting to /bin/systemctl stop firewalld.service

 二、pymysql

import pymysql
#打开数据库连接
conn = pymysql.connect(host="192.168.187.128", user="root", password="123456", database="book", charset="utf8")
#获取游标 即使用cursor()方法创建一个游标对象 cursor
cursor=conn.cursor()
#创建pythonDB数据库
cursor.execute('CREATE DATABASE IF NOT EXISTS pythonDB;')
cursor.close()#先关闭游标
conn.close()#再关闭数据库连接
print('创建pythonBD数据库成功')