linux安装mysql

一、下载安装包并启动
1.安装wget (已有wget忽略这一步)

yum install -y wget

2.下载mysql安装包
3.安装mysql源

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm 
yum localinstall mysql57-community-release-el7-8.noarch.rpm
tar -xvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz 

Is this ok [y/d/N]: y

4.检查安装成功 ：
5.安装mysql ：

yum repolist enabled | grep "mysql.*-community.*"
yum install mysql-community-server

Is this ok [y/d/N]: y
是否继续？[y/N]：y

6.查看mysql启动状态
7.启动mysql服务

systemctl status mysqld
systemctl start mysqld

二、开机启动设置

systemctl enable mysqld
systemctl daemon-reload

三、修改root密码
1.查看临时密码

grep 'temporary password' /var/log/mysqld.log

2.可以看到临时密码是末尾的字符串：******
3.登录

mysql -uroot -p

4.输入临时密码 ：********
5.修改新密码为Abc@0725 ，并且退出

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Abc@0725';
exit

7.进入配置文件

vi /etc/my.cnf

8 i 进入编辑模式
9.修改密码策略： validate_password = off
10退出：ESC :wq保存
11.重启mysql：systemctl restart mysqld
12.登录：mysql -uroot -pDcl@0725
13.修改密码：ALTER USER “root”@“localhost” IDENTIFIED BY “root”;
14.退出：exit
15.使用新密码登： mysql -uroot -proot

四、sqlyog远程连接Linux的mysql
1.远程连接：grant all privileges on *.* to root@"%" identified by ".";
2.刷新 ：flush privileges;
3.新窗口关闭linux防火墙： service firewalld stop