centos7和centos6.5環(huán)境rpm方式安裝mysql5.7和mysql5.6詳解

發(fā)布時(shí)間：2020-05-19 23:51:01 來(lái)源：網(wǎng)絡(luò) 閱讀：4587 作者：Mr_sheng 欄目：MySQL數(shù)據(jù)庫(kù)

centos7和centos6.5環(huán)境rpm方式安裝mysql5.7和mysql5.6詳解

centos環(huán)境安裝mysql5.7

其實(shí)不建議安裝mysql5.7 語(yǔ)法和配置可能和以前的版本區(qū)別較大，多坑，慎入

1.yum方式安裝(不推薦)

a.安裝mysql5.7 yum源

centos6:

wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
yum localinstall mysql-community-release-el6-5.noarch.rpm

centos7:

wget dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
yum localinstall mysql57-community-release-el7-7.noarch.rpm

yum方式安裝：
yum install mysql-community-server

2.rpm方式安裝(推薦)
因yum源是在國(guó)外下載速度非常慢，建議直接下載后通過(guò)本地安裝

centos6:
mysql-community-client-5.7.15-1.el6.x86_64.rpm
mysql-community-common-5.7.15-1.el6.x86_64.rpm
mysql-community-libs-5.7.15-1.el6.x86_64.rpm
mysql-community-server-5.7.15-1.el6.x86_64.rpm

centos7:
mysql-community-client-5.7.15-1.el7.x86_64.rpm
mysql-community-common-5.7.15-1.el7.x86_64.rpm
mysql-community-libs-5.7.15-1.el7.x86_64.rpm
mysql-community-server-5.7.15-1.el7.x86_64.rpm

yum localinstall -y mysql-community*.rpm

報(bào)錯(cuò)：
Error: Package: 2:postfix-2.6.6-6.el6_7.1.x86_64 (localyum)
Requires: libmysqlclient.so.16(libmysqlclient_16)(64bit)
Removing: mysql-libs-5.1.71-1.el6.x86_64 (@anaconda-CentOS-201311272149.x86_64/6.5)
libmysqlclient.so.16(libmysqlclient_16)(64bit)
Obsoleted By: mysql-community-libs-5.7.15-1.el6.x86_64 (/mysql-community-libs-5.7.15-1.el6.x86_64)
Not found
Updated By: mysql-libs-5.1.73-7.el6.x86_64 (localyum)
libmysqlclient.so.16(libmysqlclient_16)(64bit)
Error: Package: 2:postfix-2.6.6-6.el6_7.1.x86_64 (localyum)
Requires: libmysqlclient.so.16()(64bit)
Removing: mysql-libs-5.1.71-1.el6.x86_64 (@anaconda-CentOS-201311272149.x86_64/6.5)
libmysqlclient.so.16()(64bit)
Obsoleted By: mysql-community-libs-5.7.15-1.el6.x86_64 (/mysql-community-libs-5.7.15-1.el6.x86_64)
Not found
Updated By: mysql-libs-5.1.73-7.el6.x86_64 (localyum)
libmysqlclient.so.16()(64bit)
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

解決辦法：
rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64

1）默認(rèn) root 密碼為空，其實(shí)不為空，使用 mysql -u root -p 進(jìn)行登錄失敗
2)mysql_secure_installation這個(gè)初始化也不行

直接編輯mysql配置文件
vim /etc/my.cnf
加入
skip-grant-tables
注意：要加在[mysqld]的位置

重啟數(shù)據(jù)庫(kù)

#進(jìn)入 mysql控制臺(tái)

# mysql

可能的報(bào)錯(cuò)：

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

解決辦法：加上-h227.0.0.1
[root@node2 bin]# mysql -h227.0.0.1 -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.15 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.13 sec)

>use mysql;

# 修改密碼
>update user set authentication_string = password('yourpasswd'), password_expired = 'N', password_last_changed = now() where user = 'root';

刪掉skip-grant-tables，再次重啟即可

添加用戶時(shí)，報(bào)錯(cuò)，是因?yàn)槊艽a策略的問(wèn)題，我們只是測(cè)試，密碼不需要那么復(fù)雜

mysql> grant all privileges on test.* to jack@'%' identified by "test";

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

修改密碼策略即可
mysql> set global validate_password_policy=0;

mysql5.7開(kāi)發(fā)環(huán)境的配置示例：

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections=1024
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_UNSIGNED_SUBTRACTION"
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation_server = utf8mb4_general_ci
init_connect='SET NAMES utf8mb4'

ucloud mysql5.7配置：

