mysql的安装（5.7.22）

虚拟环境：VMware 12

连网方式：桥接

系统版本：CentOS 6.5

安装前，最好清理已安装的低版本的mysql，并且配置、检查yum源，是否都能正常工作。

删除系统自动安装的低版本mysql：
1、查看有哪些包：# rpm -qa|grep -i mysql 
2、卸载安装的mysql ：# yum remove mysql
3、查看残留的包：# rpm -qa|grep -i mysql
4、逐个手动删除残留包：# yum remove -y 残留的包名
5、# rm -rf /etc/my.cnf 、# rm -rf /usr/share/mysql 或者rm -rf /var/lib/mysql（根据自己环境删除即可）

安装

安装前准备工作：
----确保这些依赖的包要提前安装好
#yum -y install gcc gcc-c++ ncurses ncurses-devel bison libgcrypt perl 
#groupadd mysql
#useradd -r -g mysql -s /bin/false -M mysql
#mkdir -p /home/mysql/{data,log,tmp}
#ls /home/mysql/
#chown -R mysql:mysql /home/mysql/

需要的软件包：boost_1_59_0.tar.gz，cmake-3.6.1.tar.gz，mysql-5.7.22.tar.gz（建议使用bing搜索引擎，能迅速找到下载的页面。）
1、解压cmake、mysql压缩包(# tar -xf cmake-3.6.1.tar.gz;# tar -xf mysql-5.7.22.tar.gz)，切换到cmake的目录下，编译安装cmake，执行：# ./bootstrap && make && make install
2、首先，是检查mysql安装环境，执行命令：# cmake . -DCMAKE_INSTALL_PREFIX=/home/mysql/mysql-5.7 -DMYSQL_DATADIR=/home/mysql/data -DMYSQL_UNIX_ADDR=/home/mysql/tmp/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_TCP_PORT=3306 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DWITH_BOOST=/usr/local/boost_1_59_0 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_DEBUG=0
3、然后，编译安装：# make && make install

4、添加环境变量：
# echo "export PATH=$PATH:/home/mysql/mysql-5.7">>/etc/profile
# source /etc/profile

5、切换到/home/mysql/mysql-5.7，执行：
# cp support-files/mysql.server /etc/init.d/mysqld

6、切换到/home/mysql/mysql-5.7/bin，在执行下列命令前需把/home/mysql/data/目录下的文件清空。
[root@Robert ~]# mysqld --initialize-insecure --user=mysql --basedir=/home/mysql/mysql-5.7/ --datadir=/home/mysql/data/  --explicit_defaults_for_timestamp
2018-07-22T11:38:47.247233Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-07-22T11:38:47.503559Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-07-22T11:38:47.576094Z 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: cbf42414-8da3-11e8-996b-000c29695a3f.
2018-07-22T11:38:47.578430Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-07-22T11:38:47.580128Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
----------有warn也无所谓，先不管他。先启动。-----------
[root@Robert ~]# /etc/init.d/mysqld start
Starting MySQL.Logging to '/home/mysql/data/Robert.err'.
. SUCCESS! 
-------------------数据库启动成功，因此 MySQL.5.7.22版本没有配置文件也是可以的。----------------
[root@Robert ~]# echo '/home/mysql/mysql-5.7/include/' >> /etc/ld.so.conf
[root@Robert ~]# echo '/home/mysql/mysql-5.7/lib/' >> /etc/ld.so.conf
[root@Robert ~]# ldconfig 
-------------------进入数据库，改密码，刷新权限。-------------------------------
[root@Robert ~]# mysql
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)

mysql> update mysql.user set authentication_string=password('hahaha666') where user='root' ;
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 1

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye