What are the steps for installing the mysql5.7forcentos7.6 source code
This article introduces the steps of mysql5.7forcentos7.6 source code installation, the content is very detailed, interested friends can refer to, hope to be helpful to you.
The detailed deployment steps are as follows:
1. Preparation before installation
1) disable the firewall and modify SELinux
Vim / etc/selinux/config
SELINUX=disabled
2) turn off the firewall
Systemctl status firewalld.service
Systemctl stop firewalld.service
Systemctl disable firewalld.service
3) tools required to install MySQL
Yum install\
Vim\
Git\
Gcc\
Gcc-c++\
Wget\
Make\
Cmake\
Automake\
Autoconf\
Libaio\
Libtool\
Net-tools\
Bison\
Bison-devel\
Libaio-devel\
Ncurses-devel\
Perl-Data-Dumper\
-y
4) check if MySQL is installed on the operating system
Rpm-qa | grep mysql
Yum remove mysql-libs
5) download the source code installation package
Cd / apps/rpm
Wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.27.tar.gz
Wget http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
two。 Add users and groups:
Groupadd apps
Useradd-d / home/apps-g apps-m apps
Passwd apps123
3. Create directory and authorization
Mkdir-p / apps/conf/mysql # config directory
Mkdir-p / apps/dbdat/mysql57_3306 # dbdata directory
Mkdir-p / apps/binlog/mysql57_3306 # binlog directory
Mkdir-p / apps/logs/mysql # log directory
Mkdir-p / apps/svr/mysql57 # binary directory
Mkdir-p / apps/tmp
Mkdir-p / apps/run
Mkdir-p / apps/sh/tool
Mkdir-p / apps/rpm
Chown-R apps:apps / apps
Chmod-R 755 / apps
4. With MySQL environment variables
Vi / etc/profile
Export.UTF-8
Export PATH=$PATH:/usr/sbin
Export PATH=$PATH:/apps/svr/mysql57/bin
Export PATH=$PATH:/apps/sh/tool/
Export MYSQL_HISTFILE=/dev/null
> ~ / .mysql_history
/ bin/bash / apps/sh/log_name.sh
5. Decompression
Cd / apps/rpm/
Tar-xzvf boost_1_59_0.tar.gz
Cd / apps/rpm
Tar-xzvf mysql-5.7.27.tar.gz
6. Go to the extracted mysql-5.7.27 directory, compile the source code and generate makefile.
Compile and install
Cmake\
-DCMAKE_INSTALL_PREFIX=/apps/svr/mysql57\
-DMYSQL_DATADIR=/apps/dbdat/mysql57_3306\
-DSYSCONFDIR=/app/conf/mysql\
-DWITH_BOOST=/apps/rpm/boost_1_59_0\
-DDEFAULT_CHARSET=utf8mb4\
-DDEFAULT_COLLATION=utf8mb4_unicode_ci\
-DEXTRA_CHARSETS=all\
-DENABLED_LOCAL_INFILE=1\
-DMYSQL_UNIX_ADDR=/tmp/mysql3306.sock\
-DMYSQL_TCP_PORT=3306
#-DWITH_SYSTEMD=1\ remove this, plus mysqld_safe will not be installed
7. Compile
Make
8. Installation
Make install
9. Configure mysql parameters
Vim / apps/conf/mysql/mysql57_3306.cnf
Chown-R apps:apps / apps
Chmod-R 755 / apps
10. Initialize the database: (--there can be no data files in the datadir target directory)
/ apps/svr/mysql57/bin/mysqld-defaults-file=/apps/conf/mysql/mysql57_3306.cnf-initialize-user=apps
/ apps/svr/mysql57/bin/mysqld-- defaults-file=/apps/conf/mysql/mysql57_3306.cnf-- initialize-insecure-- user=apps # root password is empty
/ * *
1) initialize with the default configuration file
/ apps/svr/mysql5/bin/mysqld-initialize-user=apps-basedir=/apps/svr/mysql57-datadir=/apps/dbdat/mysql57_data3306 # MySQL 5.7.6 and up mysql_install_db-user=mysql # Before MySQL 5.7.6
2) initialize with a custom configuration file
/ apps/svr/mysql57/bin/mysqld-- defaults-file=/apps/conf/mysql/mysql57_3306.cnf-- initialize-- user=mysql # if initialized through a configuration file,-- defaults-file must be placed in the first location (before-- initialize), but the binlog directory cannot put a data directory
3) initialize but do not set the root password, the root password is empty
/ apps/svr/mysql57/bin/mysqld-defaults-file=/apps/conf/mysql/mysql57_3306.cnf-initialize-insecure-user=mysql
* * /
11. After executing this sentence, mysql will assign an initial password, which needs to be backed up.
Continue to execute:
/ apps/svr/mysql57/bin/mysql_ssl_rsa_setup
13. Start MySQL:
Nohup / apps/svr/mysql57/bin/mysqld_safe-defaults-file=/apps/conf/mysql/mysql57_3306.cnf-user=apps &
/ * *
Bin/mysqld_safe-- user=mysql &
Or
/ usr/local/mysql/support-files/mysql.server start
Or
Cp / usr/local/mysql/support-files/mysql.server / etc/init.d/mysqld
Chmod + x / etc/init.d/mysqld
Chkconfig-add mysqld
You can use service mysqld start | restart | status | status management
You can also use systemctl start | restart | status | status mysqld.service
* * /
14. Log in to mysql
Mysql
15. Modify the password
ALTER USER 'root'@'localhost' IDENTIFIED BY' root123'
16. Log in again
Mysql-uroot-p
On the mysql5.7forcentos7.6 source code installation steps are shared here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.
