centos7下rpm安装升级MySQL服务
下载系统对应的升级包文件
去点击此处下载,下载对应文件:mysql-community-server-、mysql-community-libs-、mysql-community-client-、mysql-community-common-*上传到对应目录下;
检查是否安装过mysql
如果你是用rpm安装,检查一下rpm package。
rpm -qa | grep -i mysql
检查一下msyql service
systemctl status mysqld.service 或 systemctl status mysqld
卸载老的mysql
如果你是用rpm安装,检查一下rpm package。
[root@tiantian ~] rpm -qa | grep -i mysql
mysql-community-server-5.7.10-1.el7.x86_64
mysql-community-libs-5.7.10-1.el7.x86_64
mysql-community-common-5.7.10-1.el7.x86_64
mysql-community-client-5.7.10-1.el7.x86_64
卸载之前安装的对应服务
rpm -ev mysql-community-libs-5.7.10-1.el7.x86_64 mysql-community-client-5.7.10-1.el7.x86_64 …
如果报错执行如下命令,使用强力模式删除
rpm -e --nodeps mysql-community-libs-5.7.10-1.el7.x86_64 mysql-community-client-5.7.10-1.el7.x86_64 …
如果你是用编译安装,查找mysql所在位置。
[root@tiantian ~] find / -name mysql
/usr/share/mysql
/usr/lib64/mysql
/etc/selinux/targeted/active/modules/100/mysql
/etc/selinux/targeted/tmp/modules/100/mysql
/var/lib/mysql
/var/lib/mysql/mysql
依次使用删除命令全部删除掉,再使用上面检查的方式查看是否删除完毕
rm -rf /usr/lib64/mysql /usr/share/mysql
执行安装
第一步:rpm -ivh mysql-community-common-5.7.10-1.el7.x86_64.rpm
第二步:rpm -ivh mysql-community-libs-5.7.10-1.el7.x86_64.rpm
第三步:rpm -ivh mysql-community-client-5.7.10-1.el7.x86_64.rpm
第四步:rpm -ivh mysql-community-server-5.7.10-1.el7.x86_64.rpm
检查安装状态
mysql --version 或者 mysqldadmin --version
新安装的mysql服务需要重新设置密码,root@localhost后面的就是初始化的密码
cat /var/log/mysqld.log
登陆修改密码
mysql -h 127.0.0.1 -u root -p
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘new password’;
修改远程登陆
mysql -h 127.0.0.1 -u root -p
use mysql;
select Host,User from user;
update user set host = ‘%’ where user = ‘root’;
flush privileges;
相关命令
#加不加.service后缀都可以
启动:systemctl start mysqld.service
开机启动:systemctl enable mysqld.service
关闭:systemctl stop mysqld.service
重启:systemctl restart mysqld.service
查看状态:systemctl status mysqld.service
开启、查看、关闭防火墙命令
systemctl start firewalld.service
systemctl status firewalld.service
systemctl stop firewalld.service
#设置开机启用防火墙
systemctl enable firewalld.service
#设置开机禁用防火墙
systemctl disable firewalld.service
#开放3306端口
firewall-cmd --add-port=3306/tcp --permanent
#重新刷新防火墙
firewall-cmd --reload