centos 6.9 yum mysql_CentOS6.9yum安装mysql-community-5.6.40

CentOS6.9yum安装mysql-community-5.6.40

1. 检测系统已安装mysql

[root@zaibei-db ~]# yum list installed | grep mysql

mysql-libs.x86_64 5.1.73-8.el6_8 @anaconda-CentOS-201703281317.x86_64/6.9

zabbix-server-mysql.x86_64

zabbix-web-mysql.noarch

# 如果发现有系统自带mysql

[root@zaibei-db ~]# yum -y remove mysql-libs.x86_64

2.

随便在你存放文件的目录下执行，这里解释一下，由于这个mysql的yum源服务器在国外，所以下载速度会比较慢，还好mysql5.6只有79M大，而mysql5.7就有182M了，所以这是我不想安装mysql5.7的原因

[root@zaibei-db ~]# wget

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

[root@zaibei-db ~]# ls -l

total 32

-rw-------. 1 root root 910

Dec 4 15:56 anaconda-ks.cfg

drwxr-xr-x 2 root root 4096 May 12 10:28

files_backup

-rw-r--r--. 1 root root 8845 Dec 4 15:56

install.log

-rw-r--r--. 1 root root 3384 Dec 4 15:55

install.log.syslog

-rw-r--r-- 1 root root 5824 Nov

12 2015

mysql-community-release-el6-5.noarch.rpm

3. 接着执行这句，这个rpm还不是mysql的安装文件，只是两个yum源文件，执行后，在/etc/yum.repos.d/

这个目录下多出mysql-community-source.repo和mysql-community.repo

[root@zaibei-db ~]# ls -l /etc/yum.repos.d/

total 40

drwxr-xr-x 2 root root 4096 May 12 17:55 bak

-rw-r--r-- 1 root root 1991 May 4 09:39

CentOS-Base.repo

-rw-r--r-- 1 root root 647

May 4 09:39 CentOS-Debuginfo.repo

-rw-r--r-- 1 root root 289

May 4 09:39 CentOS-fasttrack.repo

-rw-r--r-- 1 root root 630

May 4 09:39 CentOS-Media.repo

-rw-r--r-- 1 root root 7989 May 4 09:39

CentOS-Vault.repo

-rw-r--r-- 1 root root 957

Nov 5 2012 epel.repo

-rw-r--r-- 1 root root 1056 Nov 5 2012 epel-testing.repo

-rw-r--r-- 1 root root 401 Feb

20 2016 zabbix.repo

[root@zaibei-db ~]# rpm -ivh

mysql-community-release-el6-5.noarch.rpm

Preparing... ########################################### [100%]

1:mysql-community-release###########################################

[100%]

[root@zaibei-db ~]# ls -l /etc/yum.repos.d/

total 48

drwxr-xr-x 2 root root 4096 May 12 17:55 bak

-rw-r--r-- 1 root root 1991 May 4 09:39

CentOS-Base.repo

-rw-r--r-- 1 root root 647

May 4 09:39 CentOS-Debuginfo.repo

-rw-r--r-- 1 root root 289

May 4 09:39 CentOS-fasttrack.repo

-rw-r--r-- 1 root root 630

May 4 09:39 CentOS-Media.repo

-rw-r--r-- 1 root root 7989 May 4 09:39

CentOS-Vault.repo

-rw-r--r-- 1 root root 957

Nov 5 2012 epel.repo

-rw-r--r-- 1 root root 1056 Nov 5 2012 epel-testing.repo

-rw-r--r-- 1 root root 1209 Dec 2 2013 mysql-community.repo

-rw-r--r-- 1 root root 1060 Dec 2 2013 mysql-community-source.repo

-rw-r--r-- 1 root root 401 Feb

20 2016 zabbix.repo

4. 查看是否已经有mysql可安装文件

[root@zaibei-db ~]# yum repolist all | grep mysql

mysql-connectors-community MySQL

Connectors Community enabled: 49

mysql-connectors-community-source MySQL Connectors Community -

S disabled

mysql-tools-community MySQL Tools

Community enabled: 61

mysql-tools-community-source MySQL Tools Community -

Source disabled

mysql55-community MySQL 5.5 Community Server disabled

mysql55-community-source MySQL 5.5

Community Server - S disabled

mysql56-community MySQL 5.6 Community Server enabled: 434

mysql56-community-source MySQL 5.6

Community Server - S disabled

mysql57-community-dmr MySQL 5.7 Community Server Dev

disabled

mysql57-community-dmr-source MySQL 5.7 Community Server

Dev disabled

5. 安装 mysql

[root@zaibei-db ~]# yum install mysql-community-server

[root@zaibei-db ~]# yum list installed | grep mysql

6. 启动 mysql

[root@zaibei-db ~]# vim /etc/my.cnf

[client]

socket=/usr/local/mysql/mysql.sock

[root@zaibei-db ~]# service mysqld start

...

Starting mysqld: [ OK ]

7. 用 mysql 的 root 用户登录(第一次回车键，不用输入密码)，并修改密码

[root@zaibei-db ~]# mysql -u root

mysql> use mysql;

mysql> SELECT host,user,password,plugin FROM user;

mysql> SET PASSWORD = PASSWORD('mysql9527');

mysql> SELECT host,user,password,plugin FROM user;

mysql> flush privileges;

mysql> exit

[root@zaibei-db ~]# mysql -u root -p

Enter password:

mysql>

8. 查看 mysql 是否自启动,并且设置开启自启动

[root@zaibei-db ~]# chkconfig --list | grep mysqld

mysqld 0:off 1:off 2:off 3:on 4:on

5:on 6:off

[root@zaibei-db ~]# chkconfig mysqld on

[root@zaibei-db ~]# chkconfig --list | grep mysqld

mysqld 0:off 1:off 2:on 3:on 4:on

5:on 6:off

9. mysql 安全设置(optional)

# mysql_secure_installation //谨慎执行

!!!The end!!!