#yumrepolistall|grepMysqL
#

#vim/etc/yum.repos.d/MysqL-community.repo
#EnabletouseMysqL5.6
[MysqL56-community]
name=MysqL5.6CommunityServer
baseurl=http://repo.MysqL.com/yum/MysqL-5.6-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=

#yumrepolistenabled|grepMysqL
MysqL56-communityMysqL5.6CommunityServer214

#yuminstallMysqL56
//你只会得到
nopackageMysqL56available

#yuminstallMysqL-community-server
//但是，失败了呢
MysqL-community-server-5.6.28-2.el6.x86_64.rpm|53MB00:10

warning:rpmts_HdrFromFdno:HeaderV3DSA/SHA1Signature,keyID5072e1f5:NOKEY
Retrievingkeyfromfile:///etc/pki/rpm-gpg/RPM-GPG-KEY-MysqL
获取GPG密钥失败：[Errno14]Couldnotopen/readfile:///etc/pki/rpm-gpg/RPM-GPG-KEY-MysqL

http://repo.MysqL.com/yum/mysql-5.6-community/el/6/x86_64/MysqL-community-server-5.6.28-2.el6.x86_64.rpm

#vim/etc/pki/rpm-gpg/RPM-GPG-KEY-MysqL
写入如下内容

-----BEGINPGPPUBLICKEYBLOCK----- Version:GnuPGv1.4.9(SunOS)

