yum安装MariaDB设为开机自启动教程
使用yum安装MariaDB
yum install -y mariadb-server启动MariaDB
systemctl start mariadb 设置MariaDB开机自启动
systemctl enable mariadb首次安装需要进行数据库的配置，命令都和mysql的一样
mysql_secure_installation
设置MariaDB字符集为utf-8
vim /etc/my.cnf在[mysqld]标签下添加
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshakevim /etc/my.cnf.d/client.cnf
在 [client] 标签下添加
default-character-set=utf8/etc/my.cnf.d/mysql-clients.cnf
在 [mysql] 标签下添加
default-character-set=utf8重启服务
systemctl restart mariadb查看默认编码
show variables like "%character%";show variables like "%collation%";设置MariaDB远程登录
先查看mysql数据库中的user表
use mysql;
select host, user from user;
将与主机名相等的字段改为 "%"
update user set host='%' where host='localhost'刷新权限表
flush privileges; THE END
