安装mysql二进制文件_【MySQL】MySQL基于二进制文件安装

本篇主要演示在Linux上使用二进制文件进行MySQL的安装，具体过程如下：

1、下载二进制压缩文件mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz；

[root@strong ~]# ll /u01/

total 1499868

drwx------. 2 root root 16384 Feb 27 20:53 lost+found

-rw-r--r--. 1 root root 641798603 Mar 3 20:08 mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz

-rw-r--r--. 1 root root 894037512 Mar 3 20:08 mysql-cluster-gpl-7.5.9-linux-glibc2.12-x86_64.tar.gz

[root@strong ~]#

2、创建MySQL用户和组；

[root@strong ~]# groupadd mysql

[root@strong ~]# useradd -r -g mysql -s /bin/false mysql

3、解压缩MySQL压缩包；

[root@strong u01]# cd /usr/local/

[root@strong local]# tar zxvf /u01/mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz

[root@strong local]# ln -s mysql-5.7.21-linux-glibc2.12-x86_64/ mysql

[root@strong local]# cd mysql

[root@strong mysql]# mkdir mysql-files

[root@strong mysql]# chown mysql:mysql mysql-files/

[root@strong mysql]# chmod 750 mysql-files/

4、设置MySQL数据库；

[root@strong mysql]# ./bin/mysqld --initialize --user=mysql

2018-03-04T02:28:06.686061Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2018-03-04T02:28:07.218770Z 0 [Warning] InnoDB: New log files created, LSN=45790

2018-03-04T02:28:07.361069Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2018-03-04T02:28:07.431017Z 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: aca9194e-1f53-11e8-9c95-000c29d02424.

2018-03-04T02:28:07.438362Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2018-03-04T02:28:07.440935Z 1 [Note] A temporary password is generated for root@localhost: (owD!npaZ5dd --临时密码

5、启动MySQL并重置root密码；

[root@strong mysql]# ./bin/mysqld_safe --user=mysql &

[1] 2696

[root@strong mysql]# Logging to '/usr/local/mysql/data/strong.mysql.com.err'.

2018-03-04T02:49:57.520487Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

[root@strong mysql]# ./bin/mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.21

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> alter user 'root'@'localhost' identified by 'root'; --修改密码

Query OK, 0 rows affected (0.01 sec)

6、拷贝MySQL.server；

[root@strong mysql]# cp support-files/mysql.server /etc/init.d/mysql.server

7、查看MySQL服务状态；

[root@strong mysql]# service mysql.server status

SUCCESS! MySQL running (2766)

[root@strong mysql]# ps aux |grep mysql

root 2696 0.0 0.3 113268 3080 pts/0 S 10:49 0:00 /bin/sh ./bin/mysqld_safe --user=mysql

mysql 2766 0.1 19.1 1119688 191228 pts/0 Sl 10:49 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=strong.mysql.com.err --pid-file=strong.mysql.com.pid

root 2913 0.0 0.2 112668 2216 pts/0 R+ 10:57 0:00 grep --color=auto mysql

[root@strong mysql]#

8、创建my.cnf配置文件；

[root@strong mysql]# more /etc/my.cnf

[mysqld]

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

character_set_server=utf8

[mysql]

default-character_set=utf8

至此，MySQL安装完毕；