mQGiBD4+owwRBAC14GIfUfCyEDSIePvEW3SAFUdJBtoQHH/nJKZyQT7h9bPlUWC3
RODjQReyCITRrdwyrKUGku2FmeVGwn2u2WmDMNABLnpprWPkBdCk96+OmSLN9brZ
fw2vOUgCmYv2hW0hyDHuvYlQA/BThQoADgj8AW6/0Lo7V1W9/8VuHP0gQwCgvzV3
BqOxRznNCRCRxAuAuVztHRcEAJooQK1+iSiunZMYD1WufeXfshc57S/+yeJkegNW
hxwR9pRWVArNYJdDRT+rf2RUe3vpquKNQU/hnEIUHJRQqYHo8gTxvxXNQc7fJYLV
K2HtkrPbP72vwsEKMYhhr0eKCbtLGfls9krjJ6sBgACyP/Vb7hipwxh6rDZ7ITnE
kYpXBACmWpP8NJTkamEnPCia2ZoOHODANwpUkP43I7jsDmgtobZX9qnrAXw+uNDI
QJEXM6FSbi0LLtZciNlYsafwAPEOMDKpMqAK6IyisNtPvaLd8lH0bPAnWqcyefep
rv0sxxqUEMcM3o7wwgfN83POkDasDbs3pjwPhxvhz6//62zQJ7Q2TXlTUUwgUmVs
ZWFzZSBFbmdpbmVlcmluZyA8bXlzcWwtYnVpbGRAb3NzLm9yYWNsZS5jb20+iGkE
ExECACkCGyMGCwkIBwMCBBUCCAMEFgIDAQIeAQIXgAIZAQUCUwHUZgUJGmbLywAK
CRCMcY07UHLh9V+DAKCjS1gGwgVI/eut+5L+l2v3ybl+ZgCcD7ZoA341HtoroV3U
6xRD09fUgeq0O015U1FMIFBhY2thZ2Ugc2lnbmluZyBrZXkgKHd3dy5teXNxbC5j
b20pIDxidWlsZEBteXNxbC5jb20+iG8EMBECAC8FAk53Pa0oHSBidWlsZEBteXNx
bC5jb20gd2lsbCBzdG9wIHdvcmtpbmcgc29vbgAKCRCMcY07UHLh9bU9AJ9xDK0o
xJFL9vTl9OSZC4lX0K9AzwCcCrS9cnJyz79eaRjL0s2r/ccljdyIZQQTEQIAHQUC
R6yUtAUJDTBYqAULBwoDBAMVAwIDFgIBAheAABIJEIxxjTtQcuH1B2VHUEcAAQGu
kgCffz4GUEjzXkOi71VcwgCxASTgbe0An34LPr1j9fCbrXWXO14msIADfb5piEwE
ExECAAwFAj4+o9EFgwlmALsACgkQSVDhKrJykfIk4QCfWbEeKN+3TRspe+5xKj+k
QJSammIAnjUz0xFWPlVx0f8o38qNG1bq0cU9iEwEExECAAwFAj5CggMFgwliIokA
CgkQtvXNTca6JD+WkQCgiGmnoGjMojynp5ppvMXkyUkfnykAoK79E6h8rwkSDZou
iz7nMRisH8uyiEYEEBECAAYFAj+s468ACgkQr8UjSHiDdA/2lgCg21IhIMMABTYd
p/IBiUsP/JQLiEoAnRzMywEtujQz/E9ono7H1DkebDa4iEYEEBECAAYFAj+0Q3cA
CgkQhZavqzBzTmbGwwCdFqD1frViC7WRt8GKoOS7hzNN32kAnirlbwpnT7a6NOsQ
83nk11a2dePhiEYEEBECAAYFAkNbs+oACgkQi9gubzC5S1x/dACdELKoXQKkwJN0
gZztsM7kjsIgyFMAnRRMbHQ7V39XC90OIpaPjk3a01tgiEYEExECAAYFAkTxMyYA
CgkQ9knE9GCTUwwKcQCgibak/SwhxWH1ijRhgYCo5GtM4vcAnAhtzL57wcw1Kg1X
m7nVGetUqJ7fiEwEEBECAAwFAkGBywEFgwYi2YsACgkQGFnQH2d7oexCjQCcD8sJ
NDc/mS8m8OGDUOx9VMWcnGkAnj1YWOD+Qhxo3mI/Ul9oEAhNkjcfiEwEEBECAAwF
AkGByzQFgwYi2VgACgkQgcL36+ITtpIiIwCdFVNVUB8xe8mFXoPm4d9Z54PTjpMA
niSPA/ZsfJ3oOMLKar4F0QPPrdrGiEwEEBECAAwFAkGBy2IFgwYi2SoACgkQa3Ds
2V3D9HMJqgCbBYzr5GPXOXgP88jKzmdbjweqXeEAnRSS4G2G/3qD7uhTL1SPT1SH
jWUXiEwEEBECAAwFAkHQkyQFgwXUEWgACgkQfSXKCsEpp8JiVQCghvWvkPqowsw8
w7WSseTcw1tflvkAni+vLHl/DqIly0LkZYn5jzK1dpvfiEwEEBECAAwFAkIrW7oF
gwV5SNIACgkQ5hukiRXruavzEwCgkzL5QkLSypcw9LGHcFSx1ya0VL4An35nXkum
g6cCJ1NP8r2I4NcZWIrqiEwEEhECAAwFAkAqWToFgwd6S1IACgkQPKEfNJT6+GEm
XACcD+A53A5OGM7w750W11ukq4iZ9ckAnRMvndAqn3YTOxxlLPj2UPZiSgSqiEwE
EhECAAwFAkA9+roFgwdmqdIACgkQ8tdcY+OcZZyy3wCgtDcwlaq20w0cNuXFLLNe
EUaFFTwAni6RHN80moSVAdDTRkzZacJU3M5QiEwEEhECAAwFAkEOCoQFgwaWmggA
CgkQOcor9D1qil/83QCeITZ9wIo7XAMjC6y4ZWUL4m+edZsAoMOhRIRi42fmrNFu
vNZbnMGej81viEwEEhECAAwFAkKApTQFgwUj/1gACgkQBA3AhXyDn6jjJACcD1A4
UtXk84J13JQyoH9+dy24714Aniwlsso/9ndICJOkqs2j5dlHFq6oiEwEExECAAwF
Aj5NTYQFgwlXVwgACgkQLbt2v63UyTMFDACglT5G5NVKf5Mj65bFSlPzb92zk2QA
n1uc2h19/IwwrsbIyK/9POJ+JMP7iEwEExECAAwFAkHXgHYFgwXNJBYACgkQZu/b
yM2C/T4/vACfXe67xiSHB80wkmFZ2krb+oz/gBAAnjR2ucpbaonkQQgnC3GnBqmC
vNaJiEwEExECAAwFAkIYgQ4FgwWMI34ACgkQdsEDHKIxbqGg7gCfQi2HcrHn+yLF
uNlH1oSOh48ZM0oAn3hKV0uIRJphonHaUYiUP1ttWgdBiGUEExECAB0FCwcKAwQD
FQMCAxYCAQIXgAUCS3AvygUJEPPzpwASB2VHUEcAAQEJEIxxjTtQcuH1sNsAniYp
YBGqy/HhMnw3WE8kXahOOR5KAJ4xUmWPGYP4l3hKxyNK9OAUbpDVYIh7BDaragA7
BQJCdzX1NB0AT29wcy4uLiBzaG91bGQgaGF2ZSBiZWVuIGxvY2FsISBJJ20gKnNv
KiBzdHVwaWQuLi4ACgkQOcor9D1qil/vRwCdFo08f66oKLiuEAqzlf9iDlPozEEA
n2EgvCYLCCHjfGosrkrU3WK5NFVgiI8EMBECAE8FAkVvAL9IHQBTaG91bGQgaGF2
ZSBiZWVuIGEgbG9jYWwgc2lnbmF0dXJlLCBvciBzb21ldGhpbmcgLSBXVEYgd2Fz
IEkgdGhpbmtpbmc/AAoJednKK/Q9aopfoPsAn3BVqKOalJeF0xPSvLR90PsRlnmG
AJ44oisY7Tl3NJbPgZal8W32fbqgbIkCIgQQAQIADAUCQYHLhQWDBiLZBwAKCRCq
4+bOZqFEaKgvEACCErnaHGyUYa0wETjj6DLEXsqeOiXad4i9aBQxnD35GUgcFofC
/nCY4XcnCMMEnmdQ9ofUuU3OBJ6BNjibEusAabgLooebP/3KEaiCIiyhHYU5jarp
ZAh+Zopgs3Oc11mQ1tIaS69iJxrGTLodkAsAJAeEUwTPq9fHFFzC1eGBysoyFWg4
bIjz/zClI+qyTbFA5g6tRoiXTo8ko7QhY2AA5UGEg+83Hdb6akC04Z2QRErxKAqr
phHzj8XpjVOsQAdAi/qVKQeNKROlJ+iq6+YesmcWGfzeb87dGNweVFDJIGA0qY27
pTb2lExYjsRFN4Cb13NfodAbMTOxcAWZ7jAPCxAPlHUG++mHMrhQXetoZnBFE4nb
nC7vOBNgWdjUgXcpkUCkop4b17BFpR+k8ZtYLSS8p2LLz4uAeCcSm2/msJxT7rC/
FvoH8428oHincqs2ICo9zO/Ud4HmmO0O+SsZdVKIIjinGyOVWb4OOzkAlnnhEZ3o
6hAHcREIsBgPwEYVTj/9ZdC0AO44Nj9cU7awaqgtrnwwfr/o4V2gl8bLSkltZU27
/29HeuOeFGjlFe0YrDd/aRNsxbyb2O28H4sG1CVZmC5uK1iQBdisyA7Q0bbdofCW
oQzm5twlpKWnY8Oe0ub9XP5p/sVfck4FceWFHwv+/PC9RzSl33lQ6vM2wIkCIgQT
AQIADAUCQp8KHAWDBQWacAAKCRDYwgoJWiRXzyE+D/9uc7z6fIsalfOYoLN60ajA
bQbI/uRKBFugyZ5RoaItusn9Z2rAtn61WrFhu4uCSJtFN1ny2RERg40f56pTghKr
D+YEt+Nze6+FKQ5AbGIdFsR/2bUk+ZZRSt83e14Lcb6ii/fJfzkoIox9ltkifQxq
Y7Tvk4noKu4oLSc8O1Wsfc/y0B9sYUUCmUfcnq58DEmGie9ovUslmyt5NPnveXxp
5UeaRc5Rqt9tK2B4A+7/cqENrdZJbAMSunt2+2fkYiRunAFPKPBdJBsY1sxeL/A9
aKe0viKEXQdAWqdNZKNCi8rd/oOP99/9lMbFudAbX6nL2DSb1OG2Z7NWEqgIAzjm
pwYYPCKeVz5Q8R+if9/fe5+STY/55OaI33fJ2H3v+U435VjYqbrerWe36xJItcJe
qUzW71fQtXi1CTEl3w2ch7VF5oj/QyjabLnAlHgSlkSi6p7By5C2MnbCHlCfPnIi
nPhFoRcRGPjJe9nFwGs+QblvS/Chzc2WX3s/2SWm4gEUKRX4zsAJ5ocyfa/vkxCk
SxK/erWlCPf/J1T70+i5waXDN/E3enSet/WL7h94pQKpjz8OdGL4JSBHuAVGA+a+
dknqnPF0KMKLhjrgV+L7O84FhbmAP7PXm3xmiMPriXf+el5fZZequQoIagf8rdRH
HhRJxQgI0HNknkaOqs8dtrkCDQQ+PqMdEAgA7+GJfxbMdY4wslPnjH9rF4N2qfWs
EN/lxaZoJYc3a6M02WCnHl6ahT2/tBK2w1QI4YFteR47gCvtgb6O1JHffOo2HfLm
RDRiRjd1DTCHqeyX7CHhcghj/dNRlW2Z0l5QFEcmV9U0Vhp3aFfWC4Ujfs3LU+hk
AWzE7zaD5cH9J7yv/6xuZVw411x0h4UqsTcWMu0iM1BzELqX1DY7LwoPEb/O9Rkb
f4fmLe11EzIaCa4PqARXQZc4dhSinMt6K3X4BrRsKTfozBu74F47D8Ilbf5vSYHb
uE5p/1oIDznkg/p8kW+3FxuWrycciqFTcNz215yyX39LXFnlLzKUb/F5GwADBQf+
Lwqqa8CGrRfsOAJxim63CHfty5mUc5rUSnTslGYEIOCR1BeQauyPZbPDsDD9MZ1Z
aSafanFvwFG6Llx9xkU7tzq+vKLoWkm4u5xf3vn55VjnSd1aQ9eQnUcXiL4cnBGo
TbOWI39EcyzgslzBdC++MPjcQTcA7p6JUVsP6oAB3FQWg54tuUo0Ec8bsM8b3Ev4
2LmuQT5NdKHGwHsXTPtl0klk4bQk4OajHsiy1BMahpT27jWjJlMiJc+IWJ0mghkK
Ht926s/ymfdf5HkdQ1cyvsz5tryVI3Fx78XeSYfQvuuwqp2H139pXGEkg0n6KdUO
etdZWhe70YGNPw1yjWJT1IhUBBgRAgAMBQJOdz3tBQkT+wG4ABIHZUdQRwABAQkQ
jHGNO1By4fUUmwCbBYr2+bBEn/L2BOcnw9Z/QFWuhRMAoKVgCFm5fadQ3Afi+UQl
AcophrnJ
=443I -----ENDPGPPUBLICKEYBLOCK-----

