mysql5.7编译安装

shell>yum -y install make gcc-c++ bisonncurses-devel

#Set timezone(设置服务器的时区：亚洲上海)

shell>rm -rf /etc/localtime

shell>ln -s /usr/share/zoneinfo/Asia/Shanghai /etc/localtime

#Remove MYSQL if exists mysql (删除服务器上已存在MYSQL,切记数据库备份)     

shell>rpm -qa|grep mysql

shell>rpm -e mysql

shell>yum -y remove mysql-server mysql mysql-libs

Shell>tar  -zxvf cmake-2.8.8.tar.gz

shell>cd cmake-2.8.8

shell>./bootstrap

shell>make

shell>make install

shell>unzipboost_1_59_0.zip

shell>mvboost_1_59_0  /usr/local/boost

shell>cd  /usr/local/boost

shell> ./bootstrap.sh

shell> ./b2

shell>tar zxvf mysql-5.7.9.tar.gz

shell>cd mysql-5.7.9

shell>cmake  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql

-DMYSQL_DATADIR=/usr/local/mysql/data

-DSYSCONFDIR=/etc

-DWITH_MYISAM_STORAGE_ENGINE=1 

-DWITH_INNOBASE_STORAGE_ENGINE=1

-DWITH_ARCHIVE_STORAGE_ENGINE=1  

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 

-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 

-DWITH_PARTITION_STORAGE_ENGINE=1 

-DWITH_EXAMPLE_STORAGE_ENGINE=0   

-DWITH_FEDERATED_STORAGE_ENGINE=0 

-DWITH_BOOST=/usr/local/boost    

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

-DMYSQL_TCP_PORT=3306

-DENABLED_LOCAL_INFILE=1

-DENABLED_PROFILING=1   

-DWITH_EXTRA_CHARSETS=gbk,gb2312,utf8,ascii,utf8mb4

-DDEFAULT_CHARSET=utf8

-DDEFAULT_COLLATION=utf8_general_ci

shell>make -j`grep processor /proc/cpuinfo | wc -l` && make install

shell>groupadd mysql

shell>useradd -g mysql  -s /sbin/nologin mysql

shell>chown -R mysql.mysql /usr/local/mysql

shell>mkdir /var/lib/mysql

shell>chown -R mysql.mysql /var/lib/mysql        #socket文件存放位置

shell> bin/mysql_install_db --user=mysql # Before MySQL 5.7.6

shell> bin/mysqld --initialize --user=mysql--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data # MySQL 5.7.6 and up

2015-10-25T13:55:17.985338Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2015-10-25T13:55:20.481855Z 0 [Warning] InnoDB: New log files created, LSN=45790

2015-10-25T13:55:20.757621Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2015-10-25T13:55:20.829606Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 0803aa28-7b20-11e5-9937-000c29502ea3.

2015-10-25T13:55:20.831561Z 0 [Warning] Gtid table is not ready to be used. Table "mysql.gtid_executed" cannot be opened.

2015-10-25T13:55:20.844288Z 1 [Note] A temporary password is generated forroot@localhost: 8QVlQ(s82//L

shell>vi /etc/my.cnf

[mysqld]

# These are commonly set, remove the # and set as required.

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

port=3306

#server_id = .....

socket=/var/lib/mysql/mysql.sock

shell>cp support-files/mysql.server /etc/init.d/mysqld

shell>chkconfig mysqld on

shell>service mysqld start 

#vi /etc/profile

PATH=/usr/local/mysql/bin:$PATH

export PATH

#source /etc/profile

shell>mysql -uroot  -p’eZ4hXJ,r2Tde’

mysql> show databases;

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

修改默认密码

mysql>alter user "root"@"localhost" identified by "123456";