卸载mariadb

  1. [root@mysql01 ~]# yum remove mariadb-config mariadb-common mariadb-libs

下载MySQL

  1. [root@mysql01 ~]# yum -y install wget && wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz 
  2. #下载可能会有点慢，可以先下载好通过xftp上传上去

开始安装MySQL

  2. [root@mysql01 ~]# cd /opt && tar xzf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz
  3. [root@mysql01 ~]# mv mysql-5.7.18-linux-glibc2.5-x86_64 /usr/local/
  4. [root@mysql01 ~]# groupadd mysql
  5. [root@mysql01 ~]# useradd  -r  -g mysql -s /bin/false mysql
  6. [root@mysql01 ~]# cd /usr/local
  7. [root@mysql01 ~]# ln -s mysql-5.7.18-linux-glibc2.5-x86_64 mysql
  8. [root@mysql01 ~]# chown -R mysql.mysql /usr/local/mysql-5.7.18-linux-glibc2.5-x86_64
  9. [root@mysql01 ~]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/
  10. [root@mysql01 ~]# mkdir /data/mysql3306
  11. [root@mysql01 ~]# chown -R mysql.mysql /data/mysql3306/
  12.  #上传my.cnf配置文件到/etc/下
  13. [root@mysql01 ~]# cd /usr/local/mysql && bin/mysqld --initialize --user=mysql

启动数据库

  1. [root@mysql01 ~]# /etc/init.d/mysql.server start

过滤临时密码

  1. [root@mysql01 ~]# grep "root@localhost:" /data/mysql3306/error.log

修改密码

  1. [root@mysql01 ~]# mysqladmin -u root -p password "test123"
  2. Enter password: 【输入原来的密码】