#yuminstallMysqL-community-server

四、MysqL数据库的初始化及相关配置

我们在安装完MysqL数据库以后，会发现会多出一个MysqLd的服务，这个就是咱们的数据库服务，我们通过输入service MysqLd start命令就可以启动我们的MysqL服务。

注意：如果我们是第一次启动MysqL服务，MysqL服务器首先会进行初始化的配置，如：

[root@xiaoluo ~]# service MysqLd start

初始化 MysqL 数据库： WARNING: The host 'xiaoluo' Could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MysqL version. The MysqL daemon,MysqLd,should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MysqL privileges !
Installing MysqL system tables...
OK
Filling help tables...
OK

To start MysqLd at boot time you have to copy
support-files/MysqL.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MysqL root USER !
To do so,start the server,then issue the following commands:

/usr/bin/MysqLadmin -u root password new-password'
/usr/bin/MysqLadmin -u root -h xiaoluo password '

Alternatively you can run:
/usr/bin/MysqL_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MysqL daemon with:
cd /usr ; /usr/bin/MysqLd_safe &

You can test the MysqL daemon with MysqL-test-run.pl
cd /usr/MysqL-test ; perl MysqL-test-run.pl

Please report any problems with the /usr/bin/MysqLbug script!

                                                           [确定]
正在启动 MysqLd：                                            [确定]

