Liunx中mysql服务

myspl服务

---

mysql安装

安装方式有三种：

• 源代码：编译安装
• 二进制格式程序包
• 程序包管理器管理的程序包：
  - rpm安装
  - deb

演示

安装mysql5.7yum源（8.0以上版本需要收费）

[root@zsr ~]# rpm -Uvh http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

安装报错 总结1

[root@zsr ~]# yum -y install mysql-community-client mysql-community-commom mysql-community-devel mysql-community-libs mysql-community-server

关闭防火墙

[root@zsr src]# systemctl disable --now firewalld
[root@zsr src]# vim /etc/selinux/config 
[root@zsr src]# setenforce 0
[root@zsr src]# 

mysql配置

开启服务并设置开机自启

[root@zsr src]# systemctl start mysqld
[root@zsr src]# systemctl enable mysqld
[root@zsr src]# systemctl status mysqld

查看临时密码(只能用一次)

[root@zsr ~]# grep password /var/log/mysqld.log 
2022-12-27T08:54:31.980247Z 1 [Note] A temporary password is generated for root@localhost: Vm6Q.YVrdBvf

使用临时密码登入到数据库中

[root@zsr ~]# mysql -uroot -p'Vm6Q.YVrdBvf'

设置密码(密码要求：大小写字母数字特殊符号并且大于八位)

mysql> set password = password("Zsr2002123!");

防止自动更新删除yum源

[root@zsr ~]# rpm -e mysql57-community-release-el7-10.noarch

远程连接

创建授权

给予权限

mysql> grant all on *.* to 'root'@'192.168.17.1' identified by 'Zsr2002123!';

使用workbeach远程登录

创建新连接

登入成功

使用Navicat远程登录

创建连接

成功登入

总结

1.安装报错

安装mysql时报错 没有找到软件代表安装的mysql源有问题
[root@zsr ~]# yum -y install mysql-community-client mysql-community-commom mysql-community-devel mysql-community-libs mysql-community-server
Last metadata expiration check: 0:01:30 ago on Tue 27 Dec 2022 04:33:19 PM CST.
All matches were filtered out by modular filtering for argument: mysql-community-client
No match for argument: mysql-community-commom
All matches were filtered out by modular filtering for argument: mysql-community-devel
All matches were filtered out by modular filtering for argument: mysql-community-libs
All matches were filtered out by modular filtering for argument: mysql-community-server
Error: Unable to find a match: mysql-community-client mysql-community-commom mysql-community-devel mysql-community-libs mysql-community-server
[root@zsr ~]# 

解决方案：
到源页面使用wget下载

[root@zsr src]# wget http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-client-5.7.40-1.el7.x86_64.rpm http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-common-5.7.40-1.el7.x86_64.rpm http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-devel-5.7.40-1.el7.x86_64.rpm http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-libs-5.7.40-1.el7.x86_64.rpm http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-server-5.7.40-1.el7.x86_64.rpm
通过yum安装
[root@zsr src]# yum -y localinstall *.rpm