linux安装mysql5.7(详细步骤)

这里用的rpm方式安装

1.下载rpm压缩包下载地址

 2.服务器检查安装

    运行rpm -qa | grep mariadb

    如果有卸载掉  yum -y remove 文件名

3.上传文件并解压

software和mysql文件目录看个人习惯

tar -xvf mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql/

 

 4.安装运行

npm -ivh mysql-community-common-5.7.36-1.el7.x86_64.rpm

npm -ivh mysql-community-libs-5.7.36-1.el7.x86_64.rpm

npm -ivh mysql-community-libs-compat-5.7.36-1.el7.x86_64.rpm

npm -ivh mysql-community-client-5.7.36-1.el7.x86_64.rpm

npm -ivh mysql-community-server-5.7.36-1.el7.x86_64.rpm

一般不会失败，中途哪个安装失败百度吧 

5.启动mysql服务

systemctl start mysqld

6.连接重置mysql密码

 查看密码：cat /var/log/mysqld.log | grep password

 修改命令：alter user 'root'@'localhost' identified by '123456';

                   flush privileges;

 ​​​​​

 如报错运行：set global validate_password_policy=LOW;

                       set global validate_password_length=6;

退出用新密码重新连接

 

7.设置mysql远程连接

1.user mysql

2.select user ,host from user 

3.update user set host ='%' where user ='root';

 4.flush privileges; //立即生效

8.防火墙问题

1.关闭防火墙

2.开放3306端口

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

firewall-cmd --reload

9.编码设置

 1.命令：vi /etc/my.cnf

 2.添加

#add charset

character-set-server=utf8

[client]

default-character-set=utf8

[mysql]

default-character-set=utf8

3.重启mysql服务

systemctl restart mysqld.service

安装结束可用navicat连接看看