1、下载
方式1:
点击链接http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm,下载rpm文件
方式2:
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
2、安装
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server
成功后出现如下页面
异常情况处理一:提示“公钥尚未安装”
报错信息:
mysql-community-libs-compat-5.7.37-1.el7.x86_64.rpm 的公钥尚未安装
失败的软件包是:mysql-community-libs-compat-5.7.37-1.el7.x86_64
处理方式:
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
执行完此命令后,再重新执行yum -y install mysql-community-server
3、启动mysql
systemctl start mysqld.service //启动
service mysqld status //查看运行状态
netstat -tnlp | grep 3306 //查看是否启用3306端口
4、初始化配置
grep "password" /var/log/mysqld.log //查询root初始密码
mysql -uroot -p //登录
//首次操作要求重置密码,必须大小写特殊字符组成
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
//授权远程访问 % 表示所有主机都可以访问
mysql> grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
//刷新权限信息
mysql> flush privileges
5、修改字符集
vi /etc/my.cnf
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
//重启 mysql
systemctl restart mysqld.service
//查看是否配置成功
mysql> status;
6、修改密码
方式1:设置当前登录用户密码
mysql> set password=password('newpassword');
方式2: 直接改用户表
mysql> use mysql;
mysql> update user set authentication_string=password('123abc') where user='root';
方式3: 修改密码
mysql> alter user root@'localhost' identified by '123456';