这时我们会看到第一次启动MysqL服务器以后会提示非常多的信息，目的就是对MysqL数据库进行初始化操作，当我们再次重新启动MysqL服务时，就不会提示这么多信息了，如：

[root@xiaoluo ~]# service MysqLd restart
停止 MysqLd：                                             [确定]
正在启动 MysqLd：                                          [确定]

我们在使用MysqL数据库时，都得首先启动MysqLd服务，我们可以 通过chkconfig --list | grep MysqLd命令来查看MysqL服务是不是开机自动启动，如：

[root@xiaoluo ~]# chkconfig --list | grep MysqLd
MysqLd             0:关闭    1:关闭    2:关闭    3:关闭    4:关闭    5:关闭    6:关闭

Centos 6.5 使用 yum 安装 mysql

第 1 步、yum 安装 mysql
[root@stonex ~]#  yum -y install mysql-server
安装结果：
Installed:mysql-server.x86_640:5.1.733.el6_5                                                                             Dependency Installed: mysql.x86_64 0:5.1.73-3.el6_5

perl-DBD-MySQL.x86_64 0:4.013-3.el6    perl-DBI.x86_64 0:1.609-4.el6

第 2 步、设置开机启动
[root@stonex ~]#  chkconfig mysqld on

第 3 步、启动 MySql 服务
[root@stonex ~]#  service mysqld start

第 4 步、设置 MySQL 的 root 用户设置密码
[root@stonex ~]#  mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
...... 省略了一些行
mysql> select user,host,password from mysql.user;
查询用户的密码，都为空，用下面的命令设置 root 的密码为 root
mysql> set password for root@localhost=password(''root'');
mysql> exit

第 5 步、用新密码登陆
[root@stonex ~]#  mysql -u root -p

第 6 步、基本命令
show databases; // 查看系统已存在的数据库
use databasesname;   // 选择需要使用的数据库
drop database databasename; // 删除选定的数据库
exit    // 退出数据库的连接
create database test01;    // 建立名为 test 的数据库
show tables;        // 列出当前数据库下的表
其他基本的增删改查使用标准 SQL 即可

第 7 步、开放远程登录权限

GRANT ALL PRIVILEGES ON *.* TO ''root''@''%'' IDENTIFIED BY ''root'' WITH GRANT OPTION;
FLUSH PRIVILEGES;
（完）

centOS 6.8 yum 安装 mysql5.7

前言

之前一直没有在服务器上折腾过MysqL,今天领导让我在服务器上装一个MysqL,我心想这还不小菜一碟,谁知道这都花费了一天时间,哎,惭愧啊!记录备忘一下.

步骤

• 下载YUM库
  shell
wget https://repo.MysqL.com//MysqL57-community-release-el5-7.noarch.rpm

• 安装YUM库
  shell
yum localinstall -y MysqL57-community-release-el5-7.noarch.rpm

• 安装数据库
  shell
yum install -y MysqL-community-server

• 启动MysqL数据库
  shell
service MysqLd start

• 设置MysqL开机自启动
  shell
chkconfig MysqLd on

• 找到MysqL默认生成的密码
  shell
grep "temporary password" /var/log/MysqLd.log


