Ubuntu MySQL version upgraded to 5.7

A few days ago, the library said that the server (Ubuntu 14.04) had a security vulnerability and would be shut down if it was not repaired on time.

After looking at the vulnerability list, I found that the main issues were with the ssh and mysql versions.

I upgraded MySQL to 5.7. I backed up the data before the upgrade, but found that the data was not lost after the upgrade.

1 Configure mysql-apt and make relevant updates

sudo wget https://dev.mysql.com/get/mysql-apt-config_0.8.1-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.1-1_all.deb #Select mysql5.7 during the installation process

sudo apt-get update
 

2 Install the new version of the database and update the file version

sudo apt-get install mysql-server
sudo mysql_upgrade -uroot -p

3 Restart mysql and check the data

sudo service mysql restart
mysqlcheck -uroot -p --all-databases

4 Modify user directory and remote login configuration

# Modify the user directory sudo service mysql stop
sudo usermod -d /var/lib/mysql/mysql
sudo service mysql start

# Comment out the line bind-address = 127.0.0.1 and save it sudo vim /etc/mysql/mysql.conf.d/mysqld.conf

# Restart sudo service mysql restart

5 Check the mysql version to see if it is started successfully

mysql --version
netstat -anp | grep 'mysql'

6 Remote connection to mysql

mysql -h ip -u root -p

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.