MySQL 5.7 small version upgrade

MySQL 5.7 small version upgrade

---

1. Operating environment

operating system:CentOS 7.6

Old versionmysql：5.7.23

New version of mysql: 5.7.29

---

2. Operation steps

1. Stop the database and back up the database directory (/usr/local/mysql/data) (or export the database into a sql file, which is suitable for small amount of data)

#The backup database directory is used here

    service mysql stop

    cp -r /usr/local/mysql  /usr/local/

2. Delete all files under the previous mysql installation directory /usr/local/mysql

    cd /usr/local /mysql        

    rm -rf *

3. Unzip the mysql installation package and copy the package contents to the /usr/local/mysql directory

    tar zxvf mysql-5.7.29-linux-glibc2.12-x86_64.

    cd mysql-5.7.29-linux-glibc2.12-x86_64

    cp -r *  /usr/local/mysql

    chown mysql:mysql  /usr/local/mysql

4. Create a data directory and grant authority

    mkdir data/ && chown mysql:mysql data/

5. Initialize mysql

    cd /usr/local/mysql/bin

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

6. Import data into the data directory

  /usr/bin/cp  -r  /usr/local//data/*   /usr/local/mysql/data

  chown -R mysql:mysql  /usr/local/mysql/data

## Make sure mysql is started successfully and delete the files in the data directory

7. Start mysql service

service mysql start

ps: Change password

set password = PASSWORD('*******');