yum安装
yum -y install mariadb mariadb-server
启动mariadb
systemctl start mariadb
设置开机启动
systemctl enable mariadb
修改密码
mysqladmin -uroot -p password 123456
允许远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
配置参数
在/etc/my.cnf中添加
sql_mode='NO_ENGINE_SUBSTITUTION'
skip-name-resolve
character-set-server=utf8
lower_case_table_names=1
max_connections=1000
my.cnf
