CentOS MariaDB配置
启动Mariadb
前提需安装mariadb-server
- 安装mariadb-server
yum install -y mariadb-server
- 启动服务
systemctl start mariadb.service
- 添加到开机启动
systemctl enable mariadb.service
- 安全设置,以及修改数据库管理员密码
mysql_secure_installation
- 启动MariaDB
- 正常启动
- systemctl start mariadb
- service mariadb start
- 设置开机启动
- systemctl enable mariadb
- chkconfig mariadb on
配置MariaDB的字符集
- 设置客户端:
vim /etc/my.cnf.d/mysql-clients.cnf
[mysql]
default-character-set=utf8
- 设置服务端:
vim /etc/my.cnf.d/server.cnf
[mysqld]
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci
skip-character-set-client-handshake
[开启慢查询]
slow_query_log = ON
slow_query_log_file = /usr/local/mysql/data/slow.log
long_query_time = 1
本文来自博客园,作者:OCEANEYES.GZY,转载请注明原文链接:https://www.cnblogs.com/oceaneyes-gzy/p/12317419.html
关于作者
👋 读书城南,🤔 在未来面前,我们都是孩子~
- 📙 一个热衷于探索学习新方向、新事物的智能产品经理,闲暇时间喜欢coding💻、画图🎨、音乐🎵、学习ing~
👋 Social Media
🛠️ Blog: http://oceaneyes.top
⚡ PM导航: https://pmhub.oceangzy.top
☘️ CNBLOG: https://www.cnblogs.com/oceaneyes-gzy/
🌱 AI PRJ自己部署的一些算法demo: http://ai.oceangzy.top/
📫 Email: 1450136519@qq.com
💬 WeChat: OCEANGZY
- 💬 公众号: UncleJoker-GZY