Introduction to the installation method of Mysql5.7.19 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 in mysql Create mysql user under the user group

#useradd mysql -g mysql

3. Determine the installation directory and data directory

My The 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

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