Centos 7.x 系安装 mysql-community-common-5.7.13-1.el7.x86_64.rpm

落日映苍穹つ 2022-05-28 00:35 223阅读 0赞

1、修改主机名称 （修改主机名永久生效）  
\[root@localhost ~\]\# hostnamectl set-hostname OA-TS-DB-test  
\[root@OA-TS-DB-test ~\]\# hostname  
OA-TS-DB-test

\[root@OA-TS-DB-test ~\]\# uname -a  
Linux instance-y514l7ol 3.10.0-693.11.1.el7.x86\_64 \#1 SMP Mon Dec 4 23:52:40 UTC 2017 x86\_64 x86\_64 x86\_64 GNU/Linux

\#\#这里注意内核的版本信息

2、上传mysql-5.7.13-1.el7.x86\_64.rpm-bundle.tar>mysql-5.7.13-1. el7.x86\_64.rpm-bundle.tar 文件并解压  
\[root@OA-TS-DB-test src\]\# rpm -ivh --nodeps --force mysql-community-common-5.7.13-1.el7.x86\_64.rpm  
\[root@OA-TS-DB-test src\]\# rpm -ivh --nodeps --force mysql-community-libs-5.7.13-1.el7.x86\_64.rpm  
\[root@OA-TS-DB-test src\]\# rpm -ivh --nodeps --force mysql-community-client-5.7.13-1.el7.x86\_64.rpm  
\[root@OA-TS-DB-test src\]\# rpm -ivh --nodeps --force mysql-community-server-5.7.13-1.el7.x86\_64.rpm  
  
3、创建MySQL自定义MySQL 目录文件  
\[root@OA-TS-DB-test src\]\# mkdir /data/mysqldata/data3306 -p  
\[root@OA-TS-DB-test src\]\# chown -R mysql.mysql /data/mysqldata/data3306/  
  
4、配置my.cnf 配置文件  
\[root@OA-TS-DB-test src\]\#  cat << EOF > /etc/my.cnf  
\[client\]  
port = 3306  
socket = /tmp/mysql.sock  
default-character-set = utf8  
  
\[mysqld\]  
user = mysql  
port = 3306  
socket = /tmp/mysql.sock  
basedir = /usr/local/mysql  
datadir = /data/mysqldata/data3306  
pid-file = /data/mysqldata/data3306/mysql.pid  
  
bind-address = 0.0.0.0  
server-id = 1  
  
init-connect = 'SET NAMES utf8'  
character-set-server = utf8  
\#skip-name-resolve  
\#skip-networking  
back\_log = 300  
max\_connections = 1000  
max\_connect\_errors = 6000  
open\_files\_limit = 65535  
table\_open\_cache = 128  
max\_allowed\_packet = 4M  
binlog\_cache\_size = 1M  
max\_heap\_table\_size = 8M  
tmp\_table\_size = 16M  
read\_buffer\_size = 2M  
read\_rnd\_buffer\_size = 8M  
sort\_buffer\_size = 8M  
join\_buffer\_size = 8M  
key\_buffer\_size = 4M  
thread\_cache\_size = 8  
query\_cache\_type = 1  
query\_cache\_size = 8M  
query\_cache\_limit = 2M  
ft\_min\_word\_len = 4  
  
log\_bin = mysql-bin  
binlog\_format = mixed  
expire\_logs\_days = 30  
  
log\_error = /data/mysqldata/data3306/mysql-error.log  
slow\_query\_log = 1  
long\_query\_time = 1  
  
slow\_query\_log\_file = /data/mysqldata/data3306/mysql-slow.log  
performance\_schema = 0  
explicit\_defaults\_for\_timestamp  
lower\_case\_table\_names = 1  
skip-external-locking  
  
default\_storage\_engine = InnoDB  
\#default-storage-engine = MyISAM  
innodb\_file\_per\_table = 1  
innodb\_file\_format = Barracuda  
innodb\_open\_files = 500  
innodb\_buffer\_pool\_size = 64M  
innodb\_write\_io\_threads = 4  
innodb\_read\_io\_threads = 4  
innodb\_thread\_concurrency = 0  
innodb\_purge\_threads = 1  
innodb\_flush\_log\_at\_trx\_commit = 2  
innodb\_log\_buffer\_size = 200M  
innodb\_log\_file\_size = 320M  
innodb\_log\_files\_in\_group = 3  
innodb\_max\_dirty\_pages\_pct = 90  
innodb\_lock\_wait\_timeout = 120  
  
bulk\_insert\_buffer\_size = 8M  
myisam\_sort\_buffer\_size = 8M  
myisam\_max\_sort\_file\_size = 10G  
myisam\_repair\_threads = 1  
interactive\_timeout = 28800  
wait\_timeout = 28800  
  
\[mysqldump\]  
quick  
max\_allowed\_packet = 16M  
  
\[myisamchk\]  
key\_buffer\_size = 8M  
sort\_buffer\_size = 8M  
read\_buffer = 4M

write\_buffer = 4M

EOF

5、MySQL 数据库初始化（不推荐）  
第一种：生成密码  cat /var/log/mysqld.log    \#\#竟然没有密码，好奇怪~~  
mysqld --initialize --user=mysql  
  
第二种：没有密码（推荐）  
mysqld --initialize-insecure --user=mysql

6、启动MySQL服务如出现报错，

systemctl start mysqld

mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such f  
  
解决方法：  
\[root@OA-TS-DB-test src\]\#  yum install -y libaio  
  
7、登录MySQL 5.7.13  
\[root@OA-TS-DB-test data3306\]\# 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.13-log MySQL Community Server (GPL)  
  
Copyright (c) 2000, 2016, 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> show databases;  
\+--------------------+  
| Database           |  
\+--------------------+  
| information\_schema |  
| mysql              |  
| performance\_schema |  
| sys                |  
\+--------------------+  
4 rows in set (0.00 sec)  
  
mysql> select version();  
\+------------+  
| version()  |  
\+------------+  
| 5.7.13-log |  
\+------------+  
1 row in set (0.00 sec)  
  
mysql> select user,host,authentication\_string,plugin from mysql.user;  
\+-----------+-----------+-------------------------------------------+-----------------------+  
| user      | host      | authentication\_string                     | plugin                |  
\+-----------+-----------+-------------------------------------------+-----------------------+  
| root      | localhost |                                           | mysql\_native\_password |  
| mysql.sys | localhost | \*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql\_native\_password |  
\+-----------+-----------+-------------------------------------------+-----------------------+  
2 rows in set (0.00 sec)  
  
  
mysql> update mysql.user set authentication\_string=password("Tongyuan-DB2018%") where User='root' and host='localhost';                       
Query OK, 1 row affected, 1 warning (0.01 sec)  
  
mysql> select user,host,authentication\_string,plugin from mysql.user;  
\+-----------+-----------+-------------------------------------------+-----------------------+  
| user      | host      | authentication\_string                     | plugin                |  
\+-----------+-----------+-------------------------------------------+-----------------------+  
| root      | localhost | \*D0E1BA1F955BD0963E9A1F29A1139C7C08EEAF48 | mysql\_native\_password |  
| mysql.sys | localhost | \*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql\_native\_password |  
\+-----------+-----------+-------------------------------------------+-----------------------+  
2 rows in set (0.00 sec)

\#\#\#授权账号

mysql> grant all on tejian.\* to tejian\_guest@"%" identified by 'Tongyuan\_guest2018%';   
Query OK, 0 rows affected, 1 warning (0.00 sec)  
  
mysql>   
mysql> flush privileges;  
Query OK, 0 rows affected (0.00 sec)