源码安装mysql5.7版本的神奇之旅，linux centos7系统搭建。

用www用户在centos7系统搭建一个mysql5.7版本的数据库。

安装mysql所有依赖

$ sudo yum -y install ncurses-devel cmake bison gcc gcc-c++ libaio ncurses autoconf

$ echo $HOME
/data

$ mkdir ~/package && cd ~/package

安装boost软件

$ mkdir /data/soft/boost

$ wget https://sourceforge.net/projects/boost/files/boost/1.69.0/boost_1_69_0.tar.gz

$ tar -xf boost_1_69_0.tar.gz -C /data/soft/boost/

 

下载mysql源码包，并开始编译。

$ wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.25.tar.gz

$ tar -xf mysql-5.7.25.tar.gz

$ cd mysql-5.7.25/

$ cmake -DMYSQL_USER=www  -DCMAKE_INSTALL_PREFIX=/data/soft/mysql -DMYSQL_DATADIR=/data/www/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/data/www/mysql/mysqld.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DDOWNLOAD_BOOST=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=/data/soft/boost

注意红色编译参数，手动指定boost文件。

$ make -j 4 && make install

$ cd /data/soft/mysql/

 

数据库初始化。

mysql从5.7开始已经没有scripts/mysql_install_db脚本了，可以直接用mysqld命令进行数据库初始化。

$ ls
bin      COPYING-test  include  man         README       share
COPYING  docs          lib      mysql-test  README-test  support-files

$ ./bin/mysqld --initialize --user=www --basedir=/data/soft/mysql --datadir=/data/www/mysql/data

2019-04-07T13:15:03.258543Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-04-07T13:15:04.240856Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-04-07T13:15:04.343202Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-04-07T13:15:04.406013Z 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: 2833af56-5937-11e9-900a-000c29b4be1f.
2019-04-07T13:15:04.407689Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-04-07T13:15:04.409320Z 1 [Note] A temporary password is generated for root@localhost: %rIaTe.9;02o

此时必须记住一个临时密码：%rIaTe.9;02o

$ ls /data/www/mysql/data/
auto.cnf        ibdata1      ib_logfile1  performance_schema
ib_buffer_pool  ib_logfile0  mysql        sys

$ ./bin/mysql_ssl_rsa_setup --datadir=/data/www/mysql/data

Generating a 2048 bit RSA private key
..+++
....+++
writing new private key to 'ca-key.pem'
-----
Generating a 2048 bit RSA private key
................................................................................................+++
..................+++
writing new private key to 'server-key.pem'
-----
Generating a 2048 bit RSA private key
................+++
.....+++
writing new private key to 'client-key.pem'
-----

 

生成mysql配置文件，配置mysql配置，启动数据库。

$ sudo chown www:www /etc/my.cnf

$ vim /etc/my.cnf

[mysqld]
user=www
datadir=/data/www/mysql/data
socket=/data/www/mysql/mysqld.sock
log-error=/logs/mysql/mysql-error.log
pid-file=/data/www/mysql/mysql.pid
[mysqld_safe]
log-error=/logs/mysql/mysql-error.log
pid-file=/data/www/mysql/mysql.pid

$ sudo cp support-files/mysql.server /etc/init.d/mysqld

$ sudo chown www:www /etc/init.d/mysqld

$ vim /etc/init.d/mysqld

basedir=/data/soft/mysql
datadir=/data/www/mysql/data

$ mkdir /logs/mysql

$ /etc/init.d/mysqld start

$ ps -ef|grep mysql
www         437      1  0 12:16 pts/0    00:00:00 /bin/sh /data/soft/mysql/bin/mysqld_safe --datadir=/data/www/mysql/data --pid-file=/data/www/mysql/mysql.pid
www         629    437 21 12:16 pts/0    00:00:23 /data/soft/mysql/bin/mysqld --basedir=/data/soft/mysql --datadir=/data/www/mysql/data --plugin-dir=/data/soft/mysql/lib/plugin --log-error=/logs/mysql/mysql-error.log --pid-file=/data/www/mysql/mysql.pid --socket=/data/www/mysql/mysqld.sock

 

利用临时密码进入数据库更改密码

用临时密码登陆到数据库后必须马上修改密码，不然会报错。

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

执行SET PASSWORD命令修改密码。

mysql> set password for 'root'@'localhost'=password('MIL#5368bst');
Query OK, 0 rows affected, 1 warning (0.01 sec)

退出用新密码登陆

mysql> exit
Bye

$ ./bin/mysql -uroot -p'MIL#5368bst'

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.02 sec)

 

mysql数据库设置密码的其他参数。

更改密码难度。

临时更改：set global validate_password_policy=0;

永久更改：将“global validate_password_policy=0”编辑到my.cny配置文件里面。

更改密码长度。

临时更改：set global validate_password_length=4;

永久更改：将“global validate_password_length=4”编辑到my.cny配置文件里面。

这个其实与validate_password_policy的值有关，默认为1，所以刚开始设置的密码必须符合长度，且必须含有数字，小写或大写字母，特殊字符。如果我们不希望密码设置的那么复杂，需要修改两个全局参数：validate_password_policy与validate_password_length。validate_password_length默认值为8,最小值为4，如果你显性指定validate_password_length的值小于4，尽管不会报错，但validate_password_length的值将设为4。