bundle-mysql安装方式

Linux bundle安装mysql数据库方式

一、清除Centos7系统中的mariadb,否则不能安装

rpm -qa | grep mariadb | xargs yum remove -y

二、安装MySQL

1. 下载mysql-rpm-bundle 安装包
   mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar

2. 将安装包上传到虚拟机 /usr/local/mysql目录，解压安装包

   tar -xvf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar
   

3. 切换到你的包下载目录。然后对每个包进行一次安装：

   sudo rpm -ivh mysql-community-common-5.7.27-1.el7.x86_64.rpm
   sudo rpm -ivh mysql-community-libs-5.7.27-1.el7.x86_64.rpm
   sudo rpm -ivh mysql-community-libs-compat-5.7.27-1.el7.x86_64.rpm 
   sudo rpm -ivh mysql-community-embedded-5.7.27-1.el7.x86_64.rpm
   sudo rpm -ivh mysql-community-embedded-compat-5.7.27-1.el7.x86_64.rpm 
   sudo rpm -ivh mysql-community-devel-5.7.27-1.el7.x86_64.rpm
   sudo rpm -ivh mysql-community-embedded-devel-5.7.27-1.el7.x86_64.rpm
   sudo rpm -ivh mysql-community-client-5.7.27-1.el7.x86_64.rpm 
   sudo rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm 
   

4. 修改MySQL配置

   sudo vim /etc/my.cnf 
   

   添加下面两行

   character_set_server=utf8

   init_connect=‘SET NAMES utf8’

5. 初始化数据库

   mysqld --initialize
   

6. 修改 /var/lib/mysql 的权限

   sudu chowm -R mysql:mysql /var/lib/mysql
   sudo chmod -R 777 /var/lib/mysql
   

7. 启动mysql：

   设置开机启动：

   sudo systemctl enable mysqld
   

   启动mysql：

   sudo systemctl start mysqld
   

   查看mysql状态:

   sudo systemctl status mysqld
   

   查看临时root临时密码：

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

   登录mysql:

   mysql -uroot -p输入临时密码
   

8. 修改密码

   alter user user() identified by "root";
   

   ​

卸载mysql

1. 查询是否安装了mysql

rpm -qa | grep -i mysql

2. 关闭mysql服务

service mysql status
service mysql stop

3. 查看mysql相关文件夹

find / -name mysql

4. 卸载安装的mysql组件服务

rpm -ev mysql-community-common-5.6.44-2.el7.x86_64
rpm -ev mysql-community-release-el7-5.noarch
rpm -ev mysql-community-client-5.6.44-2.el7.x86_64
rpm -ev mysql-community-server-5.6.44-2.el7.x86_64
rpm -ev mysql-community-libs-5.6.44-2.el7.x86_64

5. 删除与mysql相关的文件夹
6. 查看是否删除

rpm -qa | grep -i mysql