MySQL 5.7安装和简要配置

基于CentOS 7搭建MySQL Community 5.7
官网：https://www.mysql.com/products/community/

install

卸载

• 检测是否已安装
  rpm -qa | grep mysql

可能返回

 mysql-community-common-5.7.29-1.el7.x86_64
  mysql-community-server-5.7.29-1.el7.x86_64
  mysql-community-libs-5.7.29-1.el7.x86_64
  mysql57-community-release-el7-11.noarch
  mysql-community-libs-compat-5.7.29-1.el7.x86_64
  mysql-community-client-5.7.29-1.el7.x86_64

• 先停服务
  systemctl stop mysqld
• 执行rpm删除
  rpm -ev mysql　　// 普通删除模式
  也可以挨个执行
  rpm -ev mysql-community-common-5.7.29-1.el7.x86_64
• 查找mysql目录和文件
  find / -name 'mysql'
  当然，也可以直接找到的同时删除，风险系数较大
  find / -name 'mysql' -exec rm -rf {} \;
  最后删除配置文件/etc/my.cnf

安装

rpm -ivh mysql57-community-release-el7-11.noarch.rpm
yum update
yum install mysql-server
mkdir -p /var/lib/mysql/data
mysqld --initialize
vim /etc/my.cnf

    [mysqld]
    basedir=/var/lib/mysql
    datadir=/var/lib/mysql/data
    socket=/var/lib/mysql/mysql.sock

    user=mysql
    port=3306
    character-set-server=utf8
    collation-server=utf8_general_ci
    # skip-grant-tables
    symbolic-links=0

    log-error=/var/log/mysql/mysqld.log
    # log-error=/var/lib/mysql/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
systemctl restart mysqld

自启

# 查询当前系统的服务启动和服务状态
systemctl list-unit-files | grep    mysql
# 禁止
systemctl disable mysqld
# 启用
systemctl enable mysqld

忘记root密码

vim /etc/my.cnf
    [mysqld]
    skip-grant-tables # 放开注释
mysql -uroot 
# 更新密码
update user set authentication_string=password("deploy") where user='root';
exit
mysql -uroot -pdeploy
# 再更新密码，MySQL策略规定
alter user 'root'@'localhost' identified by '1q2w3e!@#A'