【MySQL】5.7安装和配置

安装

• 安装yum源

wget https://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

sudo yum install mysql57-community-release-el7-10.noarch.rpm

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

• 安装MySQL

yum install -y mysql-community-server

• 启动MySQL

systemctl start mysqld.service

• 查看运行状态

systemctl status mysqld.service

卸载

• 查看是否有安装mysql版本组件

rpm -qa|grep mysql

• 卸载MySQL服务

rpm -ev [需要移除组件的名称]

rpm -e --nodeps [需要移除组件的名称] 

此命令为强制卸载

• 删除数据库文件

sudo rm -rf /var/lib/mysql/*

配置

• 修改密码安全限制

vim /etc/my.cnf

validate_password_policy=0
validate_password_length=1

• 重启mysql服务

systemctl restart mysqld.service

• 获取安装时的临时密码

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

• 使用临时密码登录

mysql -u root -p

• 修改密码

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

• 授权远程访问

grant all privileges on *.* to root@"%" identified by "xxx";

flush privileges;