环境搭建-Linux-Mysql安装-10.3.7-MariaDB-log MariaDB Server

10.3.7-MariaDB-log MariaDB Server 安装记录

linux 系统

• CentOS7

无脑安装

• 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 “[email protected]#$%^”
  mysql_secure_installation
• 登录mysql，修改权限，创建用户
  GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘[email protected]#$%^’ 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”

解决方案：

• 停止MySQL服务
  systemctl stop mysqld.service
  

• 安全模式启动
  mysqld_safe --skip-grant-tables &
  

• 无密码root帐号登录
  

• 手动update修改密码