Install MySQL 5.7.18 using rpm package under CentOS 7

I have been using MySQL recently. The article mysql-installation under Linux wrote about using other methods to install MySQL. This time I mainly used the rpm format to install it. After trying it, I felt that this installation mode was simpler.

Uninstall MariaDB

CentOS7 installs MariaDB instead of MySQL by default. There may be a conflict between MariaDB database and MySQL, so uninstall MariaDB first.

1. Check the installed MariaDB related packages
rpm -qa | grep mariadb
2. Check the installed MariaDB related yum packages. The packages need to be determined according to the results of the rpm command.
yum list mariadb-libs
3. Remove the installed MariaDB related yum packages. The package name needs to be determined according to the result of the yum list command. This step requires root privileges.
yum remove mariadb-libs

Download mysql rpm package

Below is the download address of the official website:
https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar

Install mysql using rpm

The following steps require root privileges. There are dependencies between packages, so the rpm commands must be executed in sequence.

mkdir mysql
tar -xv -f mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar -C mysql
cd mysql
rpm -ivh mysql-community-common-5.7.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.18-1.el7.x86_64.rpm

Problems:

1) libaio.so.1()(64bit) is needed by MySQL-server

Solution:

Install libaio-0.3.107-10.el6.x86_64.rpm

①Download address:

http://mirror.centos.org/centos/6/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm

②Execute: rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm

2) net-tools is needed

Solution:

yum install net-tools

3) perl (Getopt::Long) is needed by mysql-community-server-5.7.18-1.el7.x86_64

Solution:

yum install perl

After successful installation, delete the installation files and temporary files, or you can choose not to delete them.

Log in to mysql and change the initial password

The following steps require root privileges.
1. Since you don’t know the password at the beginning, first modify the configuration file /etc/my.cnf to let mysql skip the permission verification when logging in. Add a line:

vi /etc.my.cnf
skip-grant-tables 

2. Change the user and group of the MySQL database directory, and then start mysql

chown -R mysql:mysql /var/lib/mysql/ 
systemctl start mysqld.service //Start the mysql database service

3. Login

mysql -uroot -p

4. Change password

use mysql; 
update user set authentication_string =password('your own password') where host ='localhost' and user='mysql';
quit;

5. Log in again using your password

mysql -uroot -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.