通过 MysqL -u root -p 命令来登录我们的MysqL数据库,通过上一步的密码登陆,然后修改MysqL,root密码:

shell
SET PASSWORD = PASSWORD('你的新密码');

不过需要注意的是现在MysqL已经强制要求强密码，已经不能再用弱密码比如“123456”了。如果你设置的密码过于简单，会提示错误：

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

• 修改MysqL默认编码为 utf-8
  先关闭MysqL(service MysqLd stop),打开配置文件(默认为/etc/my.cnf ):

[client]
default-character-set=utf8 [MysqL] default-character-set=utf8 [MysqLd] init_connect='SET collation_connection = utf8_unicode_ci' init_connect='SET NAMES utf8' character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake

默认的root账户只能通过localhost访问，可以添加一个账户,命令如下：

shell
GRANT ALL PRIVILEGES ON *.* TO 'new_user'@'%' IDENTIFIED BY 'new_password' WITH GRANT OPTION;


参考资料

Centos 7 yum 安装 mysql5.7
Linux学习之CentOS(十三)–CentOS6.4下Mysql数据库的安装与配置
MySQL 5.7以上 root用户默认密码问题
LINUX启动/重启/停上MYSQL的命令
mysql中通过my.cnf设置默认字符集utf-8

CentOS 6.9 安装 MySQL 5.6 （使用 yum 安装）

CentOS 6.9 安装 MySQL 5.6 （使用 yum 安装）

移除 CentOS 默认的 mysql-libs

[root@test01 srv]# whereis mysql
mysql: /usr/lib64/mysql /usr/share/mysql
[root@test01 srv]#

为了避免冲突，先移除 CenttOS 上默认的 mysql-libs，使用 yum remove mysql-libs 完成，如：
[root@test01 srv]# yum remove mysql-libs
Loaded plugins: fastestmirror
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-libs.x86_64 0:5.1.73-8.el6_8 will be erased
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-8.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-8.el6.x86_64
--> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-8.el6.x86_64
--> Running transaction check
---> Package postfix.x86_64 2:2.6.6-8.el6 will be erased
--> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-16.el6_8.2.x86_64
--> Running transaction check
---> Package cronie.x86_64 0:1.4.4-16.el6_8.2 will be erased
--> Processing Dependency: cronie = 1.4.4-16.el6_8.2 for package: cronie-anacron-1.4.4-16.el6_8.2.x86_64
--> Running transaction check
---> Package cronie-anacron.x86_64 0:1.4.4-16.el6_8.2 will be erased
--> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-33.el6.x86_64
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be erased
---> Package sysstat.x86_64 0:9.0.4-33.el6 will be erased
--> Finished Dependency Resolution
Dependencies Resolved

==============================================================================================================================================================================================================================================================================
Package Arch Version Repository Size
==============================================================================================================================================================================================================================================================================
Removing:
mysql-libs x86_64 5.1.73-8.el6_8 @anaconda-CentOS-201703281317.x86_64/6.9 4.0 M
Removing for dependencies:
cronie x86_64 1.4.4-16.el6_8.2 @anaconda-CentOS-201703281317.x86_64/6.9 174 k
cronie-anacron x86_64 1.4.4-16.el6_8.2 @anaconda-CentOS-201703281317.x86_64/6.9 43 k
crontabs noarch 1.10-33.el6 @anaconda-CentOS-201703281317.x86_64/6.9 2.4 k
postfix x86_64 2:2.6.6-8.el6 @anaconda-CentOS-201703281317.x86_64/6.9 9.7 M
sysstat x86_64 9.0.4-33.el6 @ISO 826 k

Transaction Summary
==============================================================================================================================================================================================================================================================================
Remove 6 Package(s)

Installed size: 15 M
Is this ok [y/N]:
输入 y

Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Erasing : sysstat-9.0.4-33.el6.x86_64 1/6
Erasing : cronie-1.4.4-16.el6_8.2.x86_64 2/6
Erasing : cronie-anacron-1.4.4-16.el6_8.2.x86_64 3/6
Erasing : crontabs-1.10-33.el6.noarch 4/6
Erasing : 2:postfix-2.6.6-8.el6.x86_64 5/6
Erasing : mysql-libs-5.1.73-8.el6_8.x86_64 6/6
Verifying : cronie-anacron-1.4.4-16.el6_8.2.x86_64 1/6
Verifying : cronie-1.4.4-16.el6_8.2.x86_64 2/6
Verifying : 2:postfix-2.6.6-8.el6.x86_64 3/6
Verifying : crontabs-1.10-33.el6.noarch 4/6
Verifying : sysstat-9.0.4-33.el6.x86_64 5/6
Verifying : mysql-libs-5.1.73-8.el6_8.x86_64 6/6

Removed:
mysql-libs.x86_64 0:5.1.73-8.el6_8

