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

Yum-y groupinstall "Development tools"

Yum-y install ncurses-devel pcre-devel openssl-devel bison

Cd / opt

Wget https://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

Tar-zxf boost_1_59_0.tar.gz

Note: boost is a free third-party C++ library.

Wget https://cmake.org/files/v3.7/cmake-3.7.1.tar.gz

Tar-zxf cmake-3.7.1.tar.gz

Cd cmake-3.7.1

. / bootstrap

Make

Make install

Cmake-version

Groupadd-r mysql

Useradd-r-M-g mysql-s / sbin/nologin mysql

Mkdir-pv / data/mysql

Chown-R mysql:mysql / data/mysql

Ll-d / data/mysql

Tar-zxf mysql-5.7.10.tar.gz

Cd mysql-5.7.10/

Cmake. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/data/mysql-DSYSCONFDIR=/etc-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_ARCHIVE_STORAGE_ENGINE=1-DENABLED_LOCAL_INFILE=1-DENABLE_DOWNLOADS=1-DWITH_BLACKHOLE_STORAGE_ENGINE=1-DDOWNLOAD_BOOST=1-DWITH_BOOST=/opt/boost_1_59_0-DWITH_FEDERATED_STORAGE_ENGINE=1-DWITH_READLINE=1-DWITH_SSL=system-DWITH_ZLIB=system-DWITH_LIBWRAP=0-DMYSQL_UNIX_ADDR=/tmp/mysql.sock-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci

Make

Make install

Echo "export PATH=$PATH:/usr/local/mysql/bin" > > / etc/profile

Source / etc/profile

Mysqld-- initialize-- user=mysql-- datadir=/data/mysql-- basedir=/usr/local/mysql # database initialization, pay attention to the initial password of root

Cd / usr/local/mysql/support-files/

Cp mysql.server / etc/init.d/mysqld

Chkconfig-add mysqld

Chkconfig mysqld on

Service mysqld start

Service mysqld stop

Mysqld_safe-- skip-grant-tables & # restart the database by ignoring the authorization table and set the root password

Mysql > update mysql.user set authentication_string=password ('abc-123.') Where user='root' and Host='localhost'; # password must be more than 8 digits

Mysql > flush privileges

Service mysqld restart

About reporting errors:

1) You must reset your password using ALTER USER statement before executing this statement. Problems caused by too simple password settings.

Resolve:

Mysql > SET PASSWORD = PASSWORD ('abc-123.')

Mysql > ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER

Mysql > flush privileges

2) commonly used compilation parameters of MySQL5.7.10:

Cmake. \

-DCMAKE_INSTALL_PREFIX=/opt/mysql\ [root directory of MySQL installation]

-DMYSQL_DATADIR=/data/mysql/data\ [directory where MySQL database files are stored]

-DSYSCONFDIR=/etc\ [directory where the MySQL configuration file is located]

-DMYSQL_USER=mysql\ [MySQL user name]

-DWITH_MYISAM_STORAGE_ENGINE=1\ [MySQL's database engine]

-DWITH_INNOBASE_STORAGE_ENGINE=1\ [MySQL's database engine]

-DWITH_ARCHIVE_STORAGE_ENGINE=1\ [MySQL's database engine]

-DWITH_MEMORY_STORAGE_ENGINE=1\ [MySQL's database engine]

-DWITH_READLINE=1\ [readline library of MySQL]

-DMYSQL_UNIX_ADDR=/data/mysql/config/mysql.sock\ [MySQL's address directory]

-DMYSQL_TCP_PORT=3306\ [listening port of MySQL]

-DENABLED_LOCAL_INFILE=1\ [enable loading of local data]

-DENABLE_DOWNLOADS=1\ [allow you to download related files independently at compile time]

-DWITH_PARTITION_STORAGE_ENGINE=1\

-DEXTRA_CHARSETS=all\ [make MySQL support all extended characters]

-DDEFAULT_CHARSET=utf8\ [set the default character set to utf8]

-DDEFAULT_COLLATION=utf8_general_ci\ [set default character proofreading]

-DWITH_DEBUG=0\ [disable debug mode]

-DMYSQL_MAINTAINER_MODE=0\

-DWITH_SSL:STRING=bundled\ [support ssl protocol when communicating]

-DWITH_ZLIB:STRING=bundled\ [allow zlib library]

-DDOWNLOAD_BOOST=1\

-DWITH_BOOST=/opt/boost

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.