10.3.7-MariaDB-log MariaDB Server 安装记录
linux 系统
无脑安装
- sudo yum install -y redhat-lsb
- sudo yum install -y net-tools
- 关闭selinux设置机器名
sudo setenforce 0
sudo vi /etc/selinux/config 下的 SELINUX=disabled
sudo /usr/sbin/sestatus -v
hostnamectl set-hostname db-publicCloud - 配置 MariaDB 10.3 yum:sudo vi /etc/yum.repos.d/MariaDB.repo
#MariaDB 10.3 CentOS repository list - created 2018-06-01 02:02 UTC
#http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1 - yum安装MariaDB
sudo yum -y install MariaDB-server MariaDB-client - 修改密码,设置远程登陆
mysqladmin -u root password “123456ABCD!@#$%^”
mysql_secure_installation - 登录mysql,修改权限,创建用户
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘123456ABCD!@#$%^’ WITH GRANT OPTION;
FLUSH PRIVILEGES; - 修改mariadb的配置文件
sudo vim /etc/my.cnf.d/server.cnf
[mysqld]
datadir=/home/mariadb
slow_query_log=on
slow_query_log_file=/home/mariadb/slow_query_log.log
long_query_time=10
max_allowed_packet=512M
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
lower_case_table_names=0 - 创建文件夹:mkdir /home/mariadb
- 备份文件
cp -R /var/lib/mysql/mysql /var/lib/mysql/mysql.bak_20190910
cp -R /var/lib/mysql/* /home/mariadb/
sudo chown -R mysql:mysql /home/mariadb
chmod 755 -R /home/mariadb - 修改service文件
vim /usr/lib/systemd/system/mariadb.service
[service]
ProtectHome=false - 启动mariadb并登录
systemctl start mariadb
报错不用理,直接客户端测试连接
遇到的问题
MySQL 设置root密码报错:mysqladmin: connect to server at ‘localhost’ failed
执行:mysqladmin -u root password “ych23456”
解决方案:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)