前言#

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

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

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

Mariadb#

查看是否安装过Mariadb#

1
$ rpm -qs | grep mariadb

安装并启动Mariadb#

1
$ yum install mariadb mariadb-server
2

3
$ systemctl enable mariadb
4
$ systemctl start mariadb

安全设置#

1
$ mysql_secure_installation

远程访问#

1
$ mysql -u root -h localhost -p "mypassword"
2
Mariadb root@localhost:mysql> UPDATE user SET host='%' WHERE user='root';
3
Mariadb root@localhost:mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
4
Mariadb root@localhost:mysql> FLUSH PRIVILEGES;

关闭防火墙#

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

1
$ systemctl stop firewalld.service

卸载Mariadb#

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

Python 连接 Mariadb#

1
import mysql.connector as conn
2

3
db = conn.connect(
4
    host = 'myIP',
5
    port = 'myPort',
6
    user = 'root',
7
    password = 'myPassword',
8
    database = 'myDB'
9
)
10

11
cursor = db.cursor()

REFERENCE#

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