yum安裝
yum -y install mariadb mariadb-server
啟動mariadb
systemctl start mariadb
設(shè)置開機啟動
systemctl enable mariadb
修改密碼
mysqladmin -uroot -p password 123456
允許遠程訪問
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
配置參數(shù)
在/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
