mariadb安装

2018-08-22 本文已影响0人 gentel_liao

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