一、安装
1.通过wget命令或者从官网下载mysql5.7的rpm包(5.7.22)为例:
2.先把postfix 和mariadb-libs卸载掉,不然的会有依赖包冲突:
rpm -e postfix mariadb-libs
3.安装mysql的依赖net-tools和 perl:
yum -y install net-tools perl
4.安装mysql-common包:
rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
5.安装mysql-libs包:
rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
6.安装mysql-client包:
rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
7.安装mysql-server包:
rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
8.设置开机启动:
systemctl enable mysqld
9.启动MySql服务:
systemctl start mysqld
10.由于MySQL5.7安装好后会给root⽤户分配⼀个临时密码,所以我们先查看临时密码
grep 'temporary password' /var/log/mysqld.log
2022-06-01T18:40:08.341478Z 1 [Note] A temporary password is generated for root@localhost: Ctdsfs
即:localhost:后面的就是临时密码了
11.使⽤临时密码登录:
mysql -u root -p
输入密码:Ctdsfs
12.设置root的密码:
mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY 'Ocft@022';
13.开放远程登录权限:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Ocft@2022'
WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
14.开放mysql的3306端⼝(注:先查看firewall是否开启):
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
如果出现乱码: 在链接地址栏后添加 useUnicode=true&characterEncoding=utf-8
二、卸载
1.查看mysql的安装情况
rpm -qa | grep -i mysql
2.执行删除rpm -ev 删除上面所有的文件
rpm -ev 查询出来的几个 --nodeps
3.删除mysql相关文件
find / -name mysql
通过rm -rf删除上面的文件
4.在执行一次:rpm -qa | grep -i mysql和find / -name mysql查看是否删除干净