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

This article is mainly about the specific steps of MySQL-8.0 installation through the source package, if you are interested, let's take a look at this article. I believe that after reading the specific steps of MySQL-8.0 installation through the source package, it is of some reference value to everyone.

1) install Mysql database

[root@localhost ~] # rpm-Q mysql mysql-server not installed package mysql not installed package mysql-server [root@localhost ~] # yum-y install ncurses-devel [root@localhost ~] # rpm-Q ncurses-develncurses-devel-5.9-14.20130511.el7_4.x86_64

Install the configuration tool cmake

[root@localhost] # tar xf cmake-3.13.1.tar.gz-C / usr/src/ [root@localhost ~] # cd / usr/src/cmake-3.13.1/ [root@localhost cmake-3.13.1] #. / configure & & gmake & & gmake install

Create a running user

[root@localhost] # useradd-M-s / sbin/nologin mysql

Unpack, configure, compile, install

[root@localhost] # tar xf mysql-8.0.11.tar.gz-C / usr/src/ [root@localhost ~] # cd / usr/src/mysql-8.0.11/ [root@localhost mysql-5.7.24] # cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS=all-DSYSCONFDIR=/etc & & make & & make install-DCMAKE_INSTALL_PREFIX=/usr/local/mysql / / According to the library program installation directory-DDEFAULT_CHARSET=utf8 / / specify character set encoding-DDEFAULT_COLLATION=utf8_general_ci / / default character set proofreading rules Utf8_general_ci General rules for utf-8 character set-DWITH_EXTRA_CHARSETS=all / / specify additional supported character set encodings-DSYSCONFDIR=/etc / / specify configuration file storage directory

Error handling:

- -CMake Error at cmake/boost.cmake:81 (MESSAGE): You can download it with-DDOWNLOAD_BOOST=1-DWITH_BOOST= This CMake script will look for boost in. If it is not there, it will download and unpack it (in that directory) for you. If you are inside a firewall, you may need to use an http proxy: export http_proxy= http://example.com:80Call Stack (most recent call first): cmake/boost.cmake:238 (COULD_NOT_FIND_BOOST) CMakeLists.txt:507 (INCLUDE)-Configuring incomplete Errors occurred see also "/ usr/src/mysql-5.7.24/CMakeFiles/CMakeOutput.log" .See also "/ usr/src/mysql-5.7.24/CMakeFiles/CMakeError.log".-

The solution is:

1. Create a folder called boost under / usr/local

[root@localhost ~] # mkdir / usr/local/boost

two。 Enter the directory and download boost

[root@localhost ~] # cd / usr/local/boost [root@localhost boost] # wget https://sourceforge.net/projects/boost/files/boost/1.66.0/boost_1_66_0.tar.gz

3. Decompress boost

[root@localhost boost] # tar xf boost_1_66_0.tar.gz

4. Continue cmake and add the red part.

[root@localhost mysql-5.7.24] # cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS=all-DSYSCONFDIR=/etc-DWITH_BOOST=/usr/local/boost & & make & make install

2) adjustments after installation

Set permissions on the database directory

[root@localhost ~] # cd / usr/local/mysql/ [root@localhost mysql] # chown-R mysql:mysql. /

Create a configuration file (the CentOS7 system supports MariaDB database by default, and the default / etc/my.cnf configuration file is the configuration file of MariaDB)

[root@localhost mysql] # vim / etc/ my.cnf[mysqld] datadir=/usr/local/mysql/datasocket=/tmp/ mysql.sock[mysqld _ safe] log-error=/usr/local/mysql/data/mysql.logpid-file=/usr/local/mysql/data/mysql.pid

3) initialize the database

[root@localhost mysql] #. / bin/mysqld-- user=mysql-- basedir=/usr/local/mysql-- datadir=/usr/local/mysql/data-- initialize2018-12-08T01:51:39.798903Z 1 [Note] A temporary password is generated for root@localhost: dskL0) 8S3FGe--basedir=/usr/local/mysql/ specified installation directory (product directory)-- datadir=/usr/local/mysql/data / / specified data directory-- user=mysql / / specify user identity

4) set environment variables

[root@localhost mysql-5.7.24] # echo "PATH=$PATH:/usr/local/mysql/bin" > / etc/profile [root@localhost mysql-5.7.24] #. / etc/profile = source / etc/profile

5) add system services

Add MySQL to serve the system for management through the systemctl command

[root@localhost mysql-5.7.24] # cp support-files/mysql.server / usr/local/mysql/bin/mysqld.sh [root@localhost mysql-5.7.24] # chmod + x / usr/local/mysql/bin/mysqld.sh [root@localhost ~] # vim / usr/lib/systemd/system/ mysqld.service [Unit] Description=MySQL ServerAfter= network.target [Service] User=mysql # specify the user account that the program is running Group=mysql # specify the group account Type=forkingPIDFile=/usr/ that the program is running Local/mysql/data/localhost.pid # specify the location of the PID file The default is "hostname .pid" ExecStart=/usr/local/mysql/bin/mysqld.sh startExecStop=/usr/local/mysql/bin/mysqld.sh stop [install] WantedBy=mutil-user.target [root@localhost ~] # systemctl start mysqld [root@localhost ~] # systemctl enable mysqldCreated symlink from / etc/systemd/system/mutil-user.target.wants/mysqld.service to / usr/lib/systemd/system/mysqld.service. [root@localhost ~] # systemctl status mysqld ● mysqld.service-MySQL Server Loaded: loaded (/ usr/lib/systemd/system/mysqld.service Enabled; vendor preset: disabled) Active: active (running) since six 2018-12-08 09:54:04 CST; 42s ago Main PID: 2520 (mysqld) CGroup: / system.slice/mysqld.service ├─ 2364 / bin/sh / usr/local/mysql/bin/mysqld_safe-- datadir=/usr/local/mysql/data-- pid... └─ 2520 / usr/local/mysql/bin/mysqld-- basedir=/usr/local/mysql-- datadir=/usr/local/my...12 08 09:53:57 localhost systemd [1]: Starting MySQL Server...12 08 09:54:04 localhost systemd [1]: mysqld.service: Supervising process 2520 which is not...ts.12 08 09:54:04 localhost systemd [1]: Started MySQL Server.12 08 09:54:16 localhost systemd [1]: mysqld.service: Supervising Process 2520 which is not...ts.Hint: Some lines were ellipsized Use-l to show in full. [root@localhost ~] # netstat-lnpt | grep mysqldtcp6 0 0:: 3306: * LISTEN 2520/mysqld

MySQL provides services through the TCP3306 port by default, which can be modified by editing the "port=3306" line in the / etc/my.cnf file.

[root@localhost mysql] # mysqladmin-uroot-p'dskL0) 8S3FGe' password 123456 [root@localhost mysql] # mysql-uroot-p123456mysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 9Server version: 8.0.11 Source distributionCopyright (c) 2000, 2018, 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 > exitBye

[root@localhost mysql] #

The above details about the specific steps of MySQL-8.0 installation through the source package, are they helpful to you? If you want to know more about it, you can continue to follow our industry information section.

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.