Linux安装Mysql

1.查看内核

cat /proc/version  

hostnamectl

 2.下载yum源，根据linux内核选择版本

        mysql官方下载页：MySQL :: MySQL Community Downloads

 3.下载完成后，在服务器上创建mysql文件目录，上载rpm文件，可以看到我这里是el7，所以我下载的el7-6

 4.将下载的yum源，加载到系统yum源里

sudo rpm -Uvh mysql80-community-release-el7-6.noarch.rpm

5.安装mysql

sudo yum install mysql-community-server   （先看下面注释）

注：执行上面的命令，会默认安装最新版本mysql 8，如果要安装低版本，需要修改配置文件

vim /etc/yum.repos.d/mysql-community.repo

 注2：在安装时，遇到了一个error

Downloading packages:
warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-libs-compat-5.7.38-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022


GPG key retrieval failed: [Errno 14] curl#37 - "Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022"

 解决方案：rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

6.上面问题解决掉就安装成功了

查看版本并启动mysql：

mysql -V   systemctl start mysqld  systemctl status mysqld

 7.顺便从log里拿一下数据库初始密码，然后登陆mysql修改密码

[root@hrs-master mysql]# sudo grep 'temporary password' /var/log/mysqld.log
2022-07-18T07:28:55.036209Z 1 [Note] A temporary password is generated for root@localhost: #wR_fb=C4f)l

8.修改'root'@'localhost'密码，顺便加一个远程访问的'root'@'%'帐号，赋权限，刷新用户

create user 'root'@'%' identified with mysql_native_password by 'root';

ALTER USER 'root'@'localhost' IDENTIFIED BY '12345';

grant all privileges on *.* to 'root'@'%' with grant option;

flush privileges;

注：又遇到一个错，大概意思就是鄙视你密码太简单了，查了下需要大小写，特殊符号，数字，并且长度>=8

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

9.修改一下编码，改完重启

vim /etc/my.cnf

character_set_server=utf8
init_connect='SET NAMES utf8'

systemctl restart mysqld

 10.最后如果远程连不上，考虑一下防火墙端口问题，开放一下3306端口

systemctl status firewalld  

systemctl start firewalld

firewall-cmd --zone=public --add-port=3306/tcp --permanent

firewall-cmd --reload

---

补充一个卸载流程：

1.看一下都安装了哪些mysql的包

rpm -qa|grep -i mysql

2.卸载包

rpm -ev MySQL-client-5.5.25a-1.rhel5 --nodeps

3.查看创建的目录

find / -name mysql

4.全部删除

rm -rf /usr/lib64/mysql

5.最后把my.cnf也拿掉

rm -rf /etc/my.cnf