Home > Database > Mysql Tutorial > Detailed explanation of Mysql5.7.19 installation tutorial under Centos7

Detailed explanation of Mysql5.7.19 installation tutorial under Centos7

黄舟
Release: 2017-09-14 11:32:26
Original
1232 people have browsed it

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
Copy after login

2. Create mysql user group and user

l Create mysql user group


#groupadd mysql
Copy after login

l Create a mysql user under the mysql user group


#useradd mysql -g mysql
Copy after login

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
Copy after login

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
Copy after login

7. Create a data directory

Create a data directory under /data/mysql


#mkdir /data/mysql/data
Copy after login

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/
Copy after login

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


#chmod -R 755 mysql/
Copy after login

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
Copy after login

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
Copy after login

11. Start the mysql service


/data/mysql/support-files/mysql.server start
Copy after login

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


#mysql -u root -p
Copy after login

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
Copy after login

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
Copy after login
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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template