Dependency Removed:
cronie.x86_64 0:1.4.4-16.el6_8.2 cronie-anacron.x86_64 0:1.4.4-16.el6_8.2 crontabs.noarch 0:1.10-33.el6 postfix.x86_64 2:2.6.6-8.el6 sysstat.x86_64 0:9.0.4-33.el6

Complete!

[root@test01 srv]#
清空 dbcache
然后，使用 yum clean dbcache 清空 db 缓存，如

[root@test01 srv]# yum clean dbcache
Loaded plugins: fastestmirror
Cleaning repos: ISO
3 sqlite files removed

下载 MySQL rpm 安装包
下载 MySQL rpm 安装包

wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

[root@test01 srv]# wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
--2017-05-08 10:40:29-- http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
Resolving repo.mysql.com... 223.119.236.209
Connecting to repo.mysql.com|223.119.236.209|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5824 (5.7K) [application/x-redhat-package-manager]
Saving to: “mysql-community-release-el6-5.noarch.rpm”

100%[====================================================================================================================================================================================================================================>] 5,824 --.-K/s in 0s

2017-05-08 10:40:29 (298 MB/s) - “mysql-community-release-el6-5.noarch.rpm” saved [5824/5824]

[root@test01 srv]#
安装下载好的 rpm 文件
使用 rpm -ivh mysql-community-release-el6-5.noarch.rpm 安装下载的 rpm 文件～

[root@test01 srv]# rpm -ivh mysql-community-release-el6-5.noarch.rpm
Preparing... ########################################### [100%]
1:mysql-community-release########################################### [100%]

[root@test01 srv]#
yum 安装 mysql-community-server

使用 yum install mysql-community-server 安装 MySQL server。

[root@test01 srv]# yum install mysql-community-server
Loaded plugins: fastestmirror
Setting up Install Process
Loading mirror speeds from cached hostfile
mysql-connectors-community | 2.5 kB 00:00
mysql-connectors-community/primary_db | 15 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql-tools-community/primary_db | 35 kB 00:00
mysql56-community | 2.5 kB 00:00
mysql56-community/primary_db | 183 kB 00:00
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.6.36-2.el6 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.36-2.el6 for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.6.10 for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(warnings) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(strict) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(if) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(Sys::Hostname) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(POSIX) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(Getopt::Long) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(File::Temp) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(File::Spec) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(File::Path) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(File::Copy) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(File::Basename) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(Fcntl) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(Data::Dumper) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: perl(DBI) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: libnuma.so.1(libnuma_1.2)(64bit) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: libnuma.so.1(libnuma_1.1)(64bit) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: /usr/bin/perl for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Processing Dependency: libnuma.so.1()(64bit) for package: mysql-community-server-5.6.36-2.el6.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.6.36-2.el6 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.6.10 for package: mysql-community-client-5.6.36-2.el6.x86_64
---> Package mysql-community-common.x86_64 0:5.6.36-2.el6 will be installed
---> Package numactl.x86_64 0:2.0.9-2.el6 will be installed
---> Package perl.x86_64 4:5.10.1-144.el6 will be installed
--> Processing Dependency: perl-libs = 4:5.10.1-144.el6 for package: 4:perl-5.10.1-144.el6.x86_64
--> Processing Dependency: perl-libs for package: 4:perl-5.10.1-144.el6.x86_64
--> Processing Dependency: perl(version) for package: 4:perl-5.10.1-144.el6.x86_64
--> Processing Dependency: perl(Pod::Simple) for package: 4:perl-5.10.1-144.el6.x86_64
--> Processing Dependency: perl(Module::Pluggable) for package: 4:perl-5.10.1-144.el6.x86_64
--> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.10.1-144.el6.x86_64
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.6.36-2.el6 will be installed
---> Package perl-Module-Pluggable.x86_64 1:3.90-144.el6 will be installed
---> Package perl-Pod-Simple.x86_64 1:3.13-144.el6 will be installed
--> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.13-144.el6.x86_64
---> Package perl-libs.x86_64 4:5.10.1-144.el6 will be installed
---> Package perl-version.x86_64 3:0.77-144.el6 will be installed
--> Running transaction check
---> Package perl-Pod-Escapes.x86_64 1:1.04-144.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved

==============================================================================================================================================================================================================================================================================
Package Arch Version Repository Size
==============================================================================================================================================================================================================================================================================
Installing:
mysql-community-server x86_64 5.6.36-2.el6 mysql56-community 55 M
Installing for dependencies:
mysql-community-client x86_64 5.6.36-2.el6 mysql56-community 18 M
mysql-community-common x86_64 5.6.36-2.el6 mysql56-community 308 k
mysql-community-libs x86_64 5.6.36-2.el6 mysql56-community 1.9 M
numactl x86_64 2.0.9-2.el6 ISO 74 k
perl x86_64 4:5.10.1-144.el6 ISO 10 M
perl-DBI x86_64 1.609-4.el6 ISO 705 k
perl-Module-Pluggable x86_64 1:3.90-144.el6 ISO 41 k
perl-Pod-Escapes x86_64 1:1.04-144.el6 ISO 33 k
perl-Pod-Simple x86_64 1:3.13-144.el6 ISO 213 k
perl-libs x86_64 4:5.10.1-144.el6 ISO 579 k
perl-version x86_64 3:0.77-144.el6 ISO 52 k

