源码包安装 MySQL 配置过程

V1.1可安装MySQL数据库

1.下载MySQL源码包与C++语言扩展程序库

[root@localhost /]# wget -c https://www.kuaidown.top/boost_1_59_0.tar.gz   #C++语言扩展程序库
[root@localhost /]# wget -c https://www.kuaidown.top/mysql-5.7.21.tar.gz   #MySQL源码包

2.解压boost扩展包，并移至/usr/local/boost

[root@localhost /]# tar -xzf boost_1_59_0.tar.gz   #解压boost扩展包
[root@localhost /]# mv boost_1_59_0 /usr/local/boost   并移至/usr/local/boost，并改名为boost

3.安装MySQL各种依赖包

[root@localhost ~]# yum install gcc-c++ ncurses-devel cmake make perl gcc autoconf automake zlib libxml libgcrypt libtool bison -y

4.解压MySQL源码包，并使用cmake预编译MySQL源码包

[root@localhost /]# tar -xzf  mysql-5.7.21.tar.gz   #解压MySQL源码包
[root@localhost /]# cd mysql-5.7.21   #进入mysql-5.7.21中
[root@localhost mysql-5.7.21]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5/ \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DMYSQL_DATADIR=/data/mysql/ \
-DSYSCONFDIR=/etc \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306 \
-DWITH_XTRADB_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EXTRA_CHARSETS=1 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DWITH_BIG_TABLES=1 \
-DWITH_DEBUG=0 \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/usr/local/boost

5.进行编译与编译安装(ps:安装时间比较久，请耐心等待)

[root@localhost mysql-5.7.21]# make && make install

6.创建mysql用户

[root@localhost mysql-5.7.21]# useradd -s /sbin/nologin mysql

7.修改目录权限

[root@localhost mysql-5.7.21]# mkdir -p /data/mysql && chown mysql:mysql -R /data/mysql
[root@localhost mysql-5.7.21]# cd /usr/local/mysql5 && chown mysql:mysql -R .

8.编辑 /etc/my.cnf 文件，修改为如下配置

[mysqld]
# These are commonly set, remove the # and set as required.
 basedir = /usr/local/mysql5
 datadir = /data/mysql
 port = 3306
# server_id = .....
 socket = /tmp/mysql.sock
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

9.初始化 mysql 程序

[root@localhost bin]# /usr/local/mysql5/bin/mysqld --initialize --user=mysql --datadir=/data/mysql --basedir=/usr/local/mysql5

如下图，需要保存初始密码

10.善后配置(不明所以)

[root@localhost mysql5]# ln -s /usr/local/mysql5/bin/* /usr/bin/
[root@localhost mysql5]# \cp support-files/mysql.server  /etc/init.d/mysqld
[root@localhost mysql5]# chmod +x /etc/init.d/mysqld
[root@localhost mysql5]# chkconfig --add mysqld
[root@localhost mysql5]# chkconfig --level 35 mysqld on

11.重启MySQL

[root@localhost mysql5]# service mysqld start
Starting MySQL.Logging to '/data/mysql/localhost.localdomain.err'.
 SUCCESS!

12.查看MySQL端口是否启动

[root@localhost mysql5]# netstat -antp|grep mysql
tcp6       0      0 :::3306                 :::*                    LISTEN      26504/mysqld

13.登录MySQL服务器

[root@localhost ~]# mysql -uroot -p   #登录MySQL服务器
Enter password:                       #密码密文不显示，按随机密码输入即可
登录完成需要先修改密码否则报如下错误：
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> alter user 'root'@'localhost' identified by 'TIAOCHUN';   #修改默认登录密码

14.测试MySQL是否正常可使用

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)
mysql>
mysql> exit   #可以使用退出MySQL

查看MySQL版本信息

[root@localhost mysql5]# mysql -V
mysql  Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using  EditLine wrapper