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

Pre-compilation installation preparation

OS:CentOS 6.9

Mysql:5.7.18

Download Mysql Feed

Official website source: mysql-boost mysql

Sohu Source: mysql-boost mysql

Uninstall the original version before installing Mysql

Query the Mysql directory file to uninstall the original MySQL

# rpm-qa | grep mysql

# find /-name mysql

# yum remove-y mysql-libs-5.1.73-3.el6_5.x86_64

Install the compilation environment

# yum-y install make wget gcc-c++ cmake bison-devel ncurses-devel

Preconfiguration setup

# groupadd mysql

# useradd-r-g mysql-s / bin/false mysql

Beginning of source-build specific instructions

# mkdir ~ / mysql & & cd ~ / mysql

# mkdir-p / data/mysql_data

# wget-c https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-boost-5.7.18.tar.gz

# tar-zxvf mysql-boost-5.7.18.tar.gz & & cd mysql-5.7.18/

# cmake. \

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\

-DMYSQL_DATADIR=/data/mysql_data\

-DSYSCONFDIR=/etc\

-DDOWNLOAD_BOOST=1\

-DWITH_BOOST=/usr/local/boost\

-DWITH_ARCHIVE_STORAGE_ENGINE=1\

-DWITH_BLACKHOLE_STORAGE_ENGINE=1\

-DWITH_MYISAM_STORAGE_ENGINE=1\

-DWITH_INNOBASE_STORAGE_ENGINE=1\

-DWITH_PARTITION_STORAGE_ENGINE=1\

-DWITH_READLINE=1\

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock\

-DMYSQL_TCP_PORT=3306\

-DENABLED_LOCAL_INFILE=1\

-DDEFAULT_CHARSET=utf8\

-DDEFAULT_COLLATION=utf8_general_ci

# make

# make install

End of source-build specific instructions

Postinstallation setup

# cd / usr/local/mysql

# chown-R mysql.

# chgrp-R mysql.

Before MySQL 5.7.6

# bin/mysql_install_db-user=mysql

MySQL 5.7.6 and up

# bin/mysqld-initialize-user=mysql

# bin/mysql_ssl_rsa_setup

# chown-R root.

# chown-R mysql / data

# bin/mysqld_safe-- user=mysql &

Configure boot startup item

# cp / usr/local/mysql/support-files/mysql.server / etc/init.d/mysql.server

# chmod + x / etc/init.d/mysql.server

# chkconfig-add mysql.server

# chkconfig mysql.server on

The configuration / etc/my.cnf is for reference only and may not be configured with the default.

Start mysql

# service mysql.server start

Add boot startup item

# chkconfig-- live 35 mysql.server on

Check if the port is occupied

# netstat-tulnp | grep 3306

View database version

# ln-s / usr/local/mysql/bin/mysql / usr/bin/

# mysql-version

Log into the database

# mysql-u root-p

View the database

> show databases

Reset the password, where the password is set to? root?

> set password = password ('? root?')

Exit the database

> 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.