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

Https://pan.baidu.com/s/1X0QlWbCh3tsQbHCc505XxA / / Software Baidu Cloud connection

Yum install lrz*-y / / install upload software

Yum-y install\ ncurses\ ncurses-devel\ bison\ cmakeuseradd-s / sbin/nologin mysql / / create a user tar xf mysql-boost-5.7.20.tar.gz / / decompression package that cannot log in to the system

Cd mysql-5.7.20/

Yum-y install gcc gcc-c++ cmake ncurses-devel autoconf perl perl-devel

Cmake\-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\ / / the root directory of the mysql installation-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock\ / sets the mysql.sock path, which must be an absolute path The default is / tmp/mysql.sock-DSYSCONFDIR=/etc\ / / the directory where the mysql configuration file is located-DSYSTEMD_PID_DIR=/usr/local/mysql\ / / pid file path-DDEFAULT_CHARSET=utf8\ / / set the default character set of mysql to utf-8-DDEFAULT_COLLATION=utf8_general_ci\ / / set the default character set alignment rule-DWITH_INNOBASE_STORAGE_ENGINE=1\ / / the following is the optimization parameter Storage engine option, statically compile a storage engine to the server, 1: enable, add INNOBASE engine support to report errors without adding tables-DWITH_ARCHIVE_STORAGE_ENGINE=1\ / / add ARCHIVE engine support, add DWITH_BLACKHOLE_STORAGE_ENGINE=1 engine support when no tables are added-BLACKHOLE engine support, error reports when tables are not added-DWITH_PERFSCHEMA_STORAGE_ENGINE=1\ / / add PERFSCHEMA engine support Report an error when not adding a table-DMYSQL_DATADIR=/usr/local/mysql/data\ / / mysql database file storage directory-DWITH_BOOST=boost\ / point to the directory where the boost library is located-DWITH_SYSTEMD=1 / / you can use systemd to control the mysql service make & & make install / / compile and install chown-R mysql.mysql / usr/local/mysql/vi / etc/my.cnf / / MySQL default main configuration file # add [client] port = 3306 default-character-set=utf8 socket = / usr/local/mysql/mysql.sock / / set sock file location [mysql] port = 3306 default-character-set=utf8 / / set mysql client default character set socket = / usr/local/mysql/mysql.sock [mysqld] user = mysql basedir = / Usr/local/mysql/ / setup mysql installation directory datadir = / usr/local/mysql/data / / set the data storage directory of the mysql database port = 3306 / / set port 3306 character_set_server=utf8 / / default storage engine pid-file = / usr/local/mysql/mysqld.pid socket = / usr/ to be used when creating new tables Local/mysql/mysql.sock server-id = 1 sql_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 and exit chown mysql:mysql / etc/my.cnfecho 'PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH' > > / etc/profile / / the Linux system recognizes echo' export PATH' > / etc/profilesource / etc/profilecd / usr/local/mysql/ initialize bin/mysqld\ / / initialization data in the installation directory Library-- initialize-insecure\-- user=mysql\ / / user-- basedir=/usr/local/mysql\ / / Base directory-- datadir=/usr/local/mysql/data / / working directory cp usr/lib/systemd/system/mysqld.service / usr/lib/systemd/system/ add to system Manager systemctl daemon-reload load systemctl start mysqld / / restart mysqld server Netstat-anpt | grep 3306 / / check which services are running systemctl enable mysqld on port 3306

Mysqladmin-u root-p password "abc123" / / whether the experiment of setting a password for a root account is successful

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.