Linux安装mysql

官网下载linux版本安装包:

downloads.mysql.com/archives/community/

 使用：FTP工具

        https://pan.baidu.com/s/1KYttCv9P-_D5XnpDqCO2Hg

        提取码：6666  

上传mysql压缩包到服务器。

创建mysql目录：

        mkidr mysql

进入mysql目录：

cd mysql

解压mysql安装包:

        tar -xvf mysql-8.0.28-1.el7.x86_64.rpm-bundle.tar 

 安装mysql文件，需要按顺序执行

rpm -ivh mysql-community-common-8.0.28-1.el7.x86_64.rpm 

rpm -ivh mysql-community-client-8.0.28-1.el7.x86_64.rpm 

查询是否安装MariaDB：

       [root@localhost mysql]# rpm -qa | grep mari
       mariadb-libs-5.5.65-1.el7.x86_64
       marisa-0.2.4-4.el7.x86_64

如果有安装，删除：

      rpm -e --nodeps mariadb-libs

      rpm -e --nodeps marisa

rpm -ivh mysql-community-libs-8.0.28-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-compat-8.0.28-1.el7.x86_64.rpm

yum install openssl-devel -y
 

rpm -ivh mysql-community-devel-8.0.28-1.el7.x86_64.rpm 

rpm -ivh mysql-community-icu-data-files-8.0.28-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-8.0.28-1.el7.x86_64.rpm 
 

安装完成，启动mysql

systemctl start mysqld

登录：

mysql -u root -p

Naivcat 连接遇到的问题：

1.先检测虚拟机是否能ping通本地

2.检测本地是否能ping通服务器 

3.是否能telnet 3306端口

[root@centos7 ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent

FirewallD is not running

[root@centos7 ~]# systemctl status firewalld

        ● firewalld.service - firewalld - dynamic firewall daemon

        Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)

        Active: inactive (dead) #表示防火强未启动

        Docs: man:firewalld(1)

启动防火墙

[root@centos7 ~]# systemctl start firewalld

[root@centos7 ~]# systemctl status firewalld

        ● firewalld.service - firewalld - dynamic firewall daemon
                Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)

                Active: active (running) since Sun 2021-03-07 20:57:40 CST; 9s ago #active (running)表示防火墙已启动

                Docs: man:firewalld(1)

                Main PID: 29918 (firewalld)

                CGroup: /system.slice/firewalld.service

                                └─29918 /usr/bin/python2 -Es /usr/sbin/firewalld --nofork --nopid 

放通防火墙 

[root@centos7 ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent 

再次telnet3306 ok

 4.Navicat新建连接报错1251：client does not support authentication

服务器登录mysql

alter user 'centos'@'%' identified with mysql_native_password by 'Qq_123456';

flush privileges;