1.2、Mysql包安装

1.程序包管理器管理的程序包    测试环境使用
2.源代码编译安装       工作条件下使用源码编译实现多实例
3.二进制格式的程序包:展开 至特定路径，并经过简单配置后即可使用
程序包安装
测试环境


CentoS 8:安装光盘直接提供
	mysql-server: 8.0
	mariadb-server : 10.3.17
Centos 7:安装光盘直接提供
	mariadb-server: 5.5服务器包
	mariadb
CentOs 6:
	mysql-server: 5.1 服务器包. 
	mysql客户端工具包

 
 CentoS 8:安装光盘直接提供  
 ----------------------
 # yum info  mysql-server mariadb-server
 # yum install -y mysql-server
 # rpm -ql mysql-server |grep "service$"  
 # ls /var/lib/mysql  #数据库系统初始化核心文件，自己生成的库表都放在本目录下
 # systemctl enable --now  mysqld   #启动数据库服务
 # id mysql                     #查看新生成数据库信息
 # getent passwd mysql          #查看新生成数据库信息
 # pstree  -p                   #查看进程和线程编号
 # cat /proc/`pidof mysqld`/status   #查看进程中线程的数量
 # mysql  
 
 总结：
  # yum install -y mysql-server
  # systemctl enable --now  mysqld 
  # mysql  
  
 
 
 Centos 7:安装光盘直接提供 
 ----------------------
 https://dev.mysql.com/downloads/file/?id=484922
 # yum info mariadb-server
 # yum install -y mysql80-community-release-el7-3.noarch
 # yum list |grep mysql       #列出mysql拥有的版本号
 # yum install -y mysql-community-server.x86_64  
 # systemctl enable --now  mysqld
 # mysql
 
 总结：
 # yum install -y mysql80-community-release-el7-3.noarch
 # yum install -y mysql-community-server.x86_64  
 # systemctl enable --now  mysqld
 # mysql
 
 
 

搭建国内yum源mysql仓库
-------------------
   mysql :5.7  
   ----------
[root@centos7.9 ~]# vim /etc/yum.repos.d/mysql.repo
[mysql]
name=mysql5.7
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-5.7-community-el7-x86_64/
gpgcheck=0
# yum list  |grep  mysql 
# yum  install -y   mysql-community-server.x86_64 
# systemctl enable --now mysqld
# ls /var/lib/mysql
# ss -ntl              #默认打开3306端口
# mysql 

  MariaDB : 10.5.8
  ----------------
https://mariadb.org/download/#mariadb-repositories
[root@centos7.9 ~]# vim /etc/yum.repos.d/MariaDB.repo
# MariaDB 10.5 CentOS repository list - created 2021-01-31 07:42 UTC
# https://mariadb.org/download/
[mariadb]
name = MariaDB
baseurl = https://mirrors.tuna.tsinghua.edu.cn/mariadb/yum/10.5/centos7-amd64
gpgkey=https://mirrors.tuna.tsinghua.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1
# yum install -y MariaDB-server  
# systemctl enable  --now mariadb.service 
# mysql


centos8/7与ubuntu1804使用客户端连接数据库
-------------------------------------  
  centos8
  -------
[root@centos8-2 ~]# mysql

  centos7   mysql5.7版本
  --------
# mysql -uroot -p'5Y_uL=ygy.Yc'
# cat /var/log/mysqld.log|grep password  显示功能密码只能当连接使用，需要修改密码才能使用mysql数据库
mysql> ALTER USER root@'localhost' identified by '1';   

修改mysql登录密码
[root@centos7.9 ~]#  mysqladmin -uroot -p'1'
password '1'
exit
  ubuntu1804
  ----------
# apt install -y mysql-server
# systemctl status mysql.service
# mysql           #默认自动登录mysql数据库
 mysqladmin -uroot -p'Qp9yOwp49o,-' password  '1';