如何在Liunx环境下安装mysql

下载mysql安装包

1.点击链接后选择msql版本
2.点击Download进入下载页面

image.png
3.右键复制连接诶
image.png
4.安装wgetyum -y install wget
5.输入命令 wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm地址是刚才复制的地址

安装mysql

yum -y localinstall mysql80-community-release-el7-3.noarch.rpm

image.png

安装mysql-server

yum -y install mysql-community-server

image.png

启动mysql

systemctl start mysqld

设置开机启动

systemctl enable mysqld

systemctl daemon-reload

查看密码

cat /var/log/mysqld.log | grep password

修改密码

1.登录mysqlmysql -uroot -p
2.输入查看到的密码
3.密码最小12位ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
4.输入exit;退出后，重新用新密码登录

远程访问授权

create user 'root'@'%' identified with mysql_native_password by '新密码';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;

打开防火墙开放3306端口

systemctl start firewalld
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

配置默认编码

1.使用vim打开/etc/my.cnf配置文件vim /etc/my.cnf
2.增加mysql的默认配置参数

image.png
3.重启mysql服务：systemctl restart mysqld
4.登录mysql，查看编码show variables like '%character%';
image.png
5.在阿里云的南拳规则组中打开3306端口
6.使用Navicat链接mysql
image.png