RPM,YUM,二进制安装MySQL和修改密码

YUM
yum在线安装，前提是要连网，可以根据ping www.baidu.com来查看是否连网

先下载 MySQL Yum Repository
wget -c https://repo.mysql.com//mysql80-community-release-el7-5.noarch.rpm
添加 MySQL Yum Repository
yum localinstall mysql80-community-release-el7-5.noarch.rpm

选择安装发行版`
禁用8.0版本，启用5.7版本
yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community
验证
yum repolist enabled | grep mysql

MySQL 5.7 Community Server就是我们要下载的版本
在线安装
yum install mysql-community-server

启动数据库，查看状态
systemctl enable --now mysqld
systemctl status mysqld

active(running)就代表数据库正在运行

RPM
此方法适用于离线安装进入MySQL的官网https://www.mysql.com/

选择要下载的版本和相对的系统版本
下载RPM安装包

用tar命令解压查看
tar xf mysql-5.7.14-1.el7.x86_64.rpm-bundle.tar
ls -l mysql-community*

mysql-community-client 客户端
mysql-community-devel 开发库
mysql-community-common 服务端和客户端的公共文件mysql-community-embedded 嵌入式
mysql-community-serve 服务端
mysql-community-test 测试组件
mysql-community-libs 共享库
mysql-community-libs-compatMySQL之前版本的共享兼容库安装
首先要限制mariadb相关软件包，不然会下载不成功，相当于一山不容二虎，不能同时存在yum remove mariadb-libs
用rpm安装
rpm -ivh mysql-community-client-5.7.14-1.el7.x86_64.rpm mysql-community-common-5.7.14 1.el7.x86_64.rpm mysql-community-libs-5.7.14-1.el7.x86_64.rpm mysql-community-server 5.7.14-1.el7.x86_64.rpm
启动MySQL
systemctl start mysqld
systemctl enable mysqld

二进制
进入官网，选择下载Generic二进制版本64位

新建用户以安全方式运行进程
groupadd -r mysql
useradd -g -r mysql -s /bin/false mysql

用tar命令解压
tar xf mysql-5.7.14-linux-glibc2.5-x86_64.tar -C /usr/local/
安装并初始化mysql
将压缩包软链接成“mysql”方便操作
[root@localhost ~]# cd /usr/local/
[root@localhost local]# tar xf mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz[root@localhost local]# ln -sv mysql-5.7.14-linux-glibc2.5-x86_64 mysql"mysql" -> “mysql-5.7.14-linux-glibc2.5-x86_64”[root@localhost local]# chown -R mysql.mysql mysql/*
初始化
mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
记住临时密码，方便后面修改密码

为mysql提供服务脚本
[root@localhost mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/
[root@localhost ~]# vim /etc/init.d/mysql.serverbasedir= /usr/local/mysqldatadir =/data/mysql

修改mariadb配置文件
vim /etc/my.cnf

启动MySQL
chkconfig --add mysqld --添加为系统服务
chkconfig mysqld on --开机自启动systemctl start mysqld
配置修改密码
方法1:
[root@localhost ~]# systemctl enable --now mysqld
[root@localhost ~]# grep password /var/log/mysqld.log [root@localhost~]#tmp_pwd=awk'/temporary/{print$NF}'/var/log/mysqld.log
显示的就是临时密码

[root@localhost ~]# mysql -uroot -pKaTeX parse error: Expected 'EOF', got '#' at position 243: …ot@localhost ~]#̲ mysqladmin -ur…tmp_pwd password ‘newpassword’
输入新密码

修改成功
方法2:
mysqladmin -uroot -p password

修改成功