CentOS7操作MariaDB

启动 停止 重启 MariaDB

http://t.zoukankan.com/flyingcr-p-10326886.html

systemctl start mariadb.service #启动MariaDB
systemctl stop mariadb.service #停止MariaDB
systemctl restart mariadb.service #重启MariaDB
systemctl enable mariadb.service #设置开机启动

CentOS上安装的mysql 5.7.18数据库中文变成?的问题

cd /etc修改my.cnf
https://blog.csdn.net/qq_42449963/article/details/108740409

[client]

default-character-set=utf8

[mysqld]

default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

改为重启服务

systemctl restart mariadb.service #重启MariaDB

关闭防火墙

systemctl stop firewalld.service            #停止firewall
systemctl disable firewalld.service         #禁止firewall开机启动