Mysql的安装（RPM版）本人亲测过 没毛病

CenterOS7环境下安装Mysql

下载Mysql

https://dev.mysql.com/downloads/mysql/5.5.html?os=31&version=5.1

检查系统是否自带Mysql

rpm -qa | grep mysql

如果有，删除掉

rpm -e --nodeps  mysql的名称

检查是否自带mariadb

rpm -qa|grep mariadb

 

有就删除掉

rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

通过工具(xshell)将mysql安装包上传到/usr/local

将其解压到Mysql目录下

tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql

 

rpm安装

/var/run/yum.pid 已被锁定 解决办法

rm -f /var/run/yum.pid 
yum install glibc.i686

安装之前先安装需要的依赖，否则会报依赖错误

yum install libaio

 

按顺序进行安装 

rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm 
rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm 
rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm

数据库初始化

mysqld --initialize --user=mysql

查看日志文件

cat /var/log/mysqld.log 

注意：红色标记的是生成mysql的临时密码

启动mysql数据库

systemctl start mysqld.service

进入Mysql数据库（用临时密码）

mysql -uroot -p

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';     //新密码

管理mysql

启动mysql服务
    systemctl start mysqld.service
停止mysql服务
    systemctl stop mysqld.service
重启mysql服务
    systemctl restart mysqld.service
查看mysql服务当前状态
    systemctl status mysqld.service
设置mysql服务开机自启动
    systemctl enable mysqld.service
停止mysql服务开机自启动
    systemctl disable mysqld.service

重新安装时要删掉以下目录

rm -fr /var/lib/mysql

远程连接Mysql服务器

开启mysql的远程访问

添加一个用户供其远程连接访问
GRANT ALL PRIVILEGES ON *.* TO 'myxq'@'%' IDENTIFIED BY '1234' WITH GRANT OPTION;
flush privileges;
退出重启systemctl restart  mysqld

开放端口

开放端口
    firewall-cmd --zone=public --add-port=3306/tcp --permanent
重新载入
    firewall-cmd --reload
查看
    firewall-cmd --zone= public --query-port=3306/tcp
删除
    firewall-cmd --zone= public --remove-port=3306/tcp --permanent
重启防火墙服务
    systemctl restart firewalld.service 

开启与关闭防火墙

systemctl stop firewalld.service   停止firewall
systemctl start firewalld   启动
systemctl status firewalld  查看状态
systemctl restart firewalld.service     重新启动防火墙
重启防火墙时遇到 Failed to start firewalld.service: Unit firewalld.service is masked
    执行：systemctl unmask firewalld.service
    再从新启动systemctl start firewalld
    
systemctl disable firewalld.service     禁止firewall开机启动
firewall-cmd --reload       重回加载防火墙