Shulou(Shulou.com)06/01 Report--

Linux version: CentOS 7.4

MySQL version: 5.7.28

In Linux platform RPM package, binary package, source package 3 installation mode, this article is mainly based on source package as an example to introduce how to install MySQL under Linux platform.

Download address: cdn.mysql.com//Downloads/MySQL-5.7/mysql-boost-5.7.28.tar.gz

Domestic mirror: mirrors.163.com/mysql/Downloads/MySQL-5.7/mysql-boost-5.7.28.tar.gz

Specific installation steps are as follows:

(1) First uninstall mariadb, otherwise it will conflict with the library required to install mysql:

[root@localhost ~]# rpm -qa | grep mariadbmariadb-libs-5.5.56-2.el7.x86_64[root@localhost ~]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

(2) Create mysql users and user groups:

[root@localhost ~]# groupadd mysql[root@localhost ~]# useradd -r -g mysql -s /bin/false mysql

(3) Create MySQL installation directory and data directory:

[root@localhost ~]# mkdir /opt/mysql[root@localhost ~]# mkdir -p /data/mysql[root@localhost ~]# chown mysql:mysql /opt/mysql[root@localhost ~]# chown mysql:mysql /data/mysql

(4) Installation dependent:

[root@localhost ~]#yum install -y cmake make gcc gcc-c++ ncurses-devel openssl-devel

(4) Compilation and installation:

[root@localhost ~]# tar -xvf mysql-boost-5.7.28.tar.gz[root@localhost mysql-5.7.28]# cmake \-DCMAKE_INSTALL_PREFIX=/opt/mysql \-DMYSQL_DATADIR=/data/mysql \-DMYSQL_USER=mysql \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \-DWITH_READLINE=1 -DDOWNLOAD_BOOST=1 \-DWITH_BOOST=/root/mysql-5.7.28/boost/boost_1_59_0/ \-DMYSQL_DATADIR=/data/mysql \-DWITH_SSL=system[root@localhost ~]#make && make install

5) Initialize MySQL:

[root@localhost ~]# cd /opt/mysql/[root@localhost mysql]# ./ bin/mysqld --initialize --user=mysql --basedir=/opt/mysql --datadir=/data/mysql2019-12-01T02:33:14.303069Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2019-12-01T02:33:16.484507Z 0 [Warning] InnoDB: New log files created, LSN=457902019-12-01T02:33:16.735058Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2019-12-01T02:33:16.816435Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: ee34514d-13e2-11ea-b534-000c29647ed4.2019-12-01T02:33:16.818202Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2019-12-01T02:33:17.277339Z 0 [Warning] CA certificate ca.pem is self signed.2019-12-01T02:33:17.415078Z 1 [Note] A temporary password is generated for root@localhost: og5Q0qgu6;Ui

The temporary password generated is og5Q0qgu6;Ui

(6) Modify MySQL configuration file/etc/my.cnf, save exit:

[root@localhost mysql]# vim /etc/my.cnf[mysqld]datadir=/data/mysqlsocket=/data/mysql/mysql.sockuser=mysqlport=3306default-storage-engine=InnoDB[mysqld_safe]log-error=/data/mysql/mysql-error.logpid-file=/data/mysql/mysqld.pid[client]socket=/data/mysql/mysql.sock

7) Start MySQL:

[root@localhost mysql]# bin/mysqld_safe --user=mysql &

(8) Configure environmental variables:

[root@localhost ~]# vim /etc/profile#Add the following line export PATH=/opt/mysql/bin:$PATH[root@localhost ~]# source /etc/profile

(9) Log in and modify MySQL administrator password:

[root@localhost mysql]# mysql -uroot -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.7.28Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> set password = PASSWORD('root123456');Query OK, 0 rows affected, 1 warning (0.00 sec)

(10) Configure the original process login:

mysql> grant all privileges on *.* to root@'%' identified by 'root123456';Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.