mariadb 安装配置

1、安装

mariadb-install-db.exe
mysqld install

　　

2、修改utf8编码

[mysqld]
default-storage-engine = innodb
innodb_file_per_table
max_connections = 4096
collation-server = utf8_general_ci
character-set-server = utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

　　

3、重启服务修复数据库

net stop mysql
net start mysql
mysqlcheck -u root -p --auto-repair --optimize --all-databases