准备工作

下载mysql-5.7.22-linux-glibc2.12-x86_64.tar包

安装

解压生成文件夹

        1. tar -xvf  mysql-5.7.22-linux-glibc2.12-x86_64.tar

        2. tar -zxvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz

        3. cp -r mysql-5.7.22-linux-glibc2.12-x86_64 /usr/local/mysql

添加用户组和用户

        1. groupadd mysql

        2.useradd -r -g mysql mysql

        3. cd /usr/local/mysql

        4.chown -R mysql:mysql ./

初始化数据库

        1.bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

        2.记录临时密码

配置my.cnf

    [mysqld]

    basedir=/usr/local/mysql

    datadir=/usr/local/mysql/data

    socket=/tmp/mysql.sock

    lower_case_table_names = 1

    log-error=/var/log/mysqld.log

    pid-file=/usr/local/mysql/data/mysqld.pid

添加开机自启动

    1. cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

    2. vi mysql

        在64行添加

        basedir=/usr/local/mysql

        datadir=/usr/local/mysql/data

启动mysql服务

    service mysql start

登录并修改root密码

    1.mysql -uroot -pISW-UJ2qegh, 【要完整】

    2.alter user 'root'@'localhost' identified by 'root'

    3.flush privileges;

用新密码重新登录

    1.mysql -uroot -proot;