Centos6 通过RPM部署Mysql5.7

墨蓝 2022-06-10 08:54 171阅读 0赞

1.下载对应版本的mysql  rpm安装包

本人用的是centos6.8 64位系统，[mysql安装包官方下载地址 ][mysql]

2.安装mysql5.7

###    安装步骤如下 ###

①.查看系统已经安装过其他版本的mysql

yum list installed | grep mysql  查看是否有安装过mysql  通过yum remove 卸载  
  
  
    rpm -qa | grep -i mysql 查看是否有rpm包  通过rpm -e --nodeps移除

②. 安装依赖(Mysql5.7 需要安装)

yum -y install numactl

③.安装mysql rpm包

![Image 1][]

只需要安装其中的四个

rpm -ivh  mysql-community-common-5.7.19-1.el6.x86_64.rpm
        rpm -ivh mysql-community-libs-5.7.19-1.el6.x86_64.rpm
        rpm -ivh mysql-community-client-5.7.19-1.el6.x86_64.rpm
        rpm -ivh  mysql-community-server-5.7.19-1.el6.x86_64.rpm

![Image 1][]

④.修改mysql配置文件my.cnf

[client]  
        default-character-set=utf8
      
        [mysqld]  
        character_set_server=utf8

⑤.启动mysql并查看mysql初始化的随机密码

service mysqld start

grep 'temporary password' /var/log/mysqld.log

![Center][]

⑥.修改初始密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

需要注意是的 5.7中 设置的密码安全度有点高，需要有大小写字母数字特殊字符，可以更改后，再去my.cnf中加入validate\_password=OFF 去除密码安全度验证。

最后附上 自用的生产环境Mysql配置(部分配置用于主从同步可以忽略，具体参数根据服务器配置设置)

> \[client\]
> 
> port= 3306
> 
> socket= /tmp/mysql.sock
> 
>   
> 
> 
>   
> 
> 
> \[mysqld\]
> 
> basedir=/usr
> 
> datadir=/data/mysql
> 
> port=3306
> 
> socket=/tmp/mysql.sock
> 
> character-set-server = utf8mb4
> 
> default-storage-engine  = InnoDB
> 
> symbolic-links=0
> 
> skip-name-resolve = 1
> 
> open\_files\_limit = 65535
> 
> back\_log = 384
> 
> max\_connections = 5000
> 
> max\_connect\_errors = 100000
> 
> table\_open\_cache = 2048
> 
> tmp-table-size   = 32M
> 
> max-heap-table-size = 32M
> 
>   
> 
> 
>   
> 
> 
> \#query-cache-type  = 0
> 
> query-cache-size  = 0
> 
> external-locking = FALSE
> 
> max\_allowed\_packet = 32M
> 
> sort\_buffer\_size = 2M
> 
> join\_buffer\_size = 2M
> 
> thread\_cache\_size = 51
> 
> query\_cache\_size = 32M
> 
> tmp\_table\_size = 512M
> 
> max\_heap\_table\_size = 96M
> 
> query\_cache\_type=1
> 
> log-error=/data/logs/mysqld.log
> 
> slow\_query\_log = 1
> 
> slow\_query\_log\_file = /data/logs/slow.log
> 
> long\_query\_time = 0.1
> 
>   
> 
> 
>   
> 
> 
> \# BINARY LOGGING \#
> 
> server-id = 1
> 
> log-bin          = /data/binlog/mysql-bin
> 
> log-bin-index    =/data/binlog/mysql-bin.index
> 
> expire-logs-days = 14
> 
> sync\_binlog = 1
> 
> binlog\_cache\_size = 2048M
> 
> max\_binlog\_cache\_size = 4096M
> 
> max\_binlog\_size = 1024M
> 
> log\_slave\_updates
> 
> \#binlog\_format = row 
> 
> binlog\_format = MIXED 
> 
> relay\_log\_recovery = 1
> 
> pid-file=/data/mysql/mysqld.pid
> 
>   
> 
> 
>   
> 
> 
> \#不需要同步的表
> 
> \#replicate-wild-ignore-table=mydb.sp\_counter
> 
> \#不需要同步的库
> 
> replicate-ignore-db = mysql,information\_schema,performance\_schema,sys
> 
> key\_buffer\_size = 768M
> 
> read\_buffer\_size = 1M
> 
> read\_rnd\_buffer\_size = 16M
> 
> bulk\_insert\_buffer\_size = 64M
> 
> myisam\_sort\_buffer\_size = 128M
> 
> myisam\_max\_sort\_file\_size = 10G
> 
> myisam\_repair\_threads = 1
> 
> myisam\_recover\_options=force,backup
> 
> transaction\_isolation = REPEATABLE-READ
> 
> \#innodb\_additional\_mem\_pool\_size = 16M
> 
> innodb\_buffer\_pool\_size = 18G
> 
> innodb\_buffer\_pool\_load\_at\_startup = 1
> 
> innodb\_buffer\_pool\_dump\_at\_shutdown = 1
> 
> innodb\_data\_file\_path = ibdata1:1024M:autoextend
> 
> innodb\_flush\_log\_at\_trx\_commit = 2
> 
> innodb\_log\_buffer\_size = 128M
> 
> innodb\_log\_file\_size = 2G
> 
> innodb\_log\_files\_in\_group = 2
> 
> innodb\_io\_capacity = 4000
> 
> innodb\_io\_capacity\_max = 8000
> 
> innodb\_max\_dirty\_pages\_pct = 50
> 
> innodb\_flush\_method = O\_DIRECT
> 
> innodb\_file\_format = Barracuda
> 
> innodb\_file\_format\_max = Barracuda
> 
> innodb\_lock\_wait\_timeout = 10
> 
> innodb\_rollback\_on\_timeout = 1
> 
> innodb\_print\_all\_deadlocks = 1
> 
> innodb\_file\_per\_table = 1
> 
> innodb\_locks\_unsafe\_for\_binlog = 0
> 
>   
> 
> 
>   
> 
> 
> lower\_case\_table\_names=1
> 
> validate\_password=OFF
> 
> sql\_mode=STRICT\_TRANS\_TABLES,NO\_ZERO\_IN\_DATE,NO\_ZERO\_DATE,ERROR\_FOR\_DIVISION\_BY\_ZERO,NO\_AUTO\_CREATE\_USER,NO\_ENGINE\_SUBSTITUTION
> 
> \#\# Thread settings
> 
> \#thread\_concurrency=24
> 
> \#thread\_cache\_size=250
> 
> \[mysqldump\]
> 
> quick
> 
> max\_allowed\_packet = 128M

[mysql]: https://dev.mysql.com/downloads/mysql/
[Image 1]: 
[Center]: /images/20220610/1c21e44dfffb4dc4bc7d7894e094e2e3.png