3

Python连接MySQL

 2 years ago
source link: https://blog.dicer.fun/2021/03/10/Python%E8%BF%9E%E6%8E%A5MySQL/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client
Python连接MySQL
1 年前发表8 个月前更新3 分钟读完 (大约381个字)4次访问

Python连接MySQL

毕设需要保存大量数据，于是想在服务器上运行一个数据库。

Cent OS 默认的 MySQL是Mariadb版本的，据说这个版本是在MySQL被Oracle并购之后，一些MySQL的老员工考虑到MySQL可能被商用而发行的一个免费开源版本。

$ screenfetch
									 ..                    root@Dicer
                 .PLTJ.                  OS: CentOS 
                <><><><>                 Kernel: x86_64 Linux 3.10.0-957.21.3.el7.x86_64
       KKSSV' 4KKK LJ KKKL.'VSSKK        Uptime: 596d 20h 16m
       KKV' 4KKKKK LJ KKKKAL 'VKK        Packages: 569
       V' ' 'VKKKK LJ KKKKV' ' 'V        Shell: zsh 5.0.2
       .4MA.' 'VKK LJ KKV' '.4Mb.        Disk: 12G / 41G (30%)
     . KKKKKA.' 'V LJ V' '.4KKKKK .      CPU: Intel Xeon E5-2682 v4 @ 2.494GHz
   .4D KKKKKKKA.'' LJ ''.4KKKKKKK FA.    GPU: Cirrus Logic GD 5446
  <QDD ++++++++++++  ++++++++++++ GFD>   RAM: 488MiB / 1838MiB
   'VD KKKKKKKK'.. LJ ..'KKKKKKKK FV    
     ' VKKKKK'. .4 LJ K. .'KKKKKV '     
        'VK'. .4KK LJ KKA. .'KV'        
       A. . .4KKKK LJ KKKKA. . .4       
       KKA. 'KKKKK LJ KKKKK' .4KK       
       KKSSA. VKKK LJ KKKV .4SSKK       
                <><><><>                
                 'MKKM'                 
                   ''

Mariadb

查看是否安装过Mariadb

$ rpm -qs | grep mariadb

安装并启动Mariadb

$ yum install mariadb mariadb-server

$ systemctl enable mariadb
$ systemctl start mariadb
$ mysql_secure_installation
$ mysql -u root -h localhost -p "mypassword"
Mariadb root@localhost:mysql> UPDATE user SET host='%' WHERE user='root';
Mariadb root@localhost:mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
Mariadb root@localhost:mysql> FLUSH PRIVILEGES;

关闭防火墙

如果以上步骤都完成了以后，远程连接超时的话一般都是防火墙的问题，可以将防火墙关闭：

$ systemctl stop firewalld.service

卸载Mariadb

$ yum remove mariadb mariadb-server mariadb-libs
$ rm -rf /var/lib/mysql
$ rm /etc/my.cnf
$ yum install mariadb mariadb-server

Python 连接 Mariadb

import mysql.connector as conn

db = conn.connect(
    host = 'myIP',
    port = 'myPort',
    user = 'root',
    password = 'myPassword',
    database = 'myDB'
)

cursor = db.cursor()

REFERENCE

https://www.linode.com/docs/guides/how-to-install-mariadb-on-centos-7/

Dicer

2021-03-10

2021-07-16


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK