Steps to install MySQL5.7 under CentOS7 (pictures and text)

Steps to install MySQL5.7 under CentOS7

Install necessary components
yum install –y autoconf automake imake libxml2-devel expat-devel cmake gcc gcc-c++ libaio libaio-devel bzr bison libtool ncurses5-devel

Download mysql 5.7:

http://www.php.cn/xiazai/gongju/116

Follow the steps:

Copy the compressed package to /usr/local Use the ftp tool
cd /usr/local/
tar zxvf mysql-5.7 .17-linux-glibc2.5-x86_64.tar.gz Unzip
mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql Rename

Enter the installation folder support-files

cd /usr/local/mysql/support-files/
cp my-default.cnf /etc/my.cnf Copy the mysql configuration file to etc , prompt that the file already exists, enter yes

vi /etc/my.cnf Edit the configuration file
Add
default-storage-engine=INNODB Add below [mysqld] Can
character_set_server=utf8

Copy mysql.server to the /etc/init.d/ directory [The purpose is to achieve the automatic execution effect at boot]
cp /usr/local /mysql/support-files/mysql.server /etc/init.d/mysql

vi /etc/init.d/mysql
Modify the following content
basedir= /usr/local/mysql
datadir=/usr/local/mysql/data

Create a new Linux user
groupadd mysql #Create a mysql group
useradd -r -g mysql mysql #Create a mysql user and put the user in the mysql group
passwd mysql (mysql123) #Set a password for the mysql user
chown -R mysql:mysql /usr /local/mysql/ Change the owner of the directory /usr/local/mysql

Initialize the mysql database
Enter mysql bin
cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
Record the generated password (refer to the selected part in the figure below)

Encrypt the database
./mysql_ssl_rsa_setup --datadir=/usr/local/mysql /data
Start mysql (in order to prevent the process from being stuck, you can add & after the command to start mysql to indicate that the process is running in the background)
./mysqld_safe --user=mysql &

Check the process
ps -ef|grep mysql

Make sure it is in the bin directory
cd /usr/local/mysql/bin/
./mysql -uroot -p (enter temporary password)

Change password
set password=password('/* new password*/');

Authorize remote Access
grant all privileges on *.* to root@'%' identified by '/* new password*/';

Note: The red part represents the root account of mysql

use mysql; //Enter the database
select host,user from user; [One more itemRemote loginuser Record]

Execute refresh

mysql>flush privileges;

Change port 3306 in the Linux command line Open exception
/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
firewall-cmd --zone=public --add-port=3306/tcp --permanent It will not fail after restarting
firewall-cmd --reload

Set auto-start at boot
Addservicemysql
chkconfig --add mysql

Set the mysql service to automatic
chkconfig mysql on

Restart the viewing process
ps -ef|grep mysql

Add mysql to the environment variable
Modify the /etc/profile file to make it permanent. And it will take effect for all system users. Add the following two lines of code at the end of the file
PATH=$PATH:/usr/local/mysql/bin
export PATH
Execute the command source /etc/profile or execution point Command ./profile to make the modification effective. After execution, you can use the echo $PATH command to check whether the addition is successful.

Related articles:

Tutorial on installing mysql5.7 under windows (picture and text)

Tutorial on installing MySQL-5.7 under Linux (picture) arts)

The above is the detailed content of Steps to install MySQL5.7 under CentOS7 (pictures and text). For more information, please follow other related articles on the PHP Chinese website!