Centos7 installation mysql5.7.16 database instance analysis

Version: mysql-5.7.16-1.el7.x86_64.rpm-bundle.tar

Note: You need to confirm the current system before installation Is there MySQL? If so, it must be uninstalled (centos7 comes with MariaDB database, so the first step is to uninstall the database)

View the MySQL database:

rpm -qa | grep -i mysql

Uninstall the MySQL database:

rpm -e [mysql文件名]

If there are associated files, they cannot be uninstalled directly. You can use the following command to force uninstall

rpm -e --nodeps [mysql文件名]

1. Copy mysql-5.7.16-1.el7.x86_64.rpm-bundle.tar to /home/ (install software under linux , generally you need to copy the files to the home directory)

cp mysql-5.7.16-1.el7.x86_64.rpm-bundle.tar /home/

2. Unzip the files

tar -xvf mysql-5.7.16-1.el7.x86_64.rpm-bundle.tar

The following are all the rpm files extracted

3. Unzip and install the rpm file

1. Generally, you only need to install the following files

2. Next, use the commands to decompress the rpm files one by one and install them.

Note: There is a detail that you need to pay attention to. The above files are also included in the installation. Sequentially, he has corresponding priority. So you need to unzip and install one by one in the following order

mysql-community-common-5.7.16-1.el7.x86_64
mysql-community-libs-5.7.16-1.el7.x86_64
mysql-community-client-5.7.16-1.el7.x86_64
mysql-community-server-5.7.16-1.el7.x86_64
mysql-community-devel-5.7.16-1.el7.x86_64

4. After the installation is successful, start the mysql service

systemctl start mysqld.service

5. Check the 3306 port Whether to enable

netstat -ln | grep 3306

6. Modify the my.cnf configuration file

1. This step requires finding my.cnf document. The default path of the my.cnf file is /etc/my.cnf

2. Edit my.cnf

vim /etc/my.cnf

3. Press 'i' to enter After inserting the mode, insert the following code

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
validate_password=off
default-storage-engine=innodb
character-set-server=utf8
collation-server=utf8_general_ci

Note: validate_password=off means to turn off the password verification plug-in (this sentence must be added, because if it is not added when changing the password, it will Very troublesome).

4. Save and exit (press 'esc', then enter ':wq')

5 Restart the mysql service

systemctl restart mysqld.service

7. This step is particularly important. Each previous step must be carefully tested and executed successfully.

1. Initialization table

/user/sbin/mysqld --initialize --user=mysql

2. After initialization, a mysql zero-time login password will be generated, so where can I check it? The log path configured earlier in the my.cnf file is log-error=/var/log/mysqld.log. Check the mysqld.log log under this path and find the zero-hour password

cat /var/log/mysqld.log |grep password

3. According to Use the zero-hour password to re-modify the password of the mysql database

mysql_secure_installation

4. After pressing Enter, he will ask you to enter the password. You only need to enter the zero-hour password.

5. After entering the correct password, enter the new password and confirm.

8. After successfully changing the password, you can log in to mysql

The above is the detailed content of Centos7 installation mysql5.7.16 database instance analysis. For more information, please follow other related articles on the PHP Chinese website!