Centos 下 mysql 安装过程
1. 检查系统自带的mysql,并卸载自带的版本
[root@iz2366ycl7sz config]# yum list installed |grep mysql mysql.x86_64 5.1.73-5.el6_6 @base mysql-libs.x86_64 5.1.73-5.el6_6 @base php56w-mysql.x86_64 5.6.40-1.w6 @webtatic
2. 卸载系统自带的mysql及其依赖
[root@iz2366ycl7sz config]# yum -y remove mysql-libs.x86_64 loaded plugins: security setting up remove process resolving dependencies --> running transaction check ---> package mysql-libs.x86_64 0:5.1.73-5.el6_6 will be erased --> processing dependency: libmysqlclient.so.16()(64bit) for package: php56w-mysql-5.6.40-1.w6.x86_64 --> processing dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64 --> processing dependency: libmysqlclient.so.16()(64bit) for package: mysql-5.1.73-5.el6_6.x86_64 --> processing dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: php56w-mysql-5.6.40-1.w6.x86_64 --> processing dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64 --> processing dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: mysql-5.1.73-5.el6_6.x86_64 --> processing dependency: libmysqlclient_r.so.16()(64bit) for package: php56w-mysql-5.6.40-1.w6.x86_64 --> processing dependency: libmysqlclient_r.so.16()(64bit) for package: mysql-5.1.73-5.el6_6.x86_64 --> processing dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: php56w-mysql-5.6.40-1.w6.x86_64 --> processing dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: mysql-5.1.73-5.el6_6.x86_64 --> processing dependency: mysql-libs for package: 2:postfix-2.6.6-6.el6_5.x86_64 --> processing dependency: mysql-libs = 5.1.73-5.el6_6 for package: mysql-5.1.73-5.el6_6.x86_64 --> running transaction check ---> package mysql.x86_64 0:5.1.73-5.el6_6 will be erased ---> package php56w-mysql.x86_64 0:5.6.40-1.w6 will be erased ---> package postfix.x86_64 2:2.6.6-6.el6_5 will be erased --> finished dependency resolution dependencies resolved ======================================================================================================================================== package arch version repository size ======================================================================================================================================== removing: mysql-libs x86_64 5.1.73-5.el6_6 @base 4.0 m removing for dependencies: mysql x86_64 5.1.73-5.el6_6 @base 2.4 m php56w-mysql x86_64 5.6.40-1.w6 @webtatic 457 k postfix x86_64 2:2.6.6-6.el6_5 @updates 9.7 m transaction summary ======================================================================================================================================== remove 4 package(s) installed size: 17 m downloading packages: running rpm_check_debug running transaction test transaction test succeeded running transaction erasing : php56w-mysql-5.6.40-1.w6.x86_64 1/4 erasing : 2:postfix-2.6.6-6.el6_5.x86_64 2/4 erasing : mysql-5.1.73-5.el6_6.x86_64 3/4 erasing : mysql-libs-5.1.73-5.el6_6.x86_64 4/4 verifying : mysql-libs-5.1.73-5.el6_6.x86_64 1/4 verifying : php56w-mysql-5.6.40-1.w6.x86_64 2/4 verifying : mysql-5.1.73-5.el6_6.x86_64 3/4 verifying : 2:postfix-2.6.6-6.el6_5.x86_64 4/4 removed: mysql-libs.x86_64 0:5.1.73-5.el6_6 dependency removed: mysql.x86_64 0:5.1.73-5.el6_6 php56w-mysql.x86_64 0:5.6.40-1.w6 postfix.x86_64 2:2.6.6-6.el6_5 complete!
3. 给centos添加rpm源,并且选择较新的源
1)下载rpm包
[root@iz2366ycl7sz software]# wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm --no-check-certificate --2019-03-29 14:45:46-- http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm resolving dev.mysql.com... 137.254.60.11 connecting to dev.mysql.com|137.254.60.11|:80... connected. http request sent, awaiting response... 301 moved permanently location: https://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm [following] --2019-03-29 14:45:46-- https://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm connecting to dev.mysql.com|137.254.60.11|:443... connected. http request sent, awaiting response... 302 found location: https://repo.mysql.com//mysql-community-release-el6-5.noarch.rpm [following] --2019-03-29 14:45:48-- https://repo.mysql.com//mysql-community-release-el6-5.noarch.rpm resolving repo.mysql.com... 104.127.195.16 connecting to repo.mysql.com|104.127.195.16|:443... 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 2019-03-29 14:45:48 (506 mb/s) - “mysql-community-release-el6-5.noarch.rpm” saved [5824/5824]
2)安装本地mysql源
[root@iz2366ycl7sz software]# yum localinstall mysql-community-release-el6-5.noarch.rpm loaded plugins: security setting up local package process examining mysql-community-release-el6-5.noarch.rpm: mysql-community-release-el6-5.noarch marking mysql-community-release-el6-5.noarch.rpm to be installed resolving dependencies --> running transaction check ---> package mysql-community-release.noarch 0:el6-5 will be installed --> finished dependency resolution dependencies resolved ======================================================================================================================================== package arch version repository size ======================================================================================================================================== installing: mysql-community-release noarch el6-5 /mysql-community-release-el6-5.noarch 4.3 k transaction summary ======================================================================================================================================== install 1 package(s) total size: 4.3 k installed size: 4.3 k 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 installing : mysql-community-release-el6-5.noarch 1/1 verifying : mysql-community-release-el6-5.noarch 1/1 installed: mysql-community-release.noarch 0:el6-5 complete!
3)验证是否安装成功
[root@iz2366ycl7sz software]# yum repolist all | grep mysql mysql-connectors-community mysql connectors community enabled: 83 mysql-connectors-community-source mysql connectors community - s disabled mysql-tools-community mysql tools community enabled: 74 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: 493 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
4)修改默认版本为5.7
注:如下是截取的老徐之前文章 -》原文
如上,默认是5.6版本可用,如果想安装5.7怎么操作?
有如下两个方法:
方法一:
执行:
yum-config-manager --disable mysql56-community
yum-config-manager --enable mysql57-community-dmr
如上操作,是把5.6禁用,把5.7启用
此法,会有异常情况:
如果执行命令出现如下错误:
-bash: yum-config-manager: command not found
可用执行如下命令解决,然后继续上面的操作命令:
yum -y install yum-utils
注意:如上操作可能有一部分同学的会出现一些问题;好处是操作简单,两个命令搞定~
如果有问题,底部给老徐留言~
方法二:
直接编辑配置文件,简单、直接,基本不会出现错误~
vi /etc/yum.repos.d/mysql-community.repo
把5.6的enabled=0
把5.7的enabled=1
然后保存就ok
# enable to use mysql 5.5
[mysql55-community]
name=mysql 5.5 community server
baseurl=http://repo.mysql.com/yum/mysql-5.5-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/rpm-gpg-key-mysql
# enable to use mysql 5.6
[mysql56-community]
name=mysql 5.6 community server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/rpm-gpg-key-mysql
# note: mysql 5.7 is currently in development. for use at your own risk.
# please read with sub pages: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/
[mysql57-community-dmr]
name=mysql 5.7 community server development milestone release
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/rpm-gpg-key-mysql
如上,颜色标记处 。
此时,再执行:
yum repolist all | grep mysql
就可以看到,5.7是启用的
[root@localhost webserver]# yum repolist all | grep mysql
mysql-connectors-community mysql connectors community 启用: 21
mysql-connectors-community-source mysql connectors community - sourc 禁用
mysql-tools-community mysql tools community 启用: 38
mysql-tools-community-source mysql tools community - source 禁用
mysql55-community mysql 5.5 community server 禁用
mysql55-community-source mysql 5.5 community server - sourc 禁用
mysql56-community mysql 5.6 community server 禁用
mysql56-community-source mysql 5.6 community server - sourc 禁用
mysql57-community-dmr mysql 5.7 community server develop 启用: 130
mysql57-community-dmr-source mysql 5.7 community server develop 禁用
如上 。
ok,至此,基础准备工作完成 。
4. 安装mysql
执行如下命令:
yum install mysql-community-server
[root@iz2366ycl7sz software]# yum install mysql-community-server loaded plugins: security setting up install process resolving dependencies --> running transaction check ---> package mysql-community-server.x86_64 0:5.7.25-1.el6 will be installed --> processing dependency: mysql-community-common(x86-64) = 5.7.25-1.el6 for package: mysql-community-server-5.7.25-1.el6.x86_64 --> processing dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.25-1.el6.x86_64 --> running transaction check ---> package mysql-community-client.x86_64 0:5.7.25-1.el6 will be installed --> processing dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.25-1.el6.x86_64 ---> package mysql-community-common.x86_64 0:5.7.25-1.el6 will be installed --> running transaction check ---> package mysql-community-libs.x86_64 0:5.7.25-1.el6 will be installed --> finished dependency resolution dependencies resolved ======================================================================================================================================== package arch version repository size ======================================================================================================================================== installing: mysql-community-server x86_64 5.7.25-1.el6 mysql57-community-dmr 153 m installing for dependencies: mysql-community-client x86_64 5.7.25-1.el6 mysql57-community-dmr 23 m mysql-community-common x86_64 5.7.25-1.el6 mysql57-community-dmr 332 k mysql-community-libs x86_64 5.7.25-1.el6 mysql57-community-dmr 2.1 m transaction summary ======================================================================================================================================== install 4 package(s) total download size: 178 m installed size: 887 m is this ok [y/n]: y downloading packages: (1/4): mysql-community-client-5.7.25-1.el6.x86_64.rpm | 23 mb 00:01 (2/4): mysql-community-common-5.7.25-1.el6.x86_64.rpm | 332 kb 00:00 (3/4): mysql-community-libs-5.7.25-1.el6.x86_64.rpm | 2.1 mb 00:00 (4/4): mysql-community-server-5.7.25-1.el6.x86_64.rpm | 153 mb 00:04 ---------------------------------------------------------------------------------------------------------------------------------------- total 32 mb/s | 178 mb 00:05 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 (@/mysql-community-release-el6-5.noarch) from : file:/etc/pki/rpm-gpg/rpm-gpg-key-mysql is this ok [y/n]: y running rpm_check_debug running transaction test transaction test succeeded running transaction installing : mysql-community-common-5.7.25-1.el6.x86_64 1/4 installing : mysql-community-libs-5.7.25-1.el6.x86_64 2/4 installing : mysql-community-client-5.7.25-1.el6.x86_64 3/4 installing : mysql-community-server-5.7.25-1.el6.x86_64 4/4 verifying : mysql-community-libs-5.7.25-1.el6.x86_64 1/4 verifying : mysql-community-common-5.7.25-1.el6.x86_64 2/4 verifying : mysql-community-client-5.7.25-1.el6.x86_64 3/4 verifying : mysql-community-server-5.7.25-1.el6.x86_64 4/4 installed: mysql-community-server.x86_64 0:5.7.25-1.el6 dependency installed: mysql-community-client.x86_64 0:5.7.25-1.el6 mysql-community-common.x86_64 0:5.7.25-1.el6 mysql-community-libs.x86_64 0:5.7.25-1.el6 complete!
5. 启动mysql
[root@iz2366ycl7sz software]# service mysqld start initializing mysql database: [ ok ] starting mysqld: [ ok ]
6. 查看mysql服务状态
[root@iz2366ycl7sz software]# service mysqld status mysqld (pid 7036) is running...
7. 查看mysql 初始密码
mysql5.7之后初始密码不再默认为空
[root@iz2366ycl7sz software]# grep 'temporary password' /var/log/mysqld.log 2019-03-29t07:09:36.375706z 1 [note] a temporary password is generated for root@localhost: xo%lbtyoo2mv
其中,最后的xo%lbtyoo2mv 就是密码
8. 命令行登录mysql ,并修改密码
登录之后 第一步必须先修改密码,
否则其他操作都执行不了。
mysql -u root -p
mysql> show databases; error 1820 (hy000): you must reset your password using alter user statement before executing this statement. mysql>
9. 修改密码的方法:
alter user root@localhost identified by 'passwd';
# 'passwd' 里,填写你的新密码 。
新修改的密码中 必须包含 大小写字母数字及符号
end 。
完整的mysql相关操作,见之前的文章
补充,
搭建博客的文章文章 -》