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

# install compilation tools and plug-ins yum-y install\ gcc\ gcc-c++\ make\ ncurses\ ncurses-devel\ bison\ cmake# user useradd-s / sbin/nologin mysqlyum install lrz*-y

# decompress mysql installation package tar xf mysql-boost-5.7.20.tar.gz-C / opt/cd / opt/mysql-5.7.20/cmake\-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock\-DSYSCONFDIR=/etc\-DSYSTEMD_PID_DIR=/usr/local/mysql\-DDEFAULT_CHARSET=utf8\-DDEFAULT_COLLATION=utf8_general_ci\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1\-DWITH_PERFSCHEMA_STORAGE_ENGINE=1\-DMYSQL_DATADIR=/usr/local/mysql/data\-DWITH_BOOST=boost\-DWITH_SYSTEMD=1# compile and install make & & make install# configure permissions for the database directory chown-R mysql.mysql / usr/local/mysql/vi / etc/my.cnf delete all the contents and add the following to it [client] port = 3306 default-character-set=utf8socket = / usr/local / mysql/ MySQL. Socks [MySQL] port = 3306default-character-set=utf8socket = / usr/local/mysql/ mysql.socks [mysqld] user = mysqlbasedir = / usr/local/mysqldatadir = / usr/local/mysql/dataport = 3306character_set_server=utf8pid-file = / usr/local/mysql/mysqld.pidsocket = / usr/local/mysql/mysql.sockserver-id = 1sql_mode=NO_ENGINE_SUBSTITUTION STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,PIPES_AS_CONCAT ANSI_QUOTES: wq / / Save exit chown mysql:mysql / etc/my.cnf / / profile master and group # set the environment variable echo 'PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH' > > / etc/profile / / add these two paths to the environment variable And put it in the profile file to make it run on its own, otherwise it will not take effect echo 'export PATH' > > / etc/profile / / as the global variable Make it more widely used source / etc/profile / / effective immediately # initialize the database cdcd / usr/local/mysql/bin/mysqld\-initialize-insecure\-user=mysql\-- basedir=/usr/local/mysql\-- datadir=/usr/local/mysql/datacp usr/lib/systemd/system/mysqld.service / usr/lib/systemd/system/systemctl daemon-reload systemctl start mysqldnetstat-anpt | grep 3306 / / View the running status of the service

Systemctl enable mysqld / / is set to boot # access the database operation mysqladmin-uroot-p password "abc123" / / set the password to the root account mysql-uroot-pabc123 / / add "- p" to the login database with a password. If you do not need to add "- p" database installation and configuration successfully, enter "quit" if you exit.

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.