linux启动项目报连不上mysql_linux中安装mysql 5.7

1.官网下载Linux版本mysql的rpm安装包(4个)

mysql-community-common-5.7.27-1.el7.x86_64.rpm

mysql-community-libs-5.7.27-1.el7.x86_64.rpm

mysql-community-client-5.7.27-1.el7.x86_64.rpm

mysql-community-server-5.7.27-1.el7.x86_64.rpm

2.上传rpm安装包到服务器/usr/local/jqf_installs/mysql目录中，同时删除之前的旧的跟mysql依赖有关的内容

查看mysql依赖命令

rpm -qa | grep -i mysql

删除mysql依赖命令

rpm -ev mysql-libs-* --nodeps

3.依次执行命令安装(有顺序关系，因为它们之间存在依赖关系)

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

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

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

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

安装libs安装包时如果报以下错误：

error: Failed dependencies:mysql-community-common(x86-64) >= 5.7.9 is needed by mysql-community-libs-5.7.27-1.el7.x86_64mariadb-libs is obsoleted by mysql-community-libs-5.7.27-1.el7.x86_64

解决办法：清除yum里所有mysql依赖包，清除完后重新开始安装第一个包

rpm -qa|grep mysql

yum remove mysql-libs

安装server安装包时如果报以下错误：

error: Failed dependencies:libaio.so.1()(64bit) is needed by mysql-community-server-5.7.27-1.el7.x86_64libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-5.7.27-1.el7.x86_64libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-5.7.27-1.el7.x86_64

解决办法：安装libaio依赖，就可以继续安装mysql

yum install libaio

4.安装完成，执行此命令初始化数据库：(新版的推荐此方法，执行后会在/var/log/mysqld.log生成随机密码)

mysqld --initialize

5.更改mysql数据库目录的所属用户及其所属组(即给mysql文件夹授权)

chown mysql:mysql /var/lib/mysql -R

6.启动数据库服务

启动/停止/重启::systemctl start mysqld.service/systemctl stop mysqld.service/systemctl restart mysqld.service

7.使用root账号登录数据库，(随机密码去日志文件/var/log/mysqld.log查看)

mysql -u root -p

8.修改密码

set password='root';

9.root用户授权只能本机访问

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

flush privileges;

10.创建用户并授权远程连接

CREATE USER 'jiaqiufeng'@'%' IDENTIFIED BY 'jiaqiufeng';

GRANT ALL PRIVILEGES ON *.* TO 'jiaqiufeng'@'%' WITH GRANT OPTION;

flush privileges;

退出mysql：

exit;

11.关闭防火墙或开放3306端口

配置防火墙

//打开防火墙文件

sudo vim /etc/sysconfig/iptables

//新增一行 开放3306端口

-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

//保存退出

//重启防火墙

sudo systemctl restart iptables.service

在外部访问CentOS中部署应用时，需要关闭防火墙。

关闭防火墙命令：systemctl stop firewalld.service

开启防火墙：systemctl start firewalld.service

关闭开机自启动：systemctl disable firewalld.service

开启开机启动：systemctl enable firewalld.service

12.将mysql服务加入开机启动

systemctl enable mysqld.service