Linux安装mysql5.7

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
安装MySQL 
yum -y install mysql-community-server
mysql -V
systemctl start mysqld.service && systemctl status mysqld.service
grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;

# 如果安装失败 出现密钥过期的error
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

卸载旧的release文件
rpm -e --nodeps mysql-community-release-el7-5.noarch
flush privileges;

mysql配置文件为 vim /etc/my.cnf
最后加上编码配置
[mysql]
default-character-set =utf8

常用命令 

systemctl status mysqld 
systemctl start mysqld 
systemctl stop mysqld 
systemctl restart mysqld 
systemctl enable mysqld 
systemctl status mysqld 

systemctl stop mysqld && systemctl start mysqld  &&  systemctl status mysqld 
systemctl start mysqld

如果显示没有权限，需要修改mysql的所属组和账号

# 可以在vim /etc/my.cnf查看mysql.sock的位置
chown mysql:mysql -R /var/lib/mysql/mysql.sock
find / -name mysql.sock
chmod  755 -R mysqld/ && chown root:root  -R mysqld/

进入mysql

mysql -uroot -p
mysql -uroot -proot

如果进入失败

vim /etc/my.cnf
skip-grant-tables
systemctl  stop mysqld && systemctl  start mysqld
systemctl  status mysqld 
mysql -uroot  -p

修改密码

use  mysql;
set password for 'root'@'localhost' =password('root');
update user set authentication_string=password('root') where user='root';

flush privileges;

修改密码强度规范

set global validate_password_policy=LOW;
set global validate_password_length=4;
set global validate_password_policy=0;
flush privileges;

删除配置

vim /etc/my.cnf
skip-grant-tables
systemctl restart mysqld
mysql -uroot  -proot

更新mysql

mysql_upgrade  -uroot -proot;

允许远程访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

#从/var/log/mysqld.log获取mysql初始密码
grep password /var/log/mysqld.log