使用yum安装MariaDB文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
yum install -y mariadb-server
启动MariaDB文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
systemctl start mariadb
设置MariaDB开机自启动文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
systemctl enable mariadb
首次安装需要进行数据库的配置,命令都和mysql的一样文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
mysql_secure_installation
设置MariaDB字符集为utf-8文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
vim /etc/my.cnf
在[mysqld]标签下添加文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
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-handshake
vim /etc/my.cnf.d/client.cnf文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
在 [client] 标签下添加文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
default-character-set=utf8
/etc/my.cnf.d/mysql-clients.cnf文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
在 [mysql] 标签下添加文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
default-character-set=utf8
重启服务文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
systemctl restart mariadb
查看默认编码文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
show variables like "%character%";show variables like "%collation%";
设置MariaDB远程登录文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
先查看mysql数据库中的user表文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
use mysql;
select host, user from user;
将与主机名相等的字段改为 "%"文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
update user set host='%' where host='localhost'
刷新权限表文章源自菜鸟学院-https://www.cainiaoxueyuan.com/yunwei/46940.html
flush privileges;