Detailed explanation of Mysql5.7.19 installation tutorial under Centos7

This article mainly introduces the detailed installation tutorial of Mysql5.7.19 under Centos7. The editor thinks it is very good. I hereby share it on the Script Home platform. Friends who need it can refer to it

1. Download

Download mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz from the official website, the version is 5.7.19

Download address:

https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.19-linux-glibc2.12-x86_64.tar.gzLinux

2. Create mysql user group and user

l Create mysql user group

#groupadd mysql

l Create a mysql user under the mysql user group

#useradd mysql -g mysql

3. Determine the installation directory and data directory

My mysql installation directory is /data/mysql, and the data directory is /data/mysql/data.

4. Upload the installation file to the server

putmysql-5.7.19-linux-glibc2.12-x86_64.tar The .gz file is placed in the /data/installfiles directory through the ftp tool.

5. Unzip the tar.gz file/data directory

#cd /data/installfiles
#tar -xvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz

6. Modify the directory name

Rename mysql-5.7.19-linux-glibc2.12-x86_64 to mysql and move it to /usr/local/ under mysql.

#mv mysql-5.7.19-linux-glibc2.12-x86_64 /data/mysql

7. Create a data directory

Create a data directory under /data/mysql

#mkdir /data/mysql/data

8. Authorize the mysql user

Change the mysql directory and the files and subdirectories below Change the file owner to mysql

#cd /data
#chown -R mysql:mysql mysql/

Give the mysql directory and the files and subdirectories below it 755 permission

#chmod -R 755 mysql/

9. Compile, install and initialize mysql, and remember the temporary password

#/data/mysql/bin/mysqld --initialize --user=mysql --datadir=/data/mysql/data --basedir=/data/mysql

The temporary password installed at that time was: root@localhost:3?2YBeSg:Nte

10. Create a log file directory

mkdir -p /data/mysql/log/mariadb/
cd /data/mysql/log/mariadb/
touch mariadb.log
chmod -R 775 mariadb.log
chown -R mysql:mysql mariadb.log
chown -R mysql:mysql /data/mysql

11. Start the mysql service

/data/mysql/support-files/mysql.server start

12. Log in to msyql and enter the password (the password is the initialization password in step 9)

#mysql -u root -p

13. Change the password to “123456”

msql>alter user 'root'@'localhost' identified by '123456';
mysql>use mysql;
msyql>update user set user.Host='%' where user.User='root';
mysql>flush privileges;
mysql>quit

14. Modify the /etc/my.cnf file

##

# instructions in http://fedoraproject.org/wiki/Systemd
socket=/tmp/mysql.sock
[mysqld]
datadir=/data/mysql/data
socket=/tmp/mysql.sock
max_connections=1000
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]
log-error=/data/mysql/log/mariadb/mariadb.log
pid-file=/data/mysql/run/mariadb/mariadb.pid
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

Modify the contents marked in red.

Summarize

The above is the detailed content of Detailed explanation of Mysql5.7.19 installation tutorial under Centos7. For more information, please follow other related articles on the PHP Chinese website!