Transaction Summary
==============================================================================================================================================================================================================================================================================
Install 12 Package(s)

Total download size: 87 M
Installed size: 373 M
Is this ok [y/N]:
选择 y

Is this ok [y/N]: y
Downloading Packages:
(1/12): mysql-community-client-5.6.36-2.el6.x86_64.rpm | 18 MB 00:01
(2/12): mysql-community-common-5.6.36-2.el6.x86_64.rpm | 308 kB 00:00
(3/12): mysql-community-libs-5.6.36-2.el6.x86_64.rpm | 1.9 MB 00:00
(4/12): mysql-community-server-5.6.36-2.el6.x86_64.rpm | 55 MB 00:03
(5/12): numactl-2.0.9-2.el6.x86_64.rpm | 74 kB 00:00
(6/12): perl-5.10.1-144.el6.x86_64.rpm | 10 MB 00:00
(7/12): perl-DBI-1.609-4.el6.x86_64.rpm | 705 kB 00:00
(8/12): perl-Module-Pluggable-3.90-144.el6.x86_64.rpm | 41 kB 00:00
(9/12): perl-Pod-Escapes-1.04-144.el6.x86_64.rpm | 33 kB 00:00
(10/12): perl-Pod-Simple-3.13-144.el6.x86_64.rpm | 213 kB 00:00
(11/12): perl-libs-5.10.1-144.el6.x86_64.rpm | 579 kB 00:00
(12/12): perl-version-0.77-144.el6.x86_64.rpm | 52 kB 00:00
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 14 MB/s | 87 MB 00:06
warning: rpmts_HdrFromFdno: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Retrieving key from file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
Userid : MySQL Release Engineering <mysql-build@oss.oracle.com>
Package: mysql-community-release-el6-5.noarch (installed)
From : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]:
选择 y

Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Installing : mysql-community-common-5.6.36-2.el6.x86_64 1/12
Installing : mysql-community-libs-5.6.36-2.el6.x86_64 2/12
Installing : 1:perl-Pod-Escapes-1.04-144.el6.x86_64 3/12
Installing : 4:perl-libs-5.10.1-144.el6.x86_64 4/12
Installing : 1:perl-Module-Pluggable-3.90-144.el6.x86_64 5/12
Installing : 1:perl-Pod-Simple-3.13-144.el6.x86_64 6/12
Installing : 3:perl-version-0.77-144.el6.x86_64 7/12
Installing : 4:perl-5.10.1-144.el6.x86_64 8/12
Installing : perl-DBI-1.609-4.el6.x86_64 9/12
Installing : mysql-community-client-5.6.36-2.el6.x86_64 10/12
Installing : numactl-2.0.9-2.el6.x86_64 11/12
Installing : mysql-community-server-5.6.36-2.el6.x86_64 12/12
Verifying : 3:perl-version-0.77-144.el6.x86_64 1/12
Verifying : 4:perl-libs-5.10.1-144.el6.x86_64 2/12
Verifying : 4:perl-5.10.1-144.el6.x86_64 3/12
Verifying : numactl-2.0.9-2.el6.x86_64 4/12
Verifying : mysql-community-common-5.6.36-2.el6.x86_64 5/12
Verifying : perl-DBI-1.609-4.el6.x86_64 6/12
Verifying : mysql-community-server-5.6.36-2.el6.x86_64 7/12
Verifying : mysql-community-libs-5.6.36-2.el6.x86_64 8/12
Verifying : mysql-community-client-5.6.36-2.el6.x86_64 9/12
Verifying : 1:perl-Module-Pluggable-3.90-144.el6.x86_64 10/12
Verifying : 1:perl-Pod-Simple-3.13-144.el6.x86_64 11/12
Verifying : 1:perl-Pod-Escapes-1.04-144.el6.x86_64 12/12

Installed:
mysql-community-server.x86_64 0:5.6.36-2.el6

Dependency Installed:
mysql-community-client.x86_64 0:5.6.36-2.el6 mysql-community-common.x86_64 0:5.6.36-2.el6 mysql-community-libs.x86_64 0:5.6.36-2.el6 numactl.x86_64 0:2.0.9-2.el6 perl.x86_64 4:5.10.1-144.el6 perl-DBI.x86_64 0:1.609-4.el6
perl-Module-Pluggable.x86_64 1:3.90-144.el6 perl-Pod-Escapes.x86_64 1:1.04-144.el6 perl-Pod-Simple.x86_64 1:3.13-144.el6 perl-libs.x86_64 4:5.10.1-144.el6 perl-version.x86_64 3:0.77-144.el6

Complete!
[root@test01 srv]#

启动服务
service mysqld start

