文件名my.cnf.ini



[DEFAULT]

[client]

port = 3306

socket = /data/mysql_3306/mysql.sock

[mysqld]

explicit_defaults_for_timestamp = true

port = 3306

socket = /data/mysql_3306/mysql.sock

back_log = 80

basedir = /usr/local/mysql

tmpdir = /tmp

datadir = /data/mysql_3306

default-time-zone = '+8:00'

import configparser

config =configparser.ConfigParser() #初始化实例

config.read('my.cnf.ini')#读取配置文件

print(config.sections())#读取模块名到列表中，也就是[]中的内容

print(config.default_section)
>['client', 'mysqld']
#----------------------------------------------------------------------

```py

>>> import configparser # 导入模块

>>> config = configparser.ConfigParser()  #实例化(生成对象)

>>> config.sections()  #调用sections方法

[]

>>> config.read('example.ini')  # 读配置文件(注意文件路径)

['example.ini']

>>> config.sections() #调用sections方法(默认不会读取default)

['bitbucket.org', 'topsecret.server.com']

>>> 'bitbucket.org' in config #判断元素是否在sections列表内

True

>>> 'bytebong.com' in config

False

>>> config['bitbucket.org']['User'] # 通过字典的形式取值

'hg'

>>> config['DEFAULT']['Compression']

'yes'

>>> topsecret = config['topsecret.server.com']

>>> topsecret['ForwardX11']

'no'

>>> topsecret['Port']

'50022'

>>> for key in config['bitbucket.org']: print(key) # for循环 bitbucket.org 字典的key

...

user

compressionlevel

serveraliveinterval

compression

forwardx11

>>> config['bitbucket.org']['ForwardX11']

'yes'

```

#----------------------------------------------------------------------------

# 修改时区 default-time-zone = '+8:00' 为 校准的全球时间 +00:00

config['mysqld']['default-time-zone'] = '+00:00'

config.write(open('my.cnf.ini','w'))

# 删除 explicit_defaults_for_timestamp = true

config.remove_option('mysqld','explicit_defaults_for_timestamp = true')

config.write(open('my.cnf.ini','w'))

# 为DEFAULT增加一条 character-set-server = utf8

config['DEFAULT']['character-set-server'] = 'utf8'

# 与上面的语法效果一样config,set('DEFAULT','character-set-server','utf8')

 config.write(open('my.cnf.ini','w'))

#------------------------------------------------------------------------------------

```python

[group1] # 支持的两种分隔符“=”, “:”

k1 = v1

k2:v2

[group2]

k1 = v1

import ConfigParser

config = ConfigParser.ConfigParser()

config.read('i.cfg')

# ########## 读 ##########

#secs = config.sections()

#print(secs)

#options = config.options('group2') # 获取指定section的keys

#print(options)

#item_list = config.items('group2') # 获取指定 section 的 keys & values ,key value 以元组的形式

#print(item_list)

#val = config.get('group1','key') # 获取指定的key 的value

#val = config.getint('group1','key')

# ########## 改写 ##########

#sec = config.remove_section('group1') # 删除section 并返回状态(true, false)

#config.write(open('i.cfg', "w")) # 对应的删除操作要写入文件才会生效



#sec = config.has_section('wupeiqi')

#sec = config.add_section('wupeiqi')

#config.write(open('i.cfg', "w")) # 

#config.set('group2','k1',11111)

#config.write(open('i.cfg', "w"))

#config.remove_option('group2','age')

#config.write(open('i.cfg', "w"))

```

#-------------------------------------------------------------------------

[DEFAULT]

character-set-server = utf8

[client]

port = 3306

socket = /data/mysql_3306/mysql.sock

[mysqld]

explicit_defaults_for_timestamp = true

port = 3306

socket = /data/mysql_3306/mysql.sock

back_log = 80

basedir = /usr/local/mysql

tmpdir = /tmp

datadir = /data/mysql_3306

default-time-zone = +00:00