[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
back_log = 2000
basedir = /opt/udb/program/mysql/mysql-5.7.12
bind-address = 127.0.0.1
binlog-format = MIXED
character-set-client-handshake = 0
character_set_server = utf8mb4
datadir = /opt/udb/instance/mysql-5.7/xxxxxxxx/data
event_scheduler = ON
expire_logs_days = 7
general-log-file = /opt/udb/instance/mysql-5.7/xxxxxxxx/log/mysqld.log
init_connect = 'SET NAMES utf8mb4'
innodb_buffer_pool_size = 377487360
innodb_data_file_path = ibdata1:100M:autoextend
innodb_data_home_dir = /opt/udb/instance/mysql-5.7/xxxxxxxx/data
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_io_capacity = 2000
innodb_log_buffer_size = 8388608
innodb_log_file_size = 512M
innodb_log_files_in_group = 2
innodb_log_group_home_dir = /opt/udb/instance/mysql-5.7/xxxxxxxx/data
innodb_max_dirty_pages_pct = 50
innodb_open_files = 1024
innodb_read_io_threads = 8
innodb_thread_concurrency = 20
innodb_write_io_threads = 8
key_buffer_size = 33554432
local_infile = 1
log-bin = /opt/udb/instance/mysql-5.7/xxxxxxxx/binlog/mysql-bin.log
log-error = /opt/udb/instance/mysql-5.7/xxxxxxxx/log/mysqld.log
log_bin_trust_function_creators = 1
log_output = TABLE
long_query_time = 3
max_allowed_packet = 16777216
max_connect_errors = 1000000
max_connections = 2000
myisam_sort_buffer_size = 8388608
net_buffer_length = 8192
performance_schema = 0
performance_schema_max_table_instances = 200
pid-file = /opt/udb/instance/mysql-5.7/xxxxxxxx/mysqld.pid
port = 3306
query_cache_size = 16777216
read_buffer_size = 262144
read_rnd_buffer_size = 524288
relay-log = /opt/udb/instance/mysql-5.7/xxxxxxxx/relaylog/mysql-relay.log
secure-file-priv = /opt/udb/instance/mysql-5.7/xxxxxxxx/tmp
server-id = 2130706433
skip-slave-start
skip_name_resolve
slave-load-tmpdir = /opt/udb/instance/mysql-5.7/xxxxxxxx/tmp
slave-parallel-type = LOGICAL_CLOCK
slave_parallel_workers = 8
slow-query-log-file = /opt/udb/instance/mysql-5.7/xxxxxxxx/log/mysql-slow.log
slow_query_log = 1
socket = /opt/udb/instance/mysql-5.7/xxxxxxxx/mysqld.sock
sort_buffer_size = 524288
sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_UNSIGN
sync_binlog = 1
table_open_cache = 128
thread_cache_size = 50
tmpdir = /opt/udb/instance/mysql-5.7/xxxxxxxx/tmp
user = mysql
[mysqld_safe]
log-error = /opt/udb/instance/mysql-5.7/xxxxxxxx/log/mysqld.log
pid-file = /opt/udb/instance/mysql-5.7/xxxxxxxx/mysqld.pid

centos6.5環(huán)境安裝mysql5.6

操作系統(tǒng)：centos6.5 x86_64

1.檢查下linux是不是已經(jīng)安裝了mysql
rpm -qa | grep -i mysql

#如果安裝了先卸載舊的版本
rpm -e --nodeps mysql...

rpm -e --nodeps mysql-libs-5.1.73-5.el6_6.x86_64

2.下載需要的安裝包，下載地址：
http://dev.mysql.com/downloads/mysql/5.6.html#downloads

MySQL-client-5.6.34-1.el6.x86_64.rpm
MySQL-devel-5.6.34-1.el6.x86_64.rpm
MySQL-server-5.6.34-1.el6.x86_64.rpm

全部安裝

yum install numactl -y
rpm -ivh MySQL-*.rpm

3.修改配置文件位置并做相關(guān)設(shè)置

cp /usr/share/mysql/my-default.cnf /etc/my.cnf

默認(rèn)的數(shù)據(jù)庫(kù)放在/var/lib/mysql目錄下，我們需要將數(shù)據(jù)庫(kù)放在/data/yunva/mysqldata 目錄下，主要是/var/lib是系統(tǒng)根目錄，數(shù)據(jù)庫(kù)文件較大的時(shí)候系統(tǒng)磁盤(pán)空間會(huì)不夠

vim /etc/my.cnf

innodb_file_per_table = 1
datadir = /data/yunva/mysql/mysqldata
log-bin=/data/yunva/mysql/binlogs/mysql-bin

修改目錄權(quán)限

chmod 755 /data/yunva/mysql/

mkdir -p /data/yunva/mysql/mysqldata

mkdir /data/yunva/mysql/binlogs/

# 注意必須給mysqldata和mysqlbin目錄賦權(quán)給mysql否則無(wú)法啟動(dòng)
chown -R mysql.mysql /data/yunva/mysql

刪除匿名用戶
mysql> delete from user where user='' and host='localhost' or host='monitor01';

添加root密碼
mysql> update user set password=PASSWORD('pass');
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0

mysql> flush privileges;

如果之前的版本有安裝，需要重置root密碼，可以在my.cnf的mysqld步伐加入，重啟mysql，不輸入密碼即可進(jìn)數(shù)據(jù)庫(kù)
skip-grant-tables

密碼默認(rèn)位置：

# cat /root/.mysql_secret

4.初始化MySQL及設(shè)置密碼

/usr/bin/mysql_install_db
service mysql start

可能碰到的錯(cuò)誤：
明明已經(jīng)修改了mysql.user表中的root密碼，執(zhí)行命令報(bào)錯(cuò)：

mysql> show databases;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql> use mysql;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

解決辦法：
mysql> SET PASSWORD = PASSWORD('123');
Query OK, 0 rows affected (0.00 sec)

報(bào)錯(cuò)：

# rpm -ivh MySQL-server-5.6.34-1.el6.x86_64.rpm
warning: MySQL-server-5.6.34-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
libnuma.so.1()(64bit) is needed by MySQL-server-5.6.34-1.el6.x86_64
libnuma.so.1(libnuma_1.1)(64bit) is needed by MySQL-server-5.6.34-1.el6.x86_64
libnuma.so.1(libnuma_1.2)(64bit) is needed by MySQL-server-5.6.34-1.el6.x86_64

解決辦法：
[root@monitor01 software]# yum install numactl -y

報(bào)錯(cuò)：

# service mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/data/yunva/mysqldata/10-10-50-133.pid).

是因?yàn)樯霞?jí)目錄/data/yunva對(duì)mysql沒(méi)有權(quán)限

解決辦法：chown -R mysql.mysq /data/yunva

向AI問(wèn)一下細(xì)節(jié)

centos7和centos6.5環(huán)境rpm方式安裝mysql5.7和mysql5.6詳解