数据库系统结构
1.数据库系统DBS :
1.数据库管理系统DBMS(DataBase Manager System):SQL(RDS关系型数据库)
2.SQL语言(结构化查询语言)
3.数据访问技术
在MySQL官网上找到yum包下载找到CentOs对应版本,下载到计算机上,通过rz上传到虚拟机中
安装MySQL的 yum包
yum -y install mysql80-community-release-el7-4.noarch.rpm
vim /etc/yum.repos.d/mysql-community-source.repo
vim /etc/yum.repos.d/mysql-community.repo
(我要安装的MySQL版本是5.7)
只需要5.7版本出改为1就行了
name=MySQL 5.7 Community Server - Source baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/SRPMS enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
刷新缓存 yum makecache
输入yum list | grep mysql
安装 yum -y install mysql-community* 显示有冲突
重新输入
yum -y install mysql-community* --skip-broken
等待安装完成后启动服务
systemctl start mysqld
进入MySQL显示要输入密码 通过
[root@localhost ~]# grep password /var/log/mysqld.log 2021-11-05T06:15:55.411363Z 1 [Note] A temporary password is generated for root@localhost: l3WLguoEkj(m 2021-11-05T06:16:14.044932Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
找到密码后进入MySQL后面password ‘写要修改的密码’
mysqladmin -uroot -p'l3WLguoEkj(m' password '********'
mysql -uroot -p'*********'登录即可
配置自建MySQL 的yum源仓库(两台虚拟机 ) 一台服务器 一台客户机
服务器操作
1. 安装FTP yum -y install vsftpd
2.准备文件夹 mkdir /var/ftp/mysql57
3.将Windows下载好的传到虚拟机中
rz上传完之后 安装
yum -y install mysql80-community-release-el7-4.noarch.rpm
4.仅下载不安装MySQL
yum -y install --downloadonly mysql-community-server
5.查找下载的MySQL安装包
find /var/cache/yum/x86_64/7/ -name "*.rpm" -exec cp -rf {} /var/ftp/mysql57 \;
6.创建依赖关系
[root@localhost mysql57]# cd /var/ftp/mysql57 [root@localhost mysql57]# yum provides createrepo 已加载插件:fastestmirror Loading mirror speeds from cached hostfile * base: mirrors.aliyun.com * extras: mirrors.aliyun.com * updates: mirrors.aliyun.com createrepo-0.9.9-28.el7.noarch : Creates a common metadata repository 源 :base [root@localhost mysql57]# yum -y install createrepo [root@localhost mysql57]# createrepo /var/ftp/mysql57/
7.启动ftp
systemctl start vsftpd
客户机操作
1.自建yum仓库
[root@localhost ~]# vim /etc/yum.repos.d/mysql157.repo [mysql57] name=ftpfiles baseurl=ftp://192.168.31.141/mysql57 gpgcheck=0 enabled=1
2.安装
[root@localhost ~]# yum makecache mysql57 | 2.9 kB 00:00
yum -y install mysql-community-server
3.启动MySQL
systemctl start mysqld
查找默认密码 grep password /var/log/mysqld.log
2021-11-05T10:05:04.888297Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: nex.fkc<32dS
4.登录mysql
mysqladmin -uroot -p'nex.fkc<32dS' password '*********'
5.登录数据库
mysql -uroot -p'********'