linux7.6 -mysql5.7在线安装

在线安装方式:

步骤一:

 rpm -ivh https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

步骤二:

yum install -y mysql-server

步骤三:

systemctl start mysqld

步骤四；

systemctl  enable mysqld

步骤五:

systemctl stop firewalld 
或者  开放端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent   
firewall-cmd --reload

步骤六: 初始化密码

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

Tip:如果默认密码登陆不上操作

修改 /etc/my.cnf，在 [mysqld] 小节下添加一行：skip-grant-tables=1
systemctl restart mysqld
 mysql：mysql -u root

步骤七:修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

Tip:如果报错操作

use mysql;

update user set authentication_string = password('123456'), password_expired = 'N', password_last_changed = now() where user = 'root';

步骤八:修改远程登陆权限

update user set Host='%' where User='root';

步骤九:刷新权限

FLUSH PRIVILEGES; 

步骤十:重启mysql

systemctl restart mysqld