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
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!