## 安裝 Mariadb
```
yum -y install mariadb mariadb-server
```
## 安裝 MySQLdb 模塊
```
yum -y install MySQL-python
```
## 基礎 CRUD
```
#!/usr/bin/env python
#-*-coding:utf-8-*-
import MySQLdb
# 連接數據庫
db = MySQLdb.connect("localhost", "root", "root", charset='utf8' )
# 獲取操作游標
cursor = db.cursor()
# 目標數據庫存在則將其刪除
cursor.execute("DROP DATABASE IF EXISTS py_con")
# 創建新數據庫
cursor.execute("CREATE DATABASE py_con;")
# 連接數據庫
cursor.execute("use py_con;")
# 創建數據表
sql_ctb="""CREATE TABLE stu_info(
FIRST_NAME CHAR(20) NOT NULL,
LAST_NAME CHAR(20),
AGE INT,
SEX CHAR(1))"""
cursor.execute(sql_ctb)
# 插入語句
sql_ins = """INSERT INTO stu_info(FIRST_NAME,
LAST_NAME, AGE, SEX)
VALUES ('Moli', 'Sam', 20, 'M')"""
cursor.execute(sql_ins)
# 關閉連接
db.close()
```
via:[python操作mysql數據庫](http://www.runoob.com/python/python-mysql.html)
- Linux Server
- 實用命令
- services
- Samba
- /etc/samba/smb.conf
- NFS
- Http
- httpd.conf
- lamp
- FTP
- /etc/vsftpd/vsftpd.conf
- ftp實例
- iSCSI
- SElinux
- DNS
- master
- slave
- subdomain
- 相關配置文件
- /etc/hosts
- /etc/resolv.conf
- /etc/named.conf
- /var/named/named.ca
- /var/named/named.localhost&named.loopback
- DHCP
- /etc/dhcp/dhcpd.conf
- mysql
- Redis
- Git
- HAProxy
- haproxy
- openssl
- nodejs