[root@test01 srv]# service mysqld start
Initializing MySQL database: 2017-05-08 11:06:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-05-08 11:06:09 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2017-05-08 11:06:09 0 [Note] /usr/sbin/mysqld (mysqld 5.6.36) starting as process 926 ...
2017-05-08 11:06:09 926 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-05-08 11:06:09 926 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-08 11:06:09 926 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-08 11:06:09 926 [Note] InnoDB: Memory barrier is not used
2017-05-08 11:06:09 926 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-05-08 11:06:09 926 [Note] InnoDB: Using Linux native AIO
2017-05-08 11:06:09 926 [Note] InnoDB: Not using CPU crc32 instructions
2017-05-08 11:06:09 926 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-05-08 11:06:09 926 [Note] InnoDB: Completed initialization of buffer pool
2017-05-08 11:06:09 926 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2017-05-08 11:06:09 926 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2017-05-08 11:06:09 926 [Note] InnoDB: Database physically writes the file full: wait...
2017-05-08 11:06:09 926 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2017-05-08 11:06:09 926 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2017-05-08 11:06:09 926 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2017-05-08 11:06:09 926 [Warning] InnoDB: New log files created, LSN=45781
2017-05-08 11:06:09 926 [Note] InnoDB: Doublewrite buffer not found: creating new
2017-05-08 11:06:09 926 [Note] InnoDB: Doublewrite buffer created
2017-05-08 11:06:09 926 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-08 11:06:09 926 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-05-08 11:06:09 926 [Note] InnoDB: Foreign key constraint system tables created
2017-05-08 11:06:09 926 [Note] InnoDB: Creating tablespace and datafile system tables.
2017-05-08 11:06:09 926 [Note] InnoDB: Tablespace and datafile system tables created.
2017-05-08 11:06:09 926 [Note] InnoDB: Waiting for purge to start
2017-05-08 11:06:09 926 [Note] InnoDB: 5.6.36 started; log sequence number 0
2017-05-08 11:06:09 926 [Note] Binlog end
2017-05-08 11:06:09 926 [Note] InnoDB: FTS optimize thread exiting.
2017-05-08 11:06:09 926 [Note] InnoDB: Starting shutdown...
2017-05-08 11:06:11 926 [Note] InnoDB: Shutdown completed; log sequence number 1625977


2017-05-08 11:06:11 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-05-08 11:06:11 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2017-05-08 11:06:11 0 [Note] /usr/sbin/mysqld (mysqld 5.6.36) starting as process 948 ...
2017-05-08 11:06:11 948 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-05-08 11:06:11 948 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-08 11:06:11 948 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-08 11:06:11 948 [Note] InnoDB: Memory barrier is not used
2017-05-08 11:06:11 948 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-05-08 11:06:11 948 [Note] InnoDB: Using Linux native AIO
2017-05-08 11:06:11 948 [Note] InnoDB: Not using CPU crc32 instructions
2017-05-08 11:06:11 948 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-05-08 11:06:11 948 [Note] InnoDB: Completed initialization of buffer pool
2017-05-08 11:06:11 948 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-08 11:06:11 948 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-08 11:06:11 948 [Note] InnoDB: Waiting for purge to start
2017-05-08 11:06:11 948 [Note] InnoDB: 5.6.36 started; log sequence number 1625977
2017-05-08 11:06:11 948 [Note] Binlog end
2017-05-08 11:06:11 948 [Note] InnoDB: FTS optimize thread exiting.
2017-05-08 11:06:11 948 [Note] InnoDB: Starting shutdown...
2017-05-08 11:06:13 948 [Note] InnoDB: Shutdown completed; log sequence number 1625987




PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password ''new-password''
/usr/bin/mysqladmin -u root -h test01.znyj.interconnect password ''new-password''

Alternatively you can run:

/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

Note: new default config file not created.
Please make sure your config file is current

WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server

[ OK ]
Starting mysqld: [ OK ]

[root@test01 srv]#
修改密码
默认密码是空的～使用 mysql -uroot 进入～

[root@test01 srv]# mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.36 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, 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>
修改密码～

使用 update user set password=PASSWORD ("YOUR_PASSWORD") where user=''root''；修改 root 账号密码～

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set password=PASSWORD("YOUR_PASSWORD") where user=''root''
-> ;
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>
密码验证
重新登录 mysql 服务，验证修改后的密码～

mysql> quit
Bye
[root@test01 srv]# mysql -uroot
ERROR 1045 (28000): Access denied for user ''root''@''localhost'' (using password: NO)
[root@test01 srv]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.36 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, 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>
至此，MySQL 安装完毕～

关于在 CentOS 7 上 yum 安装 MYSQL 8.0的问题就给大家分享到这里，感谢你花时间阅读本站内容，更多关于centos 6.5 yum安装 mysql 5.6、Centos 6.5 使用 yum 安装 mysql、centOS 6.8 yum 安装 mysql5.7、CentOS 6.9 安装 MySQL 5.6 （使用 yum 安装）等相关知识的信息别忘了在本